Hello please assist I am trying to convert this txt to excel but the data is in one column…
The headers are in row 3
Before sending the text remove the first 3 lines ..so in generate activity use string.join(environment.newline,rjsummaryoutput.split({environment.Newline},stringsplitoptions.none).skip(3)) so 3 lines are skipped from start and then use delimiter as semi colon and new line character as enter or newline
Cheers
1 Like
hello @pabaleloh
You can first use assign activity
add build data table activity and add header as you want
0 create variable count and give value 0
1 create variable arraytxt datatype stringArray
2 assign Split(arraytxt, vblf) for newline or use environment.newline
3 then loop it into for each you can get first line
4 ex,(row(0) is contains = ‘RI Extrax summary all rI’s (Revised 9 Aug)’ )
5 add condition if count is 3
then the value in row(3) is contains the 2024/01/01
now you can use assign activity and create variable like startdate and you can create multiple variable as you want value as per you request header
and last you can add add data row activity and store data into table and write it into excel you can get data as you want
please do needfull
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.