removing extra double quotes between pipe dilimeter Post: 302421292

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. UNIX for Dummies Questions & Answers

Removing double quotes in a file

Hi All, I have a tab delimited file where each of the strings have double quotes. The problem is that I have records which are in the following format: "TEXAS" ""HOUSTON"" "123" "" "2625-39-39" ""MAINE"" "" "456" "I" "3737-39-82" I would have to output...

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

4. Shell Programming and Scripting

AWK removing away needed double quotes.

The below code is to convert csv file to pipe delimited. It replaces comma with pipe if it is not in double quotes; If comma is in double quotes it doesnot replace the comma with a pipe. The code works fine except it eat away the double quotes in the output file. BEGIN...

5. Shell Programming and Scripting

How to remove extra double quotes from string in a delimited file??

Hi Unix Gurus.. I am new to Unix. Please help me. The file I am getting is as follows: Input File "2011-07-06 03:53:23","0","I","NOT SET ",,,,"123985","SAW CUT CONCRETE SLAB 20"THICK",,"98.57","","EACH","N" "2011-07-06 03:53:23","0","I","NOT SET ",,,,"204312","ARMAFLEX-1 3/8 X...

6. Shell Programming and Scripting

Convert csv to pipe delimited except the ones in double quotes

I have a csv data file : A,B,C,D,"A,B",E,"GG,H" E,F,G,H,I,J,"S,P" I need to replace all "," with "|" except the ones between double quotes i.e A|B|C|D|"A,B"|E|"GG,H" E|F|G|H|I|J|"S,P" CAn someone assist?

7. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

Hi All, I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes. Sample Data : "221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply...

8. Shell Programming and Scripting

Remove pipe(|) symbol ina file, except the ones which are enclosed in double quotes

9. Shell Programming and Scripting

Remove pipe(|) symbol in except the ones which are enclosed in double quotes

10. Shell Programming and Scripting

Removing consecutive double quotes

Hi I have a .csv file and when opened in notepad looks like this gggg,nnnn,"last,first","llll""",nnn So, Here I would like the ouput as below gggg,nnnn,"last,first","llll",nnn i.e replace all two double quotes into one. How could I do that? This file is being processed by another...

LEARN ABOUT DEBIAN

masqmail.aliases

masqmail.aliases(5)						   File Formats 					       masqmail.aliases(5)

NAME

       masqmail.aliases - masqmail alias file format

DESCRIPTION

       This man page describes the format of the masqmail alias file.  Its usual location is /etc/aliases.

FILE FORMAT

       The  alias  file consists of lines of the form: local_part: item1, item2, ...  Items can be surrounded by double quotes `"'.  If within the
       quotes other quotes are needed for an address they can be escaped with a leading backslash `'.

       A leading backslash `' indicates that this address shall not be further expanded.

       A leading pipe symbol `|' indicates that the item shall be treated as a pipe command.  The content of the message will then be sent to  the
       standard  input	of a command.  The command will run under the user id and group id masqmail is running as.  If quotes are needed, the pipe
       symbol must appear within the quotes.

       Loops will be detected, the offending address will be ignored.

       Aliases will be expanded at delivery time.  This means that if there is a message still in the queue and you change any alias which matches
       one of the recipient addresses, the change will have effect next time a delivery is attemped.

       There is no need to restart masqmail or run any command when the alias file has been changed.

AUTHOR

       Masqmail was written by Oliver Kurth.  It is now maintained by Markus Schnalke <meillo@marmaro.de>.

       You  will find the newest version of masqmail at http://marmaro.de/prog/masqmail/.  There is also a mailing list, you will find information
       about it at masqmail's main site.

BUGS

       Please report bugs to the mailing list.

SEE ALSO

       masqmail.conf(5), masqmail(8),

masqmail-0.2.30 						    2011-07-27						       masqmail.aliases(5)