File Name Parsing w/ '_' delimiter

Help
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.

1 Like
4

Thanks so much vvaidya!

As always, you are an enormous help.

1 Like
5

Thanks. How far did you get along with Webscraping About – South Florida Banking Institute ?