|i tested against my data and works fine. yeah i know, working on my data doesnt guarantee to work on your data. if you could, please post the complete first 10 line of your data. including header.|
in your first post:
on second post:
the format pattern doesnt match in the first post
what i miss out in the code is price can go below $1, and price can have 1 decimal point and 2 decimal point.
and i also miss one point in your first post that requires "another criteria(s)"
if the criteria(s) is dynamic depending on situation, then IMO batch is not going to work well. what other programming language are you good at? and what solution do you have so far?
please refer to post#3 for temporary fix solution. it only works with 2 criteria that is hardcoded. use wordpad to copy & paste.
what i am working at the moment, is using batchfile to download the data, then concatenate all the CSV file into one big file (around 3-5 years data) then use MS. ACCESS to link into the BIG CSV file. and later use SQL query to manipulate data.