How to Split a String, check in below screenshot

Help Studio
, ,
1

image

image
image943×510 28.1 KB

image

2

you can have a look on this thread

3

Hi @Manju_Reddy_Kanughula

Try This

ClientInformation.Substring(ClientInformation.IndexOf("Client ID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Thnx & Regards
Loveleet Saini

4

Hey create 3 variables for client id name and country
and use this below regex to get id name and country from the input string
Regex:
(?<=Client ID: ).*
(?<=Client Name: ).*
(?<=Client Country: ).*

Regards

Sreejith S S

5

Hi @Manju_Reddy_Kanughula

Share the expression for generating this EQ75283- Kizzie Kohen- Italy value?

Check out the Split expression

Client ID

ClientID = ClientInformation.Substring(ClientInformation.IndexOf("Client ID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Client Name

ClientName = ClientInformation.Substring(ClientInformation.IndexOf("Client Name: ") + "Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Client Country

ClientCountry = ClientInformation.Substring(ClientInformation.IndexOf("Client Country: ") + "Client Country: ".Length).Split(Environment.NewLine.ToCharArray)(0)

In the Type Into Use like this : ClientID+"-"+ClientName+"-"+ClientCountry

Regards
Gokul

6

Arr_Str=Str.Split(Environment.NewLine.Tochararray,StringSplitOptions.RemoveEmptyEntities)

for 1st line Str1=Arr_Str(0)
for 2nd line Str2=Arr_Str(1)
for 3rd line Str3=Arr_Str(2)