Sponsored Content
Top Forums Shell Programming and Scripting How to ignore quoted separators Post 302628379 by sven44 on Monday 23rd of April 2012 11:13:26 AM
Old 04-23-2012
Question How to ignore quoted separators

Hi,

I'm trying to parse a text file which uses commas as field separators. Fields are double quoted, and may themselves contain commas, like this:

Code:
"1","John Smith","London","123"
"2","Mary Robertson","Horsham, Sussex","456"

This causes problems for the following command

Code:
cut -d"," -f4

For the first line, it correctly extracts the fourth field ["123"], but for the second, it is fooled by the comma in Mary's adress, and thinks the fourth field is [, Sussex"].

Happy to use awk or any other standard utility available. Please help!

thanks


Moderator's Comments:
Mod Comment Please use code tags, thanks!

Last edited by zaxxon; 04-23-2012 at 12:14 PM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk search for Quoted strings (')

Hi All, I have files: 1. abc.sql 'This is a sample file for testing' This does not have quotations this also does not have quotations. and this 'has quotations'. here I need to list the hard coded strings 'This is a sample file for testing' and 'has quotations'. So i have... (13 Replies)
Discussion started by: kprattip
13 Replies

2. Shell Programming and Scripting

want to remove separators from file

Hi, I have huge file, head -1 filneame gives, I just want to remove "##colsep##" from the file, and also want to count the no. of fileds present, as in Output shld be in newfile as TRADE_KEY,TRADE_DATE and total no. of fileds separated by these comma's ... (7 Replies)
Discussion started by: niceboykunal123
7 Replies

3. Shell Programming and Scripting

AWK multiple fields separators

I need to print the second field of a file, taking spaces, tab and = as field separators. ; for 16-bit app support MAPI=1 CMC=1 CMCDLLNAME32=mapi32.dll CMCDLLNAME=mapi.dll MAPIX=1 MAPIXVER=1.0.0.1 OLEMessaging=1 asf=MPEGVideo asx=MPEGVideo ivf=MPEGVideo m3u=MPEGVideo (2 Replies)
Discussion started by: PamPam
2 Replies

4. Shell Programming and Scripting

Unterminated quoted string

Hello! I wroted a little script that should check for new updates on a server and get them if any. The problem is, every time I run it with sh, I'm getting an "script: 20: Syntax error: Unterminated quoted string" error! The problem is, there isn't any "unterminated quoted string" in my script:... (2 Replies)
Discussion started by: al0x
2 Replies

5. Shell Programming and Scripting

how to use two separators in awk.

Hi, Gurus, I have a file like 1 234, 345, 456 2 345, 456, 345 I want to use awk with multipe separator ( one is comma, another is space)print out $1, $3 which should be: 1, 345 2, 456 but I don't know how to put space as separator with another separator. Thanks in advance (7 Replies)
Discussion started by: ken002
7 Replies

6. Shell Programming and Scripting

Take quoted output from one script as quoted input for another script

Hi, I have a script output.sh which produces the following output (as an example): "abc def" "ghi jkl" This output should be handled from script input.sh as input and the quotes should be treated as variable delimiters but not as regular characters. input.sh (processing positional... (2 Replies)
Discussion started by: stresing
2 Replies

7. UNIX for Dummies Questions & Answers

Count Fields with Quoted Field

Hi, I used to count number of fields using following command head -1 <filename> | awk -F"," '{print NF}' Now the scenario is the delimiter(comma) occurs inside one of the data field. How to ignore the comma inside data and consider only delimiter and count number of fields. The fields are... (1 Reply)
Discussion started by: ethanr100
1 Replies

8. UNIX for Dummies Questions & Answers

Can one use 2 field separators in awk?

I have files such as n02-z30-dsr65-terr0.25-dc0.008-16x12drw-run1.cmd I am wondering if it is possible to define two field separators "-" and "." for these strings so that $7 is run1. (5 Replies)
Discussion started by: kristinu
5 Replies

9. UNIX for Dummies Questions & Answers

grep quoted numbers from lines

I want to parse the lines and want to extract the double quoted numbers as: "SQL3149N "72" rows were processed from the input file. "0" rows were successfully inserted into the table. "0" rows were rejected." and want the output in 3 variables like a=72 b=0 c=0 thanks in advance ... (3 Replies)
Discussion started by: mahesh_191
3 Replies

10. UNIX for Advanced & Expert Users

Exclude dash (-) from word separators in vi

vi uses dash and space as word separators. is there any way to exclude dash from word separators ? This is required to work with the symbols generated by ctags exe. when symbol contain a "-" ,vi tags fails to locate that even though symbol is generated properly. For example Symbol -... (3 Replies)
Discussion started by: cabhi
3 Replies
CAPISUITEFAX(1) 														   CAPISUITEFAX(1)

NAME
capisuitefax - sending faxes with the CapiSuite default scripts SYNOPSIS
capisuitefax [-q] [-n] [-u user] [-A adr] [-S subj] -d number file... capisuitefax [-q] -a id capisuitefax -h capisuitefax -l DESCRIPTION
The default scripts for CapiSuite come with the tool capisuitefax for sending faxes. It will be called with some parameters telling it which file to send (it currently only supports PostScript and PDF files) and to which number. It will then enqueue the job converted to the right format into the send queue from which it's collected by another CapiSuite script and sent to the destination. If the sending was completed successfully or failed finally after trying for some time, the according user will get an email telling him/her what has happened. OPTIONS
-a id Abort the job with the given id. To get a job id, use the -l option. -A adr The addressee of the fax. This option is (currently) only for informational purposes and will be quoted in the sent status mail. -d number The number which should be called (destination of the fax) -h Show a short commandline help -l Shows the jobs which are currently in the send queue. -n Don't use the configured dial prefix for this job. Useful for internal jobs. -q Be quiet, don't output informational messages -S subj A subject for the fax. This option is (currently) only for informational purposes and will be quoted in the sent status mail. -u user Send fax as another user. Only allowed if capisuitefax is called as user root. This is mainly helpful for realizing extensions to e.g. do network faxing. file... One or more PostScript/PDF files to send to this destination. More than one PostScript file will produce several separate fax jobs. SEE ALSO
capisuite(8), capisuite.conf(5), fax.conf(5), answering_machine.conf(5) AUTHOR
Gernot Hillier <gernot@hillier.de>. CAPISUITEFAX(1)
All times are GMT -4. The time now is 03:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy