Split plain text into table

[mmostaquim]

Hi,

I have a dataset which is exported from SAP in the txt file. It is required to split txt file data into a table based on delimiter. Is there any VBO in Blue Prism that can split plain txt into a table?

Demo data:

222345  | Konto A   | 39500.45 

Required Output:

Regards,

Ekram

[Chakkravarthi_PR]

Hi @mmostaquim , 

After the split text you get this collection, what do you want to achieve from the collection? 
1. Is that to make the first row as Header? 

2. Does each line in the text file follow the same structure as the demo data provided?

3. Does the split text has special characters or escape sequences?

[michaeloneil]

Hi @mmostaquim 

Have you tried the Utility - Strings vbo with the action split text? it has the option to split text by character. Although i've never tried it with multiple columns required it will likely put all text into a single column. You could try it by dropping the text into excel then splitting it in there.