How to get the text after last semi colon ( ; ) ?
Note : The count of the semi colon ( ; ) will change for each text. but we need to identify the last semi colon ( ; ) and get the text next to it
Sample texts :
1 . Passenger car ; Mercedes-Benz ; C-Class
if you see there are 2 semicolons in this first text & 3 semicolons in this seond text
=> Assign -> StrVar = "Passenger car ; Mercedes-Benz ; C-Class"
=> Assign -> Output = StrVar.Split(";").Last.Trim
It will give the value after the last semi column.
Check the below image for better understanding.
Hope it helps!!
Assign activity:
LastSemicolonIndex = InputText.LastIndexOf(“;”)
Assign activity:
LastText = InputText.Substring(LastSemicolonIndex + 1).Trim()
Hello @Sathish_Kumar_S ,
You can use the Following expression:
String_Variable=Input_Var.Split(";"c).Last
Hope this Helps
Regards;)
Try once with the regex !
1.StringVariable = System.Text.RegularExpressions.Regex.Split(" Passenger car ; Mercedes-Benz ; C-Class",“;”).Last
For the reference you can see the below screen shot.
unfortunately, the text next to last semicolon is not working for majority for click text activities.
We need to get all the text next to first semicolon
For Example : 1 : Passenger car ; VW ; Touran, T-Roc
We need only VW ; Touran, T-Roc from about input text
Hello @Sathish_Kumar_S, try this:
Dim inputText As String = “Passenger car ; VW ; EOS, GOLF, PASSAT; PASSAT CC, POLO; SHARAN”
Dim splitText As String() = inputText.Split({";"c}, StringSplitOptions.RemoveEmptyEntries)
Dim lastText As String = splitText.LastOrDefault()
If Not String.IsNullOrEmpty(lastText) Then
’ Process the last text here
MessageBox.Show(lastText)
Else
’ No last text found
End If
Cheers 
if the ‘Passenger car ;’ is constant then you can use this regex pattern
stringvaraible = System.Text.RegularExpressions.Regex.Match(“Passenger car ; VW ; Touran, T-Roc”,“(?<=Passenger car ;\s).*”).Value
hey!Try this
inputText.Split(“;”.ToCharArray,2).Last
Hope it works
Have you tried this?
I hope you got the solution. If yes please mark it as solution to close the loop.
Anil_G
Yoichi
postwick
Palaniyappan
D_Okthree
Parvathy
bruno40
Praveen_Mudhiraj
supermanPunch
Kartheek_Battu