PHP - > Upload process and create a new csv file

Question

PHP - > Upload process and create a new csv file

Brianfree (Programmer)

(OP)

6 Jun 19 06:58

Hello, i have an csv document with 2 columns that have the following example data:-

REF OEM
987392405 DSB52402402404240 / LR2401240574 / SOB52402402404240 / SOB524024024042
987246240 1240240196240 / 1H240615423A / 1H240615423B / 1H240615423D / 1H240615423DX / 6K240615423B / 1G240615423 / 7M240615423
etc...

In a php page, i want to select a csv file, process it and then create a new csv file which has been processed to look like the following?

REF OEM
987392405 DSB52402402404240
987392405 LR2401240574
987392405 SOB52402402404240
987392405 SOB524024024042

Please can anyone show me how to do it?

many thanks

BF

feherke (Programmer) · Answer 1 · 2019-06-06 08:47:31

Hi

Personally I would do it like this :

CODE --> command line

master # php -R 'if($argi==1)echo"$argn\n";else{$p=explode("\t",$argn,2);foreach(explode(" / ",$p[1])as$o)echo"$p[0]\t$o\n";}' < Brianfree.csv
REF             OEM
987392405       DSB52402402404240
987392405       LR2401240574
987392405       SOB52402402404240
987392405       SOB524024024042
987246240       1240240196240
987246240       1H240615423A
987246240       1H240615423B
987246240       1H240615423D
987246240       1H240615423DX
987246240       6K240615423B
987246240       1G240615423
987246240       7M240615423

Assuming that the column separator is always a tab and the OEM's internal separator is always space+slash+space. Some error checking may help though.

If need help adapting it to your context, let us know. ( And please post preformatted text between [pre] and [/pre] TGL tags. )

Feherke.
feherke.github.io

Come Join Us!

Posting Guidelines

PHP - > Upload process and create a new csv file