Extract values from String

[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