Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to convert a comma delimited string to records or lines of text?
Top Forums UNIX for Dummies Questions & Answers How to convert a comma delimited string to records or lines of text? Post 302923876 by newbie_01 on Wednesday 5th of November 2014 01:25:38 AM
Old 11-05-2014
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 ... Smilie Smilie

Can anyone advise how is this possible?

Example as below:

Converting records/lines to a single delimited string

Code:
$ cat /tmp/x.txt
user1
user2
user3
user4
$ cat /tmp/x.txt | awk 'NR == 1 {printf "%s", $0; next} {printf ",%s", $0} END {print ""}'
user1,user2,user3,user4

$

Now I need to read a comma delimited string and convert it into records. So reading the string

Code:
user1,user2,user3,user4

And making it into something like below sorted accordingly.

Code:
user1
user2
user3
user4


I then compare this with another list of records and check for differences Smilie

Advise much appreciated. Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies

2. UNIX for Advanced & Expert Users

Urgent! need help! how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies

3. Shell Programming and Scripting

how to Insert values in multiple lines(records) within a pipe delimited text file in specific cols

this is Korn shell unix. The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Discussion started by: vasan2815
4 Replies

4. Shell Programming and Scripting

Print records which do not have expected number of fields in a comma delimited file

Hi, I have a comma (,) delimited file, in which few fields are enclosed with in double quotes " ". I have to print the records in the file which donot have expected number of field with the line number. File1 ==== name,desgnation,doj,project #header#... (7 Replies)
Discussion started by: machomaddy
7 Replies

5. Shell Programming and Scripting

how to convert comma delimited file to tab separator

Hi all, How can i convert comma delimited .csv file to tab separate using sed command or script. Thanks, Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies

6. 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

7. UNIX for Dummies Questions & Answers

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 user1 user2 user3 user4to user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually. Please... (5 Replies)
Discussion started by: newbie_01
5 Replies

8. 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

9. Shell Programming and Scripting

Linux convert Comma delimited file to pipe

I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs. Example: Input: "2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456 Output: ... (4 Replies)
Discussion started by: shieksir
4 Replies

10. 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

LEARN ABOUT DEBIAN

smpteframe

SMPTEFrame(3)							    libltcsmpte 						     SMPTEFrame(3)

NAME

       SMPTEFrame -

       Raw 80 bit SMPTE frame.

SYNOPSIS

       #include <ltcsmpte.h>

   Data Fields
       unsigned int frameUnits:4
       unsigned int user1:4
       unsigned int frameTens:2
       unsigned int dfbit:1
       unsigned int colFrm:1
       unsigned int user2:4
       unsigned int secsUnits:4
       unsigned int user3:4
       unsigned int secsTens:3
       unsigned int biphaseMarkPhaseCorrection:1
       unsigned int user4:4
       unsigned int minsUnits:4
       unsigned int user5:4
       unsigned int minsTens:3
       unsigned int binaryGroupFlagBit1:1
       unsigned int user6:4
       unsigned int hoursUnits:4
       unsigned int user7:4
       unsigned int hoursTens:2
       unsigned int reserved:1
       unsigned int binaryGroupFlagBit2:1
       unsigned int user8:4
       unsigned int syncWord:16

Detailed Description
       Raw 80 bit SMPTE frame.

       Definition at line 140 of file ltcsmpte.h.

Field Documentation
   unsigned int SMPTEFrame::binaryGroupFlagBit1
       Definition at line 160 of file ltcsmpte.h.

   unsigned int SMPTEFrame::binaryGroupFlagBit2
       Definition at line 168 of file ltcsmpte.h.

   unsigned int SMPTEFrame::biphaseMarkPhaseCorrection
       Definition at line 153 of file ltcsmpte.h.

   unsigned int SMPTEFrame::colFrm
       Definition at line 146 of file ltcsmpte.h.

   unsigned int SMPTEFrame::dfbit
       Examples:
	   tests/decoder.c.

       Definition at line 145 of file ltcsmpte.h.

   unsigned int SMPTEFrame::frameTens
       Definition at line 144 of file ltcsmpte.h.

   unsigned int SMPTEFrame::frameUnits
       Definition at line 141 of file ltcsmpte.h.

   unsigned int SMPTEFrame::hoursTens
       Definition at line 166 of file ltcsmpte.h.

   unsigned int SMPTEFrame::hoursUnits
       Definition at line 163 of file ltcsmpte.h.

   unsigned int SMPTEFrame::minsTens
       Definition at line 159 of file ltcsmpte.h.

   unsigned int SMPTEFrame::minsUnits
       Definition at line 156 of file ltcsmpte.h.

   unsigned int SMPTEFrame::reserved
       Definition at line 167 of file ltcsmpte.h.

   unsigned int SMPTEFrame::secsTens
       Definition at line 152 of file ltcsmpte.h.

   unsigned int SMPTEFrame::secsUnits
       Definition at line 149 of file ltcsmpte.h.

   unsigned int SMPTEFrame::syncWord
       Definition at line 171 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user1
       Definition at line 142 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user2
       Definition at line 147 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user3
       Definition at line 150 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user4
       Definition at line 154 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user5
       Definition at line 157 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user6
       Definition at line 161 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user7
       Definition at line 164 of file ltcsmpte.h.

   unsigned int SMPTEFrame::user8
       Definition at line 169 of file ltcsmpte.h.

Author
       Generated automatically by Doxygen for libltcsmpte from the source code.

Version 0.4.4							  Fri Apr 27 2012						     SMPTEFrame(3)
All times are GMT -4. The time now is 09:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy