I need to get text from a string

[ajnaraya (Ajay Narayanan)]

“ACN - Test Number & Test Channel Statements 15.09.23”… I want to get Test Number , Test Channel from this string. Can someone help to do this ?

[Jithesh_R]

@ajnaraya ,
Can you please elaborate? Like
Input : _______
Output :________

Regards,

[lrtetala (Lakshman Reddy)]

Hi @ajnaraya

Try this

(?<=\-\s+).*(?=\s+\&\s+)|(?<=\&\s+).*(?=\s+Statements)

[ajnaraya (Ajay Narayanan)]

@ajnaraya

“ACN - Test Number & Test Channel Statements 15.09.23”

“ACN - Test Number & Test Channel Statements 15.09.23” Input
Test Number , Test Channel is the output i want

[Usha_Jyothi]

Hope this helps
Usha

[lrtetala (Lakshman Reddy)]

@ajnaraya

[Jithesh_R]

@ajnaraya ,
If the Sentences are similar for all the cases you can make use of below methods

TestNumberOutput = Split(Split(“InputVar”,"ACN-")(1),"&")(0).trim

TestChannelOutput = Split(Split("InputVar","&")(1)," Statements")(0).trim

Regards,

[Sudharsan_Ka]

Have you tried this ? @ajnaraya

Seems like it is working fine for me

Split string using UiPath

Hi @ajnaraya If the - and date will be constantly be there you can use like this System.Text.RegularExpresssions.Regex.Match(InputString,"(?s)(?<=\-)(.*?)(?=\d{2})").ToString.Trim [image] This will give you like Test1 & Test2 If you want them in a single string variable you replace the & System.Text.RegularExpresssions.Regex.Match(InputString,"(?s)(?<=\-)(.*?)(?=\d{2})").ToString.Trim.Replace("&","") If you want liek a array you split using & System.Text.RegularExpresssions.Regex.Match…

Regards
Sudharsan

[mkankatala (Mahesh Kankatala)]

Hi @ajnaraya

You can use the below regular expressions to extract the required output from the Input data.

- Assign -> Input = "ACN - Test Number & Test Channel Statements 15.09.23"
- Assign -> Output = System.Text.RegularExpressions.Regex.Matches(Input.ToString,"((?<=&\s+|\-\s+)[A-Za-z]+\s+[A-Za-z]+)")

Check the below image for better understanding.

Hope it helps!!

[sasi_poosarla (sasi p)]

@ajnaraya

TestNumber=System.Text.RegularExpressions.Regex.Matches(str,“(?<=ACN\s.\s)\b\w+\s\w+|\w+\s\b.*(?=\sStatements)”)(0)

TestChannel=System.Text.RegularExpressions.Regex.Matches(str,“(?<=ACN\s.\s)\b\w+\s\w+|\w+\s\b.*(?=\sStatements)”)(1)