How to seperate text from browser to datatable?

Help Studio
, , ,
#1

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?

#2

@Supakinee_Navawong_na_ayu Can you please share the website screen shot. Thanks.

#3

Check this below workflow, @Supakinee_Navawong_na_ayu
Uipath_ConvertStringToTable.xaml (8.2 KB)
Hope this may help you :slight_smile:

#4

Thank you for your help.
This is my InputStr
image

after through FOR Each match
outputDT these is no data in it.
image

What 's am I wrong?

#5

Can you send me your input string in a text file ? @Supakinee_Navawong_na_ayu

#6

" No.|Id.Number|Name
1|701|เอ เอ
2|708|น น
3|BP4199631|ฮาจิ ไกรลูลา"

May I send you like this?

#7

Check this updated workflow, @Supakinee_Navawong_na_ayu
Uipath_ConvertStringToTable.xaml (8.2 KB)
Hope this will help :slight_smile:

#8

for the latest workflow ,
OuputDT is
image

Inputstr is
“No.|Id.Number|Name\r\n 1|701|เอ เอ\r\n2|708|น น\r\n3|BP4199631|ฮาจิ ไกรลูลา”

The first line is missing.
Please advise.

#9

Put the input string like this below, @Supakinee_Navawong_na_ayu
No.|Id.Number|Name
1|701|เอ เอ
2|708|น น
3|BP4199631|ฮาจิ ไกรลูลา

#10

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.

#11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.