Replace delimeter between quotes with \| using sed or awk
I've a pipe delimited data in a file of size 3GB. if the text data conatins pipe delimiter that will be enclose with double quotes. I have to replace delimiter which exists between double quotes with #%@#%@#%@ using awk or sed. can some one provide a better and efficient solution to me.
The below snippet code which I used is taking longer time to execute the file.
.
Result:
Last edited by Scrutinizer; 05-04-2015 at 03:49 PM..
Reason: code tags (mod:also for script)
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)
I have file like below
abc 12 34 45 code
abcdef 451 1 4 code
ghtyggg 4 56 3 code
I need to change this to
abc|12|34|45|code|
abcdef|451|1|4|code|
ghtyggg|4|56|3|code|
I tried replace space with | in sed ... but in the middle some row has... (7 Replies)
Hello,
Need a AWK command to find and replace Double Quotes in Pipe delimited files
Actully its a CSV file converted to Pipe but the double quotes still exists. So i want to Get rid of them.
Example
Input
1|2|3|sadsad|"Abc Efg 3"""|dada
Output
1|2|3|sadsad|Abc Efg 3"|dada
Thanks... (5 Replies)
Hi All,
I have been trying to replace a string using the sed command
string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion
I want to replace a place string... (6 Replies)
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... (6 Replies)
Hi All,
I have an awk command that uses the substr function - At the moment I know the length of the values so can use the example below i.e substr(i,0,1)
However in future these lengths may change so wondered if you can use a delimiter within a substr? Like in bash you could use cut -d ';',... (6 Replies)
Hi,
Need help on replacing every second instance of delimeter.
Scenario:
var="Name1,Value1,Name2,Value2,Name3,Value3,Name4,Value"
I want every second "," to replace with "|"
I tried like below
echo $var| sed 's/,/|/2'
But, it's not working.
Expected output:
... (4 Replies)
I need to replace consecutive double quotes in a csv file, the data in the file is enclosed in double quotes but there are some places where the quotes are repeating
Example is below
Incoming data is :
"Pacific Region"|"PNG"|"Jimmy""|""|
Need output as:
"Pacific... (10 Replies)
Discussion started by: abhilashnair
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)