String manipulation to extract data

[Paul_Mark]

Hello

Need to extract the Ref ID No from below sample input. it will change dynamically

Invoice No: INV-12345
Ref ID = 67890
Transaction: TXN_45678

[Gokul001 (Gokul Balaji)]

Hi Paul,

You can try with Regular expression in UiPath

https://regex101.com/

Regards,
Gokul

[Gokul001 (Gokul Balaji)]

Hi paul,

Kindly check oput the below expression

Use this expression in the Assign activity

system.text.RegularExpression.regex.match(Inputstring,"(?<=Ref\sID\s\D\s)\d+").Tostring.Trim

Regards,
Gokul

[Parvathy (PS Parvathy)]

Hi @Paul_Mark

Please find the below regular expression:

strInput = "Invoice No: INV-12345
            Ref ID = 67890
            Transaction: TXN_45678"

strOutput = System.Text.RegularExpressions.Regex.Match(strInput, "(?<=Ref ID\s*\=\s*).*").Value.Trim()

Hope it helps!!

Regards
PS Parvathy

[prashant1603765 (Prashant Kumar)]

Hi @Paul_Mark

Welcome to UiPath,

Try this-

refId = System.Text.RegularExpressions.Regex.Match(inputText, “(?i)ref\sid\s[:=]?\s*(\d+)”).Groups(1).Value

If helpful, mark as solution. Happy automation with UiPath

[vhvinodsai (Vinod harapanahalli)]

Hi @Paul_Mark

Welcome to UiPath community!

You can try to use linq functionality, use assign activity inside put
inputText.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(x) x.Contains(“Ref ID”)).Select(Function(x) x.Split("="c)(1).Trim).First

Use if condition and you will get your required output. If you face any difficulties feel free to ping here .

Happy automation!