topic RE: convert plain text into table with row and column in Product Forum

convert plain text into table with row and column

Miya — Wed, 21 Sep 2022 20:08:00 GMT

Hi,
is there any option to convert plain text into table with rows and columns. currently i have text in separate row, i prefer to make them as table

------------------------------
Miya
------------------------------

RE: convert plain text into table with row and column

Vikash011 — Thu, 22 Sep 2022 10:00:00 GMT

Hi Miya,

Can you please share the sample data. Also, the sample format you are expecting as output.

Where do you want to save/receive the data.?

Regards,
Vikash

------------------------------
Vikash Anand
Application Development Team Lead
Accenture
------------------------------

RE: convert plain text into table with row and column

michaeloneil — Thu, 22 Sep 2022 21:00:00 GMT

Hi Miya

You could try using the Utility-Strings VBO with the action Split Text which will output to a collection if you have a suitable pattern you can use. For example if the text is separated by a comma (text1,text2,text3,text4 etc) this would work for you and once in a collection you can rename the columns using Utility - Collection manipulation Extended and action Rename Field.

Hope this helps

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: convert plain text into table with row and column

MohammedAbdul_S — Thu, 10 Aug 2023 06:45:00 GMT

Hi,

I got the data from Notepad into Collections but it came in one row. Now, I want to have this data into different columns.

Division# Contract#/ Name Address Type Change Field Address-Old ? all this came in one single column.

Please help me how to do it.

Thanks in advance for the help/suggestions.

------------------------------
Mohammed Abdul Shakeel
------------------------------