Hi,
How can I split 03 words into two, like -
Name = Sachin Ramesh Tendulkar
I want to split it as two ways -
“Sachin Ramesh” and “Tendulkar”
“Sachin” and “Ramesh Tendulkar”
Kindly help.
Assign activity:
Name = “Sachin Ramesh Tendulkar”
Assign activity:
FirstName = Name.Split(" “.ToCharArray)(0)
LastName = Name.Substring(FirstName.Length).TrimStart(” ".ToCharArray)
fullName = "Sachin Ramesh Tendulkar"
resultScenario1 = String.Join(" ", fullName.Split(" "c).Take(2)), resultScenario2 = String.Join(" ", fullName.Split(" "c).Skip(2))
fullName = "Sachin Ramesh Tendulkar"
resultScenario1 = fullName.Split(" "c)(0), resultScenario2 = String.Join(" ", fullName.Split(" "c).Skip(1))
Hope it helps!!
in assign
inttt_string = “Sachin Ramesh Tendulkar”
in assign
first_name_str= inttt.Split(" “.ToCharArray)(0)+ " " +inttt.Split(” ".ToCharArray)(1)
“Sachin Ramesh”
inttt.Split(" ".ToCharArray)(0)+ " " +inttt.Split(" ".ToCharArray)(1)
in assign
last_name_str = inttt.Split(" ".ToCharArray)(2)
“Tendulkar”
inttt.Split(" ".ToCharArray)(2)
“Ramesh Tendulkar”
ttt.Split(" ".ToCharArray)(1)+ " " +inttt.Split(" ".ToCharArray)(2)
or
are you can use this ways also in below image
“Sachin Ramesh”
String.Join(" ", inttt.Split(" "c).Take(2))
“Tendulkar”
String.Join(" ", inttt.Split(" "c).Skip(2))
“Sachin”
inttt.Split(" "c)(0)
“Ramesh Tendulkar”
String.Join(" ", inttt.Split(" "c).Skip(1))
cheers…!
FYI, another approach: can you try the following?
System.Text.RegularExpressions.Regex.Split(yourString,"(?<=^\S+)\s")
System.Text.RegularExpressions.Regex.Split(yourString,"\s(?=\S+$)")
Assign activity=> Name = "Sachin Ramesh Tendulkar"
Assign activity=> NamesArray = Name.Split(" "c)
Assign activity=> FirstName = NamesArray.Take(2).Aggregate(Function(x, y) x + " " + y).Trim()
Assign activity=> LastName = NamesArray.Skip(2).Aggregate(Function(x, y) x + " " + y).Trim()
Log Message: FirstName
Log Message: LastName
Result:
FirstName= Sachin Ramesh
LastName= Tendulkar
Assign activity=> Name = "Sachin Ramesh Tendulkar"
Assign activity=> NamesArray = Name.Split(" "c)
Assign activity=> FirstName = NamesArray(0)
Assign activity=> LastName = NamesArray.Skip(1).Aggregate(Function(x, y) x + " " + y).Trim()
Log Message: FirstName
Log Message: LastName
Result:
FirstName= Sachin
LastName= Ramesh Tendulkar
NamesArray is of DataType Array(System.String)
Hope it helps!!
Hey, here are possibilities.
Using LastIndex:
int_IndexLastSpace = str_Name.LastIndexOf(" ")
"First Name : " + str_Name.Substring(0,int_IndexLastSpace) +
"Last Name : " + str_Name.Substring(int_IndexLastSpace,str_Name.Length - int_IndexLastSpace)
Using List:
List_Names = str_Name.Split(" "c).ToList
“First Name : " + String.Join(” ",List_Names.Take(List_Names.Count-1).ToArray).ToString +
"Last Name : " + List_Names(List_Names.Count-1).ToString
@buddhadeokamath
with the help of split function we can get required output!!
Name = “Sachin Ramesh Tendulkar”
Name.split(" “c)(0)+” “+Name.split(” "c)(1)
Name.split(" "c)(2)
Name.split(" "c)(0)
Name.split(" “c)(1)+” “+Name.split(” "c)(2)
below attached Image for all syntax:
Cheers!!
Hi,
Thanks for resolution.
The way you explained is so easy for me to understand.
1 Like