Spilt Name

Help
1

I have excel sheet in the excel sheet name column i need to split name first name and last name after the enter the website

2

Fine
can we have a sample word to find what to split if possible
Cheers @damodar99

3

Hi @damodar99

Read the excel sheet data on to a datatable using a Read Range activity.

Then, use a For Each Row activity to loop through the data table
within the activity, use two assign activities to split the name into first and last name using space

First Name = row("Name").ToString.Split(" "c)(0).ToString
LastName =  row("Name").ToString.Split(" "c)(1).ToString
2 Likes