Splitting data from a screen capture into a variable

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

  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

Thanks, will give it a try.

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.”

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