I am working on a ver large CSV File.
This file is used to upload to my website to instruct the site where to find the images for a product.
Here is a small sample of the CSV file and there will be more details below the sample:
imageProduct imageSrc imageType imageNumber
KL1001 prodimages/XXXXX_small.jpg 0 0
KL1001 prodimages/XXXXX_medium.jpg 1 0
KL1001 prodimages/XXXXX.jpg 2 0
KL1002 prodimages/XXXXX_small.jpg 0 0
KL1002 prodimages/XXXXX_medium.jpg 1 0
KL1002 prodimages/XXXXX.jpg 2 0
There are over 22,000 entries on this CSV file. In Column A this is the product number, my images also use product number as the name of the image.
Column B states the directory is prodimages/ and where XXXXX is is where I need to insert the product number from column a i.e. in the first line I need column b to look like this prodimages/KL1001_small.jpg and then the next like to look like this prodimages/KL1001_medium.jpg and then the third row to look like this prodimages/KL1001.jpg
The reason a single product (KL1001) has three lines in the CSV file is to tell the website (KL1001_small.jpg) is the image that is sized at 150x150 pixels and (KL1001_medium.jpg) is size 350x350 Pixels and finally (KL1001.jpg) is the 800x800 pixel size.
So basically I am seeking help to see if some one can explain to me How I could get excel to populate this data for me.
Thanks
Alan
Bookmarks