Split Region And pdf Code

i have pdf File name is :: BAZ_CENTRAL LUZON_H267_BAL_01152021_1.pdf

i want Split
Region ==CENTRAL LUZON
Pdf Code= H267

how to do that ?

Hi Anand,

If your file name is fixed, means it will not change, then you can use String.Substring method, to extract the text.

Hi @Anand_Designer you can try this string manipulation

input = " BAZ_CENTRAL LUZON_H267_BAL_01152021_1.pdf"

Region = Split(input,“_”)(1)

pdfCode=Split(input,“_”)(2)

Try this way

Mark it as solution if it resolves your query

Regards
Nived N

Happy Automation

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.