Change outer double quotes to an unprintable (here a literal ^B, so remember that not carat B, but ctrl-B). Then eliminate the remaining double quotes and replace all ^Bs with double quotes.
Hi,
I am trying to replace a specific column values in a csv file with double quotes.
Example:
SNO,NAME,ZIPCODE,RANK
1,Robert,74538,12
2,Sam,07564,13
3,Kim, Ed,12345,14
Desired Output:
SNO,NAME,ZIPCODE,RANK
1,Robert Ken,74538,12
2,Sam Mik,"07564",13
3,"Kim, Ed",12345,14
I... (3 Replies)
Hello,
I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE.
Example
Input
"Chapter","NewTrains, "oldTrains","Delayed",10,"London"
"Chapter","Newbuses,oldbuses","On Time",20,"London"
Output
"Chapter","NewTrainsDSEE?DSEE... (5 Replies)
Hi,
I have data as
"01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff"
I want to remove only the Consequitive double quotes and not the one which occurs single.
My O/P must be ... (2 Replies)
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Hi Guys,
I have a file with content as below
aj.txt
"Iam
allfine" abcdef
abcd "all is
not well"
What I'm trying to say is my data has some new line characters in between quoted text. I must get ride of the newline character that comes in between the quoted text.
output must be:... (8 Replies)
Hi,
Trying to change the prompt. I have the following code.
export PS1='
<${USER}@`hostname -s`>$ '
The hostname is not displayed
<abc@`hostname -s`>$ uname -a
AIX xyz 1 6 00F736154C00
<adcwl4h@`hostname -s`>$
If I use double quotes, then the hostname is printed properly but... (3 Replies)
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
Hi Froum.
I have tried in vain to find a solution for this problem - I'm trying to replace any double quotes within a quoted string with a single quote, leaving everything else as is.
I have the following data:
Before:
... (32 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi Experts,
I am beginner to the shell scripting, My requirement is to append double quotes for each column in a file if double quotes does not exist.
Example:
"abc"|123|"gh-ch"|23.067
Use code tags, thanks. (10 Replies)
Discussion started by: spidy
10 Replies
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)