Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help on an old post - How to convert a comma delimited string to records or lines of text?
Top Forums UNIX for Beginners Questions & Answers Need help on an old post - How to convert a comma delimited string to records or lines of text? Post 303028784 by newbie_01 on Tuesday 15th of January 2019 03:59:20 AM
Old 01-15-2019
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 convert a comma delimited string to records or lines of text?

I just want to know if there is a way to number the output. At the moment, I am piping the output to nl to generate a numbered list. I just want to know how I can change the following so it can be a numbered output without using nl.

Not sure if I should PM RudiC or RavinderSingh13, sorry.

Code:
tr ',' '\n' < file3
user1
user2
user3
user4

awk -F"," '{for(i=1;i<=NF;i++){print $i}}' Input_file
OR
awk '{gsub(/\,/,"\n",$0);print $0}' Input_file

Last edited by rbatte1; 01-15-2019 at 07:29 AM..
 

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

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

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

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 07:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy