I need a script that would separate the data on each line and put them into individual cells on Excel.
EXAMPLE: The data on each line is altogether as shown below.
Herman Melville - Three American Poets|"[url removed, login to view](946501)p(20949)prod(12778188)"|"[url removed, login to view]"|"Herman Melville - Three American Poets"|"10.49"|"GBP"|"12778188"|"Books"|"BOOK"|""
The data that needs to be put into individuals cells are all separated via "|"
This needs to be removed and put into individual cells on Excel.
Please do look at file ï¿½[url removed, login to view]ï¿½ as all data should be extracted and exported into this rule.
There will be 1000's of data lines on other data files that will be used so the script should be fast and able to handle the scope. Also the data file supplied has a 9 cell data but there will be other files that have less and more.
I don't mind what software is used, as long as I can use it on my PC windows XP, also please no timewasters.
Please do find files attached