I have a 10 column .txt spreadsheet that list items for sale. The first column contains the dealers item number.
I need a script of some kind that will permit me to add a 2-3 letter code to the beginning of all data in the first column and in front of the data it contains.
item number before: xxxxxxx
item number after: xxx-xxxxxxx
Also... if possible, I would like to have a script that will take the data from 3 or 4 of these same spreadsheets (one for each vendor)that are identical in layout, and combine the data in them into one data file.
sample header layout:
item number|description|weight|3|avail|long description|brand name|category|msrp|dealer