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/ ?