Batch script to seach a CSV file for specific text, if found, read all words on that line into seperate variables.
Posted on 2013-05-20
Thanks in advance for this one....
I'm working on a batch file that does several different things, but have run into a bump in the road I can't seem to get passed. I need to add the ability to open a csv file for a code which the user will be prompted to enter, and if the code is found in the csv file, I need each comma delimited field on that same line read into separate variables so that the batch file can use that information for other functions.
The CSV file contains information on building locations and looks like the following: Building_Name,Street_Address,City,Number,Building Code,
The user will be prompted to enter the building code which is the 5th field in the CSV file, then if that is found, I need to have all fields on the same line read into separate variables to be used later.
Wish we could award as many points as we wanted, 500 doesn't seem like enough some time.
Thanks so much,