I want to understand
the difference between get texts and get secured text
Use string split using a delimiter to get first name and last name.Split returns an array. Lets say “userName” is the variable having full name and there is a space between first and last names.
userName.Split(" “c)(0).ToString gives you the first name
userName.Split(” "c)(1).ToString gives you the last name
Hope this helps…!!
I need to store all the 10 values after splitting in a excel (need to have 2 columns in excel). how to save these data in excel?
Build a data table with split values, and use Append/Write range excel Activities to write data table to Excel.