Extract values from String

[kalpitmantri]

I have this string C:\Users\kalpit.mantri\Documents\UiPath\ExcelCopyPaste\BRTYLP_Dec19.xlsx
I want to extract BRTYLP in str1 variable and Dec19 in str2 variable.
Is this possible?

[ImPratham45 (Prathamesh Patil)]

Use
Assign
str1=Path.GetFilenamewithoutextension(“C:\Users\kalpit.mantri\Documents\UiPath\ExcelCopyPaste\BRTYLP_Dec19.xlsx”).split("“c)(0)
str2=Name=Path.GetFilenamewithoutextension(“C:\Users\kalpit.mantri\Documents\UiPath\ExcelCopyPaste\BRTYLP_Dec19.xlsx”).split(”"c)(1)

[pattyricarte (Patty Boy)]

Use Split “C:\Users\kalpit.mantri\Documents\UiPath\ExcelCopyPaste\BRTYLP_Dec19.xlsx”
split by "" then if you get the last index ,Split it again “BRTYLP_Dec19.xlsx” by “_”
so you will get the 0 and 1 index then do your desire thing in this output. @kalpitmantri

Also you can check this out for your reference.

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

cheers

Happy learning

[anoopap]

Hi @kalpitmantri

Please try this

string Path = "C:\Users\kalpit.mantri\Documents\UiPath\ExcelCopyPaste\BRTYLP_Dec19.xlsx" 
string str1 = Path.Split("_"c)(0).Split("\"c)(Path.Split("_"c)(0).Split("\"c).Count-1)
string str2 = Path.Split("_"c)(1).Split("."c)(0)

hope this will help

[kalpitmantri]

Hello @anoopap Thank its working.