Export a text file to CSV format.

Hello Gurus,
I have a text file with the following format. I need a script or something like that which converts the text file in to a CSV format.
"A" status"unavailable"
"B" status"available"
"C" status"unavailable"
"D" status"unavailable"
"E" status"available"
"F" status"available"
Thanks in advance for your help guys.





__________________
The man who removes a mountain begins by carrying away small stones.

Have your tried importing the file with something like Excel and then exporting or saving it from there as a CSV file? If it doesn't have a "," in the text file, the maybe a find and replace the "spaces" with a "comma space" might do it too.





__________________- Donovan K Dedicated Servers | VPS | Shared Hosting | Colocation | Reseller Plans | Monthly SpecialsOnly New Hardware | Only 24/7 Support | Only at JADASE.com

I am not sure on what you are telling. This is the output of a script. I need to export this output in to CSV format. Any help is great.





__________________
The man who removes a mountain begins by carrying away small stones.

Guys, please help me.. Looking for your help more..





__________________
The man who removes a mountain begins by carrying away small stones.

If it's the output of a script, then you'll need to make the change within the script. Not sure anyone can help with that without seeing the script.





__________________www.NEXCESS.NET - Shared/Reseller Hostingwww.eliteRAX.com - Dedicated Servers, Server Clusters

I'm at work so this is untested
PHP Code:



<?php
function custom_csv($file, $csv_line_end = '\n')
{
ÂÂ*ÂÂ*ÂÂ*$handle = fopen($file, "r");
ÂÂ*ÂÂ*ÂÂ*ÂÂ*$contents = fread($handle, filesize($file));
ÂÂ*ÂÂ*ÂÂ*ÂÂ*$eaches = explode('\n', $contents);
ÂÂ*ÂÂ*ÂÂ*ÂÂ*$csv_arr = array();
ÂÂ*ÂÂ*ÂÂ*ÂÂ*
ÂÂ*ÂÂ*ÂÂ*ÂÂ*$replace = array(' status', '"', 'unavailable', 'available');
ÂÂ*ÂÂ*ÂÂ*ÂÂ*foreach ($eaches as $each)
ÂÂ*ÂÂ*ÂÂ*ÂÂ*{
ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*$csv_arr[]['status'] = (strpos($each, 'unavailable')) ? 'unavailable' : 'available';
ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*str_replace($replace, '', $each);
ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*$csv_arr[]['name'] = trim($each);
ÂÂ*ÂÂ*ÂÂ*ÂÂ*}
ÂÂ*ÂÂ*ÂÂ*ÂÂ*$csv_str = '';
ÂÂ*ÂÂ*ÂÂ*ÂÂ*foreach ($csv_arr as $csv)
ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*$csv_str .= $csv['name'] . ',' .$csv['status'] . $csv_line_end;
ÂÂ*ÂÂ*ÂÂ*ÂÂ*return $csv_str;
}
echo custom_csv('text_file.txt', ';'); // A,available;B,unavailable;etc
?>











Last edited by etogre : 11-03-2008 at 06:42 PM.

Text Editor Solution

If the output is in a file, just about any text editor would allow you to change the space to a comma.

This should also work:
PHP Code:



$data = file($in_file);$fp = fopen($csv_file, 'w');foreach ($data as $line) {ÂÂ*ÂÂ*ÂÂ*$arr = explode('"', trim($line, "\"\r\n"));ÂÂ*ÂÂ*ÂÂ*ÂÂ*fputcsv($fp, array($arr[0], $arr[2]));}fclose($fp);











Last edited by bigfan : 11-04-2008 at 06:40 AM.

From the linux command line:
Code:
burhan@burhan-laptop:~$ cat t.txt
"A" status"unavailable"
"B" status"available"
"C" status"unavailable"
burhan@burhan-laptop:~$ replace 'status"' 'status","' -- t.txt
t.txt converted
burhan@burhan-laptop:~$ cat t.txt
"A" status","unavailable"
"B" status","available"
"C" status","unavailable"
burhan@burhan-laptop:~$
OR
Code:
burhan@burhan-laptop:~$ cat t.txt | sed "s/status\"/status\",\"/"
"A" status","unavailable"
"B" status","available"
"C" status","unavailable"







__________________
In order to understand recursion, one must first understand recursion.
If you feel like it, you can read my blog
Signal > Noise

I dont know CSV format (only used in Windows?), but sounds like the OP wants something like this:
Code:
awk -F \" '{print $2", "$4}' < file.txt

A, unavailable
B, available
C, unavailable
D, unavailable
E, available
F, available







__________________
...and the God created man...

Quote:


only used in Windows?


From wikipedia:
Quote:


Comma-separated value lists are very old technology and predate personal computers by more than a decade; the IBM Fortran (level G) compiler under OS/360 supported these in 1967, and they were not a new idea at the time.
...
The CSV file format is very simple and supported by almost all spreadsheets and database management systems. Many programming languages have libraries available that support CSV files. Even modern software applications support CSV imports and/or exports because the format is so widely recognized.