Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk, comma as field separator and text inside double quotes as a field.
Top Forums Shell Programming and Scripting awk, comma as field separator and text inside double quotes as a field. Post 302471918 by Chubler_XL on Monday 15th of November 2010 03:45:12 PM
Old 11-15-2010
Quote:
Originally Posted by Scrutinizer
Try:
Code:
sed 's/,\("[^"]*"\)*/\n\1/g'

Nope:
Code:
$ echo '"hello world, test text", aaa, bbb, ccc' | sed 's/,\("[^"]*"\)*/\n\1/g'

"hello world
 test text"
 aaa
 bbb
 ccc

This User Gave Thanks to Chubler_XL For This Post:
Scrutinizer
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed removing comma inside double quotes

I have a csv file with lines like the followings 123456,"ABC CO., LTD","XXX" 789012,"DEF LIMITED", "XXX" before I bcp this file to database, the comma in "CO.," need to be removed first. My script is cat <filename> | sed 's/"CO.,"/"CO."/g' but it doesn't work. Can anyone here able to... (2 Replies)
Discussion started by: joanneho
2 Replies

2. Shell Programming and Scripting

To Replace comma with Pipe inside double quotes

Hi, I have a requirement to replace the comma's inside the double quotes. The comma's inside the double quotes will get changed dynamically. Input Record: "Washington, DC,Prabhu,aju",New York Output Record: "Washington| DC|Prabhu|aju",New York I tried with the below command but it... (3 Replies)
Discussion started by: prabhutkl
3 Replies

3. Shell Programming and Scripting

awk - double quotes as record separator

How do I use double quotes as a record seperator in awk? (4 Replies)
Discussion started by: locoroco
4 Replies

4. Shell Programming and Scripting

awk - single quotes as field separator

How can I use single quotes as field separator in awk? (1 Reply)
Discussion started by: locoroco
1 Replies

5. Shell Programming and Scripting

Awk Search text string in field, not all in field.

Hello, I am using awk to match text in a tab separated field and am able to do so when matching the exact word. My problem is that I would like to match any sequence of text in the tab-separated field without having to match it all. Any help will be appreciated. Please see the code below. awk... (3 Replies)
Discussion started by: rocket_dog
3 Replies

6. UNIX for Dummies Questions & Answers

Add a field separator (comma) inside a line of a CSV file

Hi... I can't find my little red AWK book and it's been a long while since I've awk'd. But I need to take a CSV file and convert the first word of the fifth field to its own field by replacing a space with a comma. This is for importing a spreadsheet of issues into JIRA... Example: a line... (9 Replies)
Discussion started by: Tawpie
9 Replies

7. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies

8. Shell Programming and Scripting

Inserting a field without disturbing field separator on other fields

Hi All, I have the input as below: cat input 032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies

9. Shell Programming and Scripting

How can awk ignore the field delimiter like comma inside a field?

We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below. Current file (file.csv) ---------------------- empname,date_of_join,dept,date_of_resignation ram,08/09/2015,sales,21/06/2016 "akash,sahu",08/10/2015,IT,21/07/2016 ... (6 Replies)
Discussion started by: gopal.biswal
6 Replies

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

LEARN ABOUT DEBIAN

nuaclgen

NUACLGEN(8)															       NUACLGEN(8)

NAME

       nuaclgen - NUFW acl generator

SYNOPSIS

       nuaclgen  [  --Schema eq|ineq ] [ --Aclname ACLDN ] [ --saddr NETWORK1 ] [ --daddr NETWORK2 ] [ --proto PROTONUMBER ] [ --sport P1[:P2] ] [
       --dport P3[:P4] ] [ --OsName OSNAME ] [ --OsVersion OSVERSION ] [ --OsRelease OSRELEASE ] [ --AppName APPLICATION NAME ] [ --AppSig  APPLI-
       CATION SIGNATURE ] [ --Separator SEPARATOR ] [ --jump [ACCEPT|DROP] ] [ --groups GROUPLIST ]

       nuaclgen [ --List ] [ --groups Id Group ]

       nuaclgen [ --Delete DN ]

       nuaclgen [ --help ]

DESCRIPTION

       This manual page documents the nuaclgen command.

       nuaclgen is an Access control list generator for the ldap backend of Nuauth, the authentication server of the NUFW package.

       Original packaging and informations and help can be found from http://www.nufw.org/

OPTIONS

       --Schema eq|ineq
	      Use equality schema or not (Equality schema requires dport be specified, and is the default.

       --AclName Acl DN
	      Add an acl in the ldap tree with dn Acl DN

       --saddr Network
	      Specify source network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0

       --daddr Network
	      Specify destination network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0

       --proto Protocol number
	      Specify protocol type for the acl

       --sport Source port
	      Specify source port(s) for the Acl. NNNN:MMMM can be used to specify a port range.

       --dport Destination port
	      Specify destination port(s) for the Acl. NNNN:MMMM can be used to specify a port range.

       --jump Decision
	      Specify decision for the Acl. Has to be ACCEPT or DROP.

       --groups Groups list
	      Specify the user group(s) on which Acl apply. Must be of the form : Group1[,Group2[,...]]

       --List --group Group ID
	      List Acls for the Group ID group

       --Delete Dn
	      Deletes the Acl stored in the provided Dn

       --help Displays a brief resume of available options and quits

SEE ALSO

       nufw(8)

       nuauth(8)

AUTHOR

       Nuauth  was designed and coded by Eric Leblond, aka Regit (<eric@regit.org>) , and Vincent Deffontaines, aka gryzor (<vincent@gryzor.com>).
       Original idea in 2001, while working on NSM Ldap support.

       This manual page was written by Eric Leblond and copyrighted by INL (2003-2005)

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version  2	as
       published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts.

								   12 mars 2007 						       NUACLGEN(8)
All times are GMT -4. The time now is 04:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy