no the issue is how i constructed the break down
i only thought there was 3 "-" in the file name but based on what you have told me there is actually 5 "-"
also is [] around the date for all files as well?
having it Jul or as a plain number doesnt make a difference
thats ok ill have a look at it tomorrow
just block that section out (by putting a ' infront of it) for the time being and if everything else works fine then there is only one line to fix tomorrow
since im checking to make sure im not making another assumption
is there any chance that there will be "-" in the name or invoice field?
ie Mary-Jane brown or INV-09328 or something like that
i would need to find some other way of splitting the Name-Inv-Date if there is
Bookmarks