Hi Team,
Please find attached text.file.
I am not able to copy it and paste it into an excel in correct format.
Please help on this…source.zip (487 Bytes)
2 Likes
Hi @jimmy_jos1
What exactly do you want with the text file kindly elaborate more to easily address the issue. Thanks.
cheers 
Happy learning
3 Likes
Hi @ pattyricarte
I want this text file to be pasted in excel in correct format…
1 Like
Hi @jimmy_jos1
Maybe want you want is to convert text file to excel file to be organize and more readable is that correct?
cheers
Happy learning
3 Likes
@pattyricarte Yes…
1 Like
Hi @jimmy_jos1
Fine
Scenario : 1. Use Read CSV Activity to read the text file. See image below for your reference.
Scenario : 2. Use Write Range Activity to write the read csv in to excel . See image for your reference.
Note : You need to use Excel Application Scope Activity . See image below for your reference.
cheers
Happy learning
3 Likes
Read Csv …?? but the file format is text…? Do i have to first use copy activity to covert text to csv?
2 Likes
3 Likes
Thanks in advance
Scenario 1 Create Data Table using Build Data Table Activity.
Scenario 2 Split your string using environment.newline ,space,tab or any special char append it into Datatable.
Scenario 3 Use Write Range Activity to Write The data into excel.
Hope this might be help!
cheers
Happy learning
3 Likes
Not working…
1 Like
Hi @jimmy_jos1
Sorry for that i failed to help you…Dont worry theres a lot of Masters of UIPATH here to help you.
cheers
Happy learning
4 Likes
Hi @jimmy_jos1
The variable Notepad is not on the right data type unid to use datatable for that variable.
cheers
Happy learning
4 Likes
@pattyricarte Unid ?
1 Like
3 Likes
ashokkarale
jast1631
Shruthika_r
justindward
Gaurav_Malhotra