Write segregated data to excel from non structured text file

activities

#1

Below is text file >> I want to write and segregate below data in excel format

ISIN 1234567662 ; id 345 ; name Ramesh ; location pune;
Number ;9034452234; ISIN 12335456345; id 346; name suresh ; location Mumbai
ISIN 12345456632 ; id 342 ; name kedar ; location nagar;
Number ;74567633455; ISIN 234345424555; id 344; name sameer ; location delhi
ISIN 1234567662 ; id 311 ; name Ramesh ; location pune;
Number ;9034452234; ISIN 12335456345; id 349; name suresh ; location Mumbai

Like
ISIN | id | name | location | number

How to do that ?


#2

@Shubhankar_Gadekar
Save file as csv
Read csv and use ; as delimiter it will provide datatable as output
Use Write excel activity and pass above datatable
Dont forget to give cell reference


#3

Thank You !! It worked :slight_smile:


closed #4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.