Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

convert plain text into table with row and column

Miya
Level 5

‎21-09-22 09:08 PM

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
------------------------------
0 Likes
3 REPLIES 3

Vikash011
Staff
Staff

‎22-09-22 11:00 AM

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

michaeloneil
MVP

‎22-09-22 10:00 PM

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

MohammedAbdul_S
Staff
Staff
In response to michaeloneil

‎10-08-23 07:45 AM

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