File Name Parsing w/ '_' delimiter


#1

Hello,

I have a file that I need to parse out and allocate to variables.

Format goes like this:

[Vendor#][PO#][Date (in ####### format)].csv

How would you parse this out?


#2

Apologies it has a “_” delimiter between each field


#3

Please use Split(Filename.tostring,"_")

The output is a string array, so Vendor#= strFileNameArray[0] , PO# =strFileNameArray[1] and so on…

You can split the date using substring.


#4

Thanks so much vvaidya!

As always, you are an enormous help.


#5

Thanks. How far did you get along with Webscraping https://soflbi.com/about/ ?