Split string from text?

[Tuannna1 (Tuan Anh)]

I want to split to 1 part
String1 = “RO345879”
Please guide me about it.
I tried using ExtractTable activity but didn’t get the information I wanted. I also tried trimming the string by newlines, but it is too slow!

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Tuannna1
Welcome to UiPath community
Use get text activity get the text and split it by using below code
Data.split(‘:’)(1)- this gives that text

[Tuannna1 (Tuan Anh)]

When I use your code it gets redundant “Name”.

[Divyanshu_Divyanshu]

String1.Split(":"c)(1).ToTrim
Let me know if it doesn’t work for you

[Tuannna1 (Tuan Anh)]

I tried a combination with subString:
out textRenderInfo.Split(":"c)(1).Substring(1,8)

The result is successful but if the value of TaxID changes there will be a problem.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Tuannna1
Can you give extracted text first from get text activity?

[arivu96 (Arivazhagan A)]

Try regex pattern
System.Text.RegularExpressions.Regex.Match(String1,@"(?<=TaxID:.*<=Name)").Value.ToString().Trim()

[Tuannna1 (Tuan Anh)]

@sangeethaneelavannan1

Can you give extracted text first from get text activity?

Well, the text is below:
“TaxID: DE767565
Name: Maxitronic Limited
Address: Bingauer Strasse 45
City: Koln, Germany”

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Then split it again by text.split(" ")(0)

[arivu96 (Arivazhagan A)]

Use below code to extract the value

Convert.ToString(String1.Split(Environment.Newline)(0)).Split(":"c)(1)

Regards,
Arivu

[Tuannna1 (Tuan Anh)]

@arivu96

System.Text.RegularExpressions.Regex.Match(String1,@“(?<=TaxID:.*<=Name)”).Value.ToString().Trim()

regex is wrong!

[RajKumar_DC (RajKumar Durai)]

Hi @Tuannna1,

What about this

Input

Output

1. get text
2. Split the get text value like below

st.Split(Environment.NewLine.ToArray)(1).Trim.Split("TaxID: ")(1)

Thanks,

[Tuannna1 (Tuan Anh)]

Thank you, I have tried it successfully.