How to change a line of text to a comma delimited string?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to change a line of text to a comma delimited string?
# 1  
Old 07-09-2014
How to change a line of text to a comma delimited string?

Hi,

Is there a one-liner that I can use to change a line of text into a comma delimited string?

For example, convert

Code:
user1
user2
user3
user4

to

Code:
user1,user2,user3,user4

Currently using while read x, although got the extra comma at the end that I have to remove manually.

Please advise. Thanks
# 2  
Old 07-10-2014
this is four lines not one line:
Code:
user1
user2
user3
user4

If it is in a file try awk :
Code:
awk '{for( i = 1; i < NF ;  i++ ) { printf("%s," $(i) ) }; print $(i) }' myfile > newfile

This User Gave Thanks to jim mcnamara For This Post:
# 3  
Old 07-10-2014
Code:
 
awk 'NR == 1 {printf "%s", $0; next} {printf ",%s", $0} END {print ""}' file

# 4  
Old 07-10-2014
Try:
Code:
paste -sd, file

This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 07-18-2014
Quote:
Originally Posted by jim mcnamara
this is four lines not one line:
Code:
user1
user2
user3
user4

If it is in a file try awk :
Code:
awk '{for( i = 1; i < NF ;  i++ ) { printf("%s," $(i) ) }; print $(i) }' myfile > newfile


- Ooops, sorry yes lines of text into a comma delimited string

- BTW, how do I make it like every nth line, so for example, if I have a line of text like below:

Code:
line01
line02
line03
line04
line05
line06
line07
line08
line09
line10

I want it to be

Code:
line01, line02
line03, line04
line05, line06
line07, line08
line09, line10

# 6  
Old 07-18-2014
Try:
Code:
paste -sd ',\n' file

Code:
paste -d, - - < file

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Need help on an old post - How to convert a comma delimited string to records or lines of text?

Hi, Apologies in advance to the moderator if I am posting this the wrong way. I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question. The question I have is in relation to the following post: How to... (6 Replies)
Discussion started by: newbie_01
6 Replies

2. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies

3. Shell Programming and Scripting

How to add the line to previous line in | delimited text?

Hi All, I am new to Unix and I have one challenge and below are the details. I have pipe delimited text file in that data has span into multiple lines instead of single line. Sample data. Data should be like below for entire file. 41|216|398555|77|provided complete NP outcome data ... (21 Replies)
Discussion started by: Narasimhasss
21 Replies

4. Shell Programming and Scripting

awk to change comma separated line to horizontal

I am trying to change a file that looks like this: file, announcement,date, server, server01, server02, server06, file04, rec01, rec04, rec03... etc into a vertical file like this: file announcement date server server01 server02 server06 The file does not have to be sorted... (5 Replies)
Discussion started by: newbie2010
5 Replies

5. UNIX for Dummies Questions & Answers

How to convert a comma delimited string to records or lines of text?

Hi, I am not sure if I've posted this question before. Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o Can anyone advise how is this possible? Example as below: Converting records/lines to... (2 Replies)
Discussion started by: newbie_01
2 Replies

6. Shell Programming and Scripting

How can i comma-delimited last field in line?

Awk gurus, Greatly appreciate for any kind of assistance from the expert community Input line: abc,11.22.33.44,xyz,7-8-9-10 pqr,111.222.333.444,wxy,1-2-3 def,22.33.44.55,stu,7-8 used the gsub function below but it changes all of the "-" delimiter: awk 'gsub("-",",")' Desired... (4 Replies)
Discussion started by: ux4me
4 Replies

7. Shell Programming and Scripting

Need a script to convert comma delimited files to semi colon delimited

Hi All, I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies

8. UNIX for Advanced & Expert Users

pattern matching with comma delimited text

Hi, I have two files that I need to match patterns with and the second file has comma delimited rows of data that match but I'm having trouble getting a script to work that gives me the match output to these sets : file 1: PADG_05255 PADG_06803 PADG_07148 PADG_02849 PADG_02886... (8 Replies)
Discussion started by: greptastic
8 Replies

9. Shell Programming and Scripting

How do you delete multiple text from a comma delimited file

I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST): 1, 2,43,34, bosx,PEST 1,... (1 Reply)
Discussion started by: dolo21taf
1 Replies

10. Shell Programming and Scripting

Parsing comma delimited text file

I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days. The format is like this: dirA,5 dirB,7 How do I write script to iteratively parse this text file & delete... (5 Replies)
Discussion started by: chengwei
5 Replies
Login or Register to Ask a Question