Split function for n mumber of data

Help
, , ,
1

Hello,

Heading 1
TXT1 - text1
TXT2 - text2
TXT3 - text3
TXT4 - text4

Heading 2
TXT1 - text1
TXT2 - text2
TXT3 - text3
TXT4 - text4

Heading 3
TXT1 - text1
TXT2 - text2
TXT3 - text3
TXT4 - text4

I am having the content like this in text file .txt so how can i split this into 3 parts using split function… heading 1, heading2 , heading 3,…i want to save it in excel like this…Like this i have so many headings…

image

Thanks,
Suresh.

1 Like
2

Hi,
Check out this file. It serves your purpose of splitting the data into 3 parts one for each heading.

Main.xaml (5.0 KB)

Regards,
JDoshi

1 Like
3

Thanks @JDoshi for your quick respose… i am not getting the output what i expect…

i need the output exactly what is there in the excel screen shot can you send the sample data with excel.because i am new to uipath…

Thanks in Advance…
Suresh.

1 Like
4

Hi @suresh_kumar4 ,

Sorry for delayed response.

PFA Main.xaml (14.5 KB) which converts data from .txt file to .xlsx file.

Please mark it as answer if it serves your purpose.