Geek Answers Handbook

PHP - explode values ​​in an array, print to tab delimited file

I have the following file in test_tab.txt file (tab split):

 header1 header2 header3 field1 field1a field1b; field1c field2 field2a field2b field3 field3a field4 field4a field4b; field4c; field4d; field4e field5 field5a field6 field6a field6b; field6c

I would like to convert this to the following (also tab-delimited, written in another text file):

 header1 header2 header3 field1 field1a field1b field1 field1a field1c field2 field2a field2b field3 field3a field4 field4a field4b field4 field4a field4c field4 field4a field4d field4 field4a field4e field5 field5a field6 field6a field6c field6 field6a field6c

I am new to programming in general, but I was looking for googled, and I think that a possible way to do this would be to create an array and somehow explode a couple of key header3 values. I'm not sure how to go about copying the fields under heading1 and header2 though.

All I have is some code to create an array:

 $mainarray = array(); foreach (file('test_tab.txt') as $row) { list($header1, $header2, $header3) = explode("\t", $row); $mainarray[] = array(header1 => $header1, header2 => $header2, header3 => $header3); } print_r($mainarray);

which gives:

  Array ( [0] => Array ( [header1] => header1 [header2] => header2 [header3] => header3 ) [1] => Array ( [header1] => field1 [header2] => field1a [header3] => field1b; field1c ) [2] => Array ( [header1] => field2 [header2] => field2a [header3] => field2b ) [3] => Array ( [header1] => field3 [header2] => field3a [header3] => ) [4] => Array ( [header1] => field4 [header2] => field4a [header3] => field4b; field4c; field4d; field4e ) [5] => Array ( [header1] => field5 [header2] => field5a [header3] => ) [6] => Array ( [header1] => field6 [header2] => field6a [header3] => field6b; field6c ) )

Any ideas on how to approach this? I am using PHP version 5.3.10.

+7
arrays split php key-value tab-delimited
source share
2 answers

Try the following:

 // read input file $fp = fopen( 'test_tab.txt', 'r' ); // write to an output file $fp1 = fopen( 'output.txt', 'w' ); while( ( $data = fgetcsv( $fp, '', "\t" ) ) !== FALSE ) { $list = explode( ';', $data[ 2 ] ); foreach( $list as $column ) { fwrite( $fp1, '"' . $data[ 0 ] . "\"\t\"" . $data[ 1 ] . "\"\t\"" . trim( $column ) . "\"\n" ); } } fclose( $fp1 ); fclose( $fp );

Hope this helps.

+8
source share

Your text should be separated by a tab, and then try this one,

 <?php $mainarray = array(); foreach (file('test_tab.txt') as $row) { $ar = explode("\t", $row); $mainarray[] = array('header1' => $ar[0], 'header2' => $ar[1], 'header3' => $ar[2]); } var_dump($mainarray);?>
+3
source share

More articles:


All Articles