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
can we have a sample word to find what to split if possible
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