[solved] Comma separated values to space separated


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers [solved] Comma separated values to space separated
# 1  
Old 04-16-2013
[solved] Comma separated values to space separated

Hi,

I have a large number of files which are written as csv (comma-separated values).

Does anyone know of simple sed/awk command do achieve this?

Thanks!

---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------

Guess I asked this too soon. Found the solution

Code:
awk -F "\"*,\"*" '{print $1, $2}'  file.csv

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert fixed value fields to comma separated values

Hi All, Hope you are doing Great!!!. Today i have came up with a problem to say exactly it was for performance improvement. I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting a sed... (9 Replies)
Discussion started by: mad man
9 Replies

2. Shell Programming and Scripting

Parsing Comma Separated values to UNIX variable from PLSQL

Hi All, I'm trying to pass the comma separated values (string) returned from Plsql Procedure to UNIX variable. getting the below log message cat: -: Bad file descriptor awk: cmd. line:1: fatal: error reading input file `-': Bad file descriptor The output coming from plsql procedure is... (3 Replies)
Discussion started by: Mahesh3089
3 Replies

3. Shell Programming and Scripting

Assign comma separated values to a variable

Hi All, I wrote a database command that queries our application and outputs a whole bunch of values to a text file. I need to assign the output to two values. Here is a sample of the output: valueOne, checkOne valueTwo, checkTwo valueThree, checkThree I would like... (9 Replies)
Discussion started by: jeffs42885
9 Replies

4. Shell Programming and Scripting

Comma separated values to individual lines

My OS : RHEL 6.7 I have a text file with comma separated values like below $ cat testString.txt 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . . I want these values to appear like below 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', .... (4 Replies)
Discussion started by: kraljic
4 Replies

5. Shell Programming and Scripting

Needs help in parsing comma separated values

hello experts, i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces: jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'` jobNames=`echo $jobNames | sed... (1 Reply)
Discussion started by: avikaljain
1 Replies

6. Shell Programming and Scripting

To agregate Comma separated values

Hi pls help me to get the code: i have a file in which content is : 2.01304E+11 2.01304E+11 ori 2 01:00 2.01304E+11 2.01304E+11 ori 2 01:02 2.01304E+11 2.01304E+11 ori 3 01:02 2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Discussion started by: Aditya.Gurgaon
7 Replies

7. Shell Programming and Scripting

Input Validation of comma separated values

Hello all, I am working on a script and have the first part solved of numerical input validation. Below the code validates that the input is a numerical value between 100 and 1000. If not, it errors out. Now I need to be able to read values separated by a comma. For example, instead of my... (5 Replies)
Discussion started by: LinuxRacr
5 Replies

8. Shell Programming and Scripting

script to store comma separated values in different variables

Hello friends, I need ur help.I want to write a script. The script should read contents from a file namely xyz. e.g xyz abcd,1234,efgh,7854378 dhnsa,dsakjkdl,43432,ZXDsa the script should store comma (,) seperated values in different variables. Once pointer will reach end of line (\n), it should... (1 Reply)
Discussion started by: akhtar.bhat
1 Replies

9. Shell Programming and Scripting

Extracting the values separated by comma

Hi, I have a variable which has a list of string separated by comma. for ex , Variable=/usr/bin,/usr/smrshbin,/tmp How can i get the values between the commas separately using shell scripts.Please help me. Thanks, Padmini. (6 Replies)
Discussion started by: padmisri
6 Replies

10. Shell Programming and Scripting

Splitting comma separated values into an array

I'm attempting to create a KSH array out of a string like this: ",,,value1,value2,," I have created the array but I only get two elements, one for value1 and one for value2. I have ended up with something like this but I don't like it: set -A JUNK xx=0 for i in $(print ",,,value1,value2,,"... (3 Replies)
Discussion started by: tmarikle
3 Replies
Login or Register to Ask a Question
ABOOK(1)						      General Commands Manual							  ABOOK(1)

NAME
abook - text-based address book program SYNOPSIS
abook [ OPTION ] DESCRIPTION
This manual page documents briefly the abook program. This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page. abook is a text-based address book program. It contains Name, Email, Address and various Phone fields. It is designed for use with mutt, but can be equally useful on its own. OPTIONS
-h --help Show usage. -C --config <filename> Use an alternative configuration file (default is $HOME/.abook/abookrc). --datafile <filename> Use an alternative addressbook file (default is $HOME/.abook/addressbook). --mutt-query <string> Make a query for mutt (search the addressbook for <string>). The --datafile option, as documented above, may be used BEFORE this option to search a different addressbook file. --convert [ --informat <inputformat> ] [ --infile <inputfile> ] [ --outformat <outputformat> ] [ --outfile <outputfile> ] Converts <inputfile> in <inputformat> to <outputfile> in <outputformat> (defaults are abook, stdin, text and stdout). The following inputformats are supported: - abook abook native format - ldif ldif / Netscape addressbook - mutt mutt alias - pine pine addressbook - csv comma separated values - palmcsv Palm comma separated values The following outputformats are supported: - abook abook native format - ldif ldif / Netscape addressbook (.4ld) - mutt mutt alias - html html document - pine pine addressbook - gcrd GnomeCard (VCard) addressbook - csv comma separated values - palmcsv Palm comma separated values - elm elm alias - text plain text - spruce Spruce address book - wl Wanderlust address book - bsdcal BSD calendar --add-email Read an e-mail message from stdin and add the sender to the addressbook. --add-email-quiet Same as --add-email but doesn't confirm adding. --formats List available formats. COMMANDS DURING USE
Press '?' during use to get a list of commands. SEE ALSO
mutt(1), abookrc(5) AUTHOR
This manual page was written by Alan Ford <alan@whirlnet.co.uk>, for the Debian GNU/Linux system (but may be used by others). abook was written by Jaakko Heinonen <jheinonen@users.sourceforge.net> 2006-09-06 ABOOK(1)