convert plain text into table with row and column

[Miya]

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
------------------------------

[Vikash011]

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
------------------------------

[michaeloneil]

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
------------------------------

[MohammedAbdul_S]

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
------------------------------