Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Parse apart strings of comma separated data with varying number of fields

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parse apart strings of comma separated data with varying number of fields
# 8  
Old 09-12-2008
I think I've got this one figured out thanks to your valuable input. Much thanks!

What I did, based on your input :

I read each record into $LINE and then do the following :

echo "$LINE" | tr ',' '\n' > FILE.TXT

Then all I do is read the FILE.TXT file for each of the individual elements/field data.

Thanks again for pointing me in the right direction.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

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

3. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

4. Shell Programming and Scripting

awk print - fields separated with comma's need to ignore inbetween double quotes

I am trying to re-format a .csv file using awk. I have 6 fields in the .csv file. Some of the fields are enclosed in double quotes and contain comma's inside the quotes. awk is breaking this into multiple fields. Sample lines from the .csv file: Device Name,Personnel,Date,Solution... (1 Reply)
Discussion started by: jxrst
1 Replies

5. Shell Programming and Scripting

reading comma separated data and reorder

hey guys! i need to read data from a file that are comma separated then reorder them in another file to be generated for example: x,y,z a,b,c l,m,n o,p,q and transform this into: x,a,l,o y,b,m,p z,c,n,q Will appreciate your fast reply Regards! (5 Replies)
Discussion started by: maiooi90
5 Replies

6. Shell Programming and Scripting

Perl script to parse output and print it comma separated

I need to arrange output of SQL query into a comma separated format and I'm struggling with processing the output... The output is something like this: <Attribute1 name><x amount of white spaces><Atribute value> <Attribute2 name><x amount of white spaces><Atribute value> <Attribute3... (2 Replies)
Discussion started by: Juha
2 Replies

7. Shell Programming and Scripting

Help parse comma separated list

I have a list of files with the same name, but they have a different date stamp in the name. I can find the first file, but I need to find the second file. I am using this information to create a variable I use later. Here is a example of how I find the first file. "ls -mr... (11 Replies)
Discussion started by: NoMadBanker
11 Replies

8. Shell Programming and Scripting

Varying number of awk search strings

I've created an awk script that handles a varying number of search strings handed to it as command line parameters ($1 $2 etc). There may be 1, or 2 or 3 or more. A simplified version of the script is: awk -v TYP="$1 $2 $3 $4 $5 $6" ' BEGIN { CTYP = split (TYP,TYPP," ") } ... (2 Replies)
Discussion started by: CarlosNC
2 Replies

9. Shell Programming and Scripting

Unix shell script to parse the contents of comma-separated file

Dear All, I have a comma-separated file. 1. The first line of the file(header) should have 4 commas(5 fields). 2. The last line of the file should have 1 comma(2 fields). Pls help me in checking this condition in a shell script. And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies

10. UNIX for Dummies Questions & Answers

Remove whitespaces between comma separated fields from file

Hello all, I am a unix dummy. I am trying to remove spaces between fields. I have the file in the following format 12332432, 2345 , asdfsdf ,100216 , 9999999 12332431, 2341 , asdfsd2 ,100213 , 9999999 &... (2 Replies)
Discussion started by: nitinbjoshi
2 Replies
Login or Register to Ask a Question

LEARN ABOUT OPENSOLARIS

fmlcut

fmlcut(1F)							   FMLI Commands							fmlcut(1F)

NAME

       fmlcut - cut out selected fields of each line of a file

SYNOPSIS

       fmlcut -clist [filename]...

       fmlcut -flist [-dchar] [-s] [filename]...

DESCRIPTION

       The  fmlcut function cuts out columns from a table or fields from each line in filename; in database parlance, it implements the projection
       of a relation. fmlcut can be used as a filter; if filename is not specified or is -, the standard input is read. list specifies the  fields
       to  be  selected. Fields can be fixed length (character positions) or variable length (separated by a field delimiter character), depending
       on whether -c or -f is specified.

       Note:  Either the -c or the -f option must be specified.

OPTIONS

       list	 A comma-separated list of integer field numbers (in increasing order), with optional - to indicate ranges.  For  example:  1,4,7;
		 1-3,8; -5,10 (short for 1-5,10); or 3- (short for third through last field).

       -clist	 If  -c  is  specified, list specifies character positions (for instance, -c1-72 would pass the first 72 characters of each line).
		 Note:	No space intervenes between -c and list.

       -flist	 If -f is specified, list is a list of fields assumed to be separated in the file by the default delimiter character, TAB,  or	by
		 char  if  the -d option is specified. For example, -f1,7 copies the first and seventh field only. Lines with no delimiter charac-
		 ters are passed through intact (useful for table subheadings), unless -s is specified. Note:  No space intervenes between -f  and
		 list. The following options can be used if you have specified -f.

		 -dchar    If -d is specified, char is the field delimiter. Space or other characters with special meaning to FMLI must be quoted.
			   Note:  No space intervenes between -d and char . The default field delimiter is TAB.

		 -s	   Suppresses lines with no delimiter characters. If -s is not specified, lines with no delimiters will be passed  through
			   untouched.

EXAMPLES

       Example 1 Getting login IDs and names

       The following example gets the login IDs and names.

	 example% fmlcut -d: -f1,5 /etc/passwd

       Example 2 Getting the current login name

       The next example gets the current login name.

	 example% `who am i | fmlcut -f1 -d" "`

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       fmlgrep(1F), attributes(5)

DIAGNOSTICS

       fmlcut returns the following exit values:

       0    when the selected field is successfully cut out

       2    on syntax errors

       The following error messages may be displayed on the FMLI message line:

       ERROR:  line too long

	   A line has more than 1023 characters or fields, or there is no new-line character.

       ERROR:  bad list for c/f option

	   Missing -c or -f option or incorrectly specified list. No error occurs if a line has fewer fields than the list calls for.

       ERROR:  no fields

	   The list is empty.

       ERROR:  no delimiter

	   Missing char on -d option.

NOTES

       fmlcut cannot correctly process lines longer than 1023 characters, or lines with no newline character.

SunOS 5.11							    5 Jul 1990								fmlcut(1F)