Extract Data by using string manipulation operation

[Sneha_Ambulkar]

I want to Extract Above data by using string manipulation operation

And i want to extract only
KJ93404
Garret Reising
Italy
out of that string

How to do this?

[Palaniyappan (Palaniyappan P)]

Hi
This can be done like this
If the above string is in variable named strinput then

In assign activity
strinput = String.Join(“”,Strinput.ToString.Split(Environment.Newline.ToArray()))

Another assign activity like this

stroutput_1 = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=Client Id).*(?=Client Name)”).ToString.Trim

stroutput_2 = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=Client Name).*(?=Client Country)”).ToString.Trim

stroutput_3 = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=Client Country).*”).ToString.Trim

Or we still got many options From our forum to handle this
Like

Level 3 assignment 1 extracting client information

Hi @John_Dara, First use a “Get Text” activity to capture the entire text as a block and then extract Client Name, Id and Country by using Split method. Let “Client_Block” be the string holding the text value, Assign a string variable, client_id = Client_Block.Split({"ID:","Client Name:"},StringSplitOptions.None)(1).Trim Here, our delimiters are “ID:” &“Client Name:”. So the text block is divided into 3 parts. String before"ID:", String in between “ID:” & “Client Name:”, string after Client…

Cheers @Sneha_Ambulkar

[aman_sheik]

@Sneha_Ambulkar

You can use regex for this

String bar = System.text.regularexpression.regex.match(your input,“(?<=Client ID:)(.*)”).value.trim

Same you can use for other also

Thanks,
Aman

[sagaryeole]

@Sneha_Ambulkar
You can get text one by one using Anchor Base.

Or else for your scenario try this,
CVAL.Split({VBLF},StringSplitOptions.None)(0).Trim.Split({“:”},StringSplitOptions.None)(1).Trim
CVAL.Split({VBLF},StringSplitOptions.None)(1).Trim.Split({“:”},StringSplitOptions.None)(1).Trim
CVAL.Split({VBLF},StringSplitOptions.None)(2).Trim.Split({“:”},StringSplitOptions.None)(1).Trim

CVAL is a variable

[Sneha_Ambulkar]

i got an error when i assign
ClientID = System.Text.RegularExpressions.Regrx.Match(outClientInfo.ToString,”(?<=Client Id).*(?=Client Name)”).ToString.Trim
where ClientID is String variable

[Palaniyappan (Palaniyappan P)]

That was a typo mistake buddy
It’s Regex not Regrx
That’s why

System.Text.RegularExpressions.Regex.Match(outClientInfo.ToString,”(?<=Client Id).*(?=Client Name)”).ToString.Trim

Cheers @Sneha_Ambulkar

[Sneha_Ambulkar]

yes i got it.

Thank You!

[Palaniyappan (Palaniyappan P)]

Awesome
Cheers @Sneha_Ambulkar