Hi,I need some help about how to seperate text from browser to datatable?
I have copy text from browser with has layout like,
HI-Risk Notification Infomation for Robot.
No.|Id.Number|Name
1|701|John
2|708|Jack
3|BP4199631|Diana
I want to get it into datatable with 3 columns No. / Id.Number / Name
What should I do?
vignesh.ks
(Vignesh Ks)
February 17, 2021, 4:46am
2
@Supakinee_Navawong_na_ayu Can you please share the website screen shot. Thanks.
Manish540
(Manish Shettigar)
February 17, 2021, 4:48am
3
Check this below workflow, @Supakinee_Navawong_na_ayu
Uipath_ConvertStringToTable.xaml (8.2 KB)
Hope this may help you
Thank you for your help.
This is my InputStr
after through FOR Each match
outputDT these is no data in it.
What 's am I wrong?
Manish540
(Manish Shettigar)
February 17, 2021, 7:25am
5
Can you send me your input string in a text file ? @Supakinee_Navawong_na_ayu
" No.|Id.Number|Name
1|701|เอ เอ
2|708|น น
3|BP4199631|ฮาจิ ไกรลูลา"
May I send you like this?
Manish540
(Manish Shettigar)
February 17, 2021, 7:33am
7
Check this updated workflow, @Supakinee_Navawong_na_ayu
Uipath_ConvertStringToTable.xaml (8.2 KB)
Hope this will help
for the latest workflow ,
OuputDT is
Inputstr is
“No.|Id.Number|Name\r\n 1|701|เอ เอ\r\n2|708|น น\r\n3|BP4199631|ฮาจิ ไกรลูลา”
The first line is missing.
Please advise.
Manish540
(Manish Shettigar)
February 17, 2021, 7:50am
9
Put the input string like this below, @Supakinee_Navawong_na_ayu
No.|Id.Number|Name
1|701|เอ เอ
2|708|น น
3|BP4199631|ฮาจิ ไกรลูลา
Inputstr is
“No.|Id.Number|Name\r\n 1|701|เอ เอ\r\n2|708|น น\r\n3|BP4199631|ฮาจิ ไกรลูลา”
because I use (ctrl+A) + (ctrl+C) to copy text from browser after that assign to string variable.
From your suggest i will replace /r/n with blank or space before check in for each loop.
Thank you very much for your help.
system
(system)
Closed
February 20, 2021, 8:05am
11
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.