Write segregated data to excel from non structured text file

[Shubhankar_Gadekar]

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 ?

[rahatadi (Aditya Rahatekar)]

@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

[Shubhankar_Gadekar]

Thank You !! It worked