Separate the name

Hello :robot:
I have an excel file that contains employee information, and I want to enter this information on a form. I have a column with full employee names, and I want to separate the name to enter them into three sections in the form
For example, the name of the employee:
abeer_ahmad Sameer
result ::
abeer
ahmad Sameer

How can I separate the name

@Muneer_Alrashdan

If underscore is always present and say the string is in a variable str then

Str.Split({"-"},Stringsplitoptions.None)(0) gives first part of name

Str.Split({"-"},Stringsplitoptions.None)(1) gives second part of name

Cheers

Hi @Muneer_Alrashdan

for abeer_ahmad Sameer

Str.Split("“c)(0).toString = “abeer”
Str.Split(”
“c)(1).Split(” “c)(0).toString = “ahmad”
Str.Split(”__“c)(1).Split(” "c)(1).toString = “Sameer”

regards
Loveleet Saini

Hi,

If you need split it to "abeer","ahmad" and "Sameer", the following works.

arrStr = yourString.Split({"_"c," "c})

Then

arrStr(0)
arrStr(1)
arrStr(2)

If you need split it to "abeer" and "ahmad Sameer", the following will work.

arrStr = yourString.Split({"_"c})

Then

arrStr(0)
arrStr(1)

note: arrStr is String array type/

Regards,