Sponsored Content
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 303028785 by apmcd47 on Tuesday 15th of January 2019 04:48:27 AM
Old 01-15-2019
Quote:
Originally Posted by newbie_01
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

No, I think you did the right thing. You searched the forum for your problem, and now you are asking for a refinement, after finding your own solution, which you consider sub-optimal. I have to admit I would be happy with piping the output into nl.

Try this variation on your second solution:
Code:
$ printf "a,b,c,d\ne,f,g,h\n" | awk -F"," 'BEGIN{x=1;}{for(i=1;i<=NF;i++){print x++,$i}}'
1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h

Andrew

Last edited by rbatte1; 01-15-2019 at 07:47 AM.. Reason: Just changing the quoted text to match the edit I made to post 1
These 2 Users Gave Thanks to apmcd47 For This Post:
 

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
post(8) 						      System Manager's Manual							   post(8)

NAME
post - deliver a message SYNOPSIS
/usr/lib/mh/post [options] file OPTIONS
Specifies a file that post should take aliases from. More than one file can be specified, each being preceded with the -alias option. The post program automatically consults the system alias file, /usr/lib/mh/MailAliases. If there is an Aliasfile entry in your post also con- sults the file named in that entry. Filters (re-formats) messages sent to blind copy recipients. Recipients named in the Bcc: field nor- mally receive a new message which includes a copy of the message sent to the other recipients. If this option is specified, this copy of the message is filtered according to the instructions in the named file. The default is -nofilter. Formats messages so as to conform to ARPAnet Internet Message Format protocol. This is the default behavior. You can post from formatting messages in this way by using the -noformat option. Prints a list of the valid options to this command. Adds a Message-ID: or Resent-Message-ID: field to the header. Specifies the mail system over which mail is sent. The only value allowed is smtp, which is the standard mail system. Additional values are supported only for use with other mail systems. Informs the user of each step of the posting/filing process. Allows the user to watch the transport system's handling of the message (for example, local and fast delivery). Specifies the preferred length of the header compo- nents that contain addresses. The default settings for post are: -alias /usr/lib/mh/MailAliases -format -nomsgid -mts smtp -noverbose -nowatch -width 72 -nofilter DESCRIPTION
The program post is called by send(1) to deliver the message in the named file to local and remote users. In fact, all of the functions at- tributed to send on its reference page are performed by post, with send acting as a relatively simple pre-processor. Thus, it is post which parses the various header fields, appends From: and Date: lines, and interacts with the transport system. Normally, post would not be called directly by the user. It searches the To:, cc:, Bcc:, and Resent-xxx: header lines of the specified message for destination addresses, checks these addresses for validity, and formats them so as to conform to ARPAnet Internet Message Format protocol (unless the -noformat option is set). This will normally cause @local-site to be appended to each local destination address, as well as any local return addresses. If a Bcc: field is encountered, the mail system will use its addresses for delivery. The Bcc: is removed from the message sent to original recipients. The copied recipients will receive an entirely new message with a minimal set of headers. The mail system includes a copy of the message sent to the original recipients in the body of the message. This command consults the environment variable $SIGNATURE to determine the sender's personal name in constructing the From: line of the message. RESTRICTIONS
For this version, the -mts option only supports the value smtp. Additional values are supported for use only with other mail systems. PROFILE COMPONENTS
The post command does not consult the user's FILES
The system customization file. The program to process Fcc:s. The program to process Bcc:s. The system alias file. SEE ALSO
Commands: comp(1), mhmail(1), send(1) Files: mh-alias(4), mh-mail(4), mtstailor(4) Standard for the Format of ARPA Internet Text Messages (RFC 822) post(8)
All times are GMT -4. The time now is 06:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy