Sponsored Content
Full Discussion: Convert txt to csv
Top Forums Shell Programming and Scripting Convert txt to csv Post 302505001 by JPBovaird on Wednesday 16th of March 2011 12:37:12 AM
Old 03-16-2011
Convert txt to csv

Hi - I am looking to convert the following text to csv. The columns may not always have data in them and they may have varying spaces but I still need to have a comma there anyway:

Sample Data:
~~~~~~~
Code:
Name                  Email                                    Location         Phone
Tom Smith          toms@me.com                     home              +65 5555 5555
John,,,
Jerry T. Wright   jerry@me.com                      NY office       +1 212 555 5555
Phil Dell             phil@me.com                                              +1 212 555 1111

Need it to look like:
~~~~~~~
Code:
Name,Email,Location,Phone
Tom Smith,toms@me.com,home,+65 5555 5555
John,,,
Jerry T. Wright,jerry@me.com,NY office,+1 212 555 5555
Phil Dell,phil@me.com,,+1 212 555 1111

Appreciate any help!
JP

Last edited by Franklin52; 03-16-2011 at 06:23 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert PS files to txt file?

Hi, I need to convert PS files to txt file. I thought of using ps2ascii, but its not installed in my AIX box, any other option? (2 Replies)
Discussion started by: redlotus72
2 Replies

2. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

3. Shell Programming and Scripting

how to convert XLS to CSV and DOC/RTF to TXT

Hi, i don't know anything about PERL. Can anyone help me providing PERL scripts for 1. converting XLS to CSV (and vice-versa) 2. converting DOC/RTF to TXT Thanks much Prvn (1 Reply)
Discussion started by: prvnrk
1 Replies

4. Shell Programming and Scripting

Txt to csv convert

Hi, I was trying some split command to pull out values like "uid=abc,ou=INTERNAL,ou=PEOPLE" into a csv file. However because of erratic nature of occurrance of rows made me stopped. Could someone help me in this? and if someone has a one liner for this? The text file contain pattern like this... (14 Replies)
Discussion started by: john_prince
14 Replies

5. UNIX for Dummies Questions & Answers

Help with a project. convert a txt to csv

Hi people. I've finally converted to linux, and I'm starting to explore the amazing capabilities of the terminal. At the moment in trying to learn how to extract text using the "grep" and "sed" command. I decided to learn by trying to figure out how to solve a practical problem. I have a schedule... (4 Replies)
Discussion started by: kugalskaper
4 Replies

6. UNIX for Dummies Questions & Answers

XML to TXT or CSV

Hi all, I am new to unix and even newer to XML :wall: I have a dataset which I need to work on and extract data from but I cant even see things. its a XML file which i need to analyse and return the results in xml as well but need to filter some of them like i would do with excel file so not... (7 Replies)
Discussion started by: A-V
7 Replies

7. Shell Programming and Scripting

Need script to convert TXT file into CSV

Hi Team, i have some script which give output in TXT format , need script to convert TXT file into CSV. Output.TXT 413. U-UU-LVDT-NOD-6002 macro_outcome_dist-8.0.0(v1_0_2) KK:1.2.494 (1234:333:aaa:2333:3:2:333:a) 414. U-UU-LVDT-NOD-6004 ... (10 Replies)
Discussion started by: Ganesh Mankar
10 Replies

8. Red Hat

How to convert TXT to PDF in RHEL 6?

Hello friends, I need to convert ASCII text to PDF on RHEL 6 so I did the below and could generate PDF but it has lot of junk/special characters. yum install enscript ghostscript enscript -p output.ps input.txt ps2pdf output.ps output.pdf So I download latest source of Ghostscript... (4 Replies)
Discussion started by: magnus29
4 Replies

9. Solaris

How to convert pdf file to txt?

Hello Unix gurus, I am learning unix. I have lots pdf data files. I need to convert them into txt files. Can you please guide me how to do that? Thanks in advance. Rao (1 Reply)
Discussion started by: raopatwari
1 Replies

10. UNIX for Beginners Questions & Answers

Convert a txt file to a CSV file

Hi , I have a Txt file which consist of 1000's of SOAP request and response and i want the file to be converted to a csv file like column a should have a soap request and column b should have the soap response . can someone assist me in achieving this please ? Thanks (2 Replies)
Discussion started by: kumarm8
2 Replies
Test::POP3(3pm) 					User Contributed Perl Documentation					   Test::POP3(3pm)

NAME
Test::POP3 - Automate Email Delivery Tests SYNOPSIS
use Test::POP3; my $pop = Test::POP3->new({ host => $host, user => $user, pass => $pass, }); # this will delete all messages from the server ok($count == $pop->wait_for_email_count($count,$timeout),"got $count"); # find and delete a single email message which matches these rules # see Test::Email for more information $pop->ok({ # optional search parameters to => ($is or qr/is like/), from => ($is or qr/is like/), subject => ($is or qr/is like/), body => ($is or qr/is like/), headername => ($is or qr/is like/), }, "got message"); ok($pop->get_email_count() == $count, "$count emails in cache"); # get the Test::Email object my @email = $pop->get_email(); ok($pop->delete_all() == 2, "deleted 2 messages"); # tweak MIME::Parser settings my $parser = $pop->get_parser(); DESCRIPTION
Please note that this is ALPHA CODE. As such, the interface is likely to change. This module can help you to create automated tests of email delivered to a POP3 account. Messages retrieved from the server but not yet matched by a test will be cached until either that message is the first to pass a test, or is returned by "$pop3->get_email()". Messages returned are Test::Email objects. METHODS
"my $pop = Test::POP3->new($href);" The arguments passed in the href are host, user, and pass. "my $count = $pop->wait_for_email_count($count, $timeout_seconds?);" Calling this method will result in all messages being deleted from the server. This will wait up to $timeout seconds for there to be $count unprocessed messages found on the server. After $count or more messages are found, or after $timeout seconds, the current email count will be returned. $timeout_seconds defaults to 30. "my @email = $pop->get_email();" Get all of the email messages currently in local cache. You should call "$pop3->wait_for_email_count($count)" before calling this method if you think that there may be messages on the server yet to be retrieved. Calling this method will cause the local cache to be emptied. Email messages returned will be Test::Email objects. "my $count = $pop->get_email_count($check_server);" This will return the number of email messages in the cache. If $check_server is true, then the server will be checked once before the count is determined. If you would like to wait for messages to arrive on the server, and then be downloaded prior to counting, use "$pop3->wait_for_email_count()". "my $ok = $pop->ok($test_href, $description);" Calling this method will cause the email in the local cache to be tested, according to the contents of $test_href. The first email which passes all tests will be deleted from the local cache. Since this method only checks the local cache, you will want to call "$pop3->wait_for_email_count()" before calling this method. "ok" will produce TAP output, identical to "Test::Simple::ok" and "Test::More::ok". "my $parser = $pop->get_parser();" Test::POP3 uses MIME::Parser to process the messages. (MIME is not yet handled by "Test::Email", it will be soon.) Use this method if you want to manage the parser. EXPORT
None. SEE ALSO
Test::Builder, Test::Simple, Test::More, MIME::Parser AUTHOR
James Tolley, <james@cpan.org> COPYRIGHT AND LICENSE
Copyright (C) 2007 by James Tolley This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available. perl v5.10.0 2008-10-24 Test::POP3(3pm)
All times are GMT -4. The time now is 07:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy