Please help me on this

Raj_Sekhar · September 30, 2021, 9:12am

Can someone let me know how to extract string between ‘_’ and ‘. xlss’ from the below example.

Invoice_00ABCD.xlss

I need 00ABCD only, no matter how many characters are there in middle of ‘_’ and ‘.xlss’

Please suggest.

vishal.kp · September 30, 2021, 9:19am

Can you try assign activity with System.text.regularexpressions.regex.match(“your string”,"_(.*).xlss$").groups(1).tostring

Palaniyappan · September 30, 2021, 9:20am

Hi

Welcome back to UiPath forum
If your input is in a string variable named Strinput
Then use a assign activity and mention the below expression

Stroutput = Split(Split(Strinput.ToString,”.”)(0),”_”)(1).ToString.Trim

Hope this would help you resolve this

lakshman · September 30, 2021, 9:20am

Let’s say inputString =“Invoice_00ABCD.xlss”

            outputString = inputString.Split("_"c)(1).Split("."c)(0).Trim

prasath_S · September 30, 2021, 9:27am

This will be another approach,

strText - your input string

strText.Substring(strText.indexof("_")+1,(strText.Indexof(".xlss")-strText.indexof("_"))-1)

Thanks

Raj_Sekhar · September 30, 2021, 9:44am

Thank you it worked

Raj_Sekhar · September 30, 2021, 9:44am

lakshman · September 30, 2021, 9:48am

Glad I could help. Happy Automation