Splitting data from a screen capture into a variable

Help
1

Hi,

i am learning UIPATH, and enjoying it, i am busy getting info from a web page and need to write this to a database table.

firstly i would need to split the values.

an example of how the data would look is
Name:
Test
Username:
Ttest
Contact details:
Ttest@gmail.com
{cellnumber}

i would like to put the name, username and contact details into variables.

please help.

Thanks

2
  1. Split the string by new line into array of strings.

After split, the array will be

arr = {Name:, Test, UserName:, Ttest, Contact details:, Ttest@gmail.com, cellnumber}

  1. Access the name, username and address using index of array like below

name = arr(1)
username = arr(3)
contact = arr(5) + " " + arr(6)

Regards,
Karthik Byggari

3

Thanks, will give it a try.

4

Thanks that worked,

i am now trying to insert these values into a db table, i am using Execute Non Query.
and i get the error below.
i added Name, Surname, Contact to the parameters.

is there something i am missing out?

i have take this example from one of the topics as a base
“INSERT Into SqlDataTable (Column1,Column2,Column3) values (@value1,@value2,@value3)”

message": “Execute Non Query: String or binary data would be truncated.\r\nThe statement has been terminated.”

5

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