Đang Thực Hiện

126651 Data Extract / Excel

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

Kĩ năng: Bất kì công việc gì, Microsoft Access, PHP, Visual Basic

Xem nhiều hơn: www excel, three p, find poets, jpg to excel, data visual, data p, extract excel files, excel cell, php extract script, line mall, extract data excel files, excel mind, script extract data excel, excel extract, rule visual basic, software excel, excel data jpg, script mall, excel line, excel book, visual basic jpg extract, extract products, poets, american php, script excel files

Về Bên Thuê:
( 3 nhận xét )

ID dự án: #1872818