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