Convert text file to Excel

[IndraVijay]

Hi All,

Can any one help me?.

How to convert text file to excel file.

Regards
Indra Vijay

[Akshay07 (Akshay Suryawanshi)]

Hello @IndraVijay,

You can refer to this post for the solution

Convert txt to xlsx

Hi @syaheed22 please find attached code which will convert text file data into excel headers. Steps Included Read data from text file. Split data by using split function delimiter as Environment.Newline which will return array. Assign New Datatable() to the Datatable. Use for each loop with add data column activity to add data to datatable as column. add a single datarow to datatable. Write range into excel file with Add headers option check. TextToExcel.zip (16.3 KB) Regards, Vijay Kumar…

[IndraVijay]

Thank you Akshay

[Akshay07 (Akshay Suryawanshi)]

@IndraVijay Hopefully that solves your query, if so please like or mark the above reply as the solution.

[Srini84 (Srinivas)]

@IndraVijay

Try with Generate Datatable activity and use Write Range activity

Refer below for write Range and Build Datatable activities reference

RPA DataTable: Get Previous Row Column Value, Set to Current Row Column Value

sorry i can not use this solution… As I want to Read Next row value before i continue to regiser the current row… my issue is When i have done reading current row through if statement … then I want to know… the next row Category before continue… And if there is no category or no row in table which has Category … then it should continue and register the current row in systerm… But it giving me error when it there is no row in system–

Hope this helps

Thanks

[IndraVijay]

Hi,
not yet resolved, I try that code, that is one column data are coming in one row.

[Matt_S]

What does the text file look like? Any separators?

[IndraVijay]

Hi,
yes
the file like this

========================================================INFO==============================================================
[Batch Name] [Date] [Time] [ID::Times] [Status] [Test] [Pr=[Data]]

N10105300039 6/8/2020 2:05:21 PM 000001::01 Finish PASSED::01 OK=[:1111111,0606115,30003,50,1111111060611530003,50,11111110060611530003,:1111111,0606115,35002,50,1111111160611535002,50,01111111060611535002,:1111111,0606115,40002,50,1111111060611540002,50,01111111060611540002,:1111111,0606115,45001,50,1111111160611545001,50,11111111060611545001,]
N10105300039 6/8/2020 2:05:22 PM 000002::01 Finish PASSED::02 OK=[:2222222,0606115,30011,50,2222222060611530011,50,22222220060611530011,:2222222,0606115,35010,50,2222222060611535010,50,22222220060611535010,:2222222,0606115,40010,50,2222222060611540010,50,02222222060611540010,:2222222,0606115,45019,50,2222222060611545019,50,02222222060611545019,]

can you help to convert in excel file and match the duplicate record.
Regards

[Matt_S]

What should the output look like?

[IndraVijay]

Hi
The output like

test.xlsx (10.9 KB)

the data are separate with " : "