You could try something like:
The sed is substituting the pipe to comma so that awk can recognize it as one field.
Quote:
Originally Posted by Jotne
Please do use code tags
I think the only good solution for you is to change the pipe | inside double quotes "" to something else, like yoda does ...
The idea is good: transform the data, before it's seen by the main script, then undo the transform after the main script has done its job.
The implementation, however, is not. Modifying field contents should be avoided. It is much less intrusive to eliminate collisions between delimiter-pipes and quoted-pipes by replacing the delimiter-pipes. Why does this matter? Because delimiters are not visible from AWK script logic. Field contents, however, are visible and used in unpredictable ways.
Instead of changing xx|yy|"xyz|xx"|AAA|12... into xx|yy|"xyz,xx"|AAA|12..., it should become xx,yy,"xyz|xx",AAA,12....
I have a pipe delimited input file as below. First byte of the each line indicate the record type. Then i need to split the file based on record_type = null,0,1,2,6 and create 5 files. How do i do this in a ksh script? Pls help
|sl||SL|SL|SL|1996/04/03|1988/09/15|C|A|sl||||*|... (4 Replies)
:)Hi Friends,
I have certain log files extracted. I want it to be converted in pipe ( | ) delimited file. How do i do it?
E.g.
Account Balance : 123456789 Rs O/P (Account Balance: | 123456789 Rs)
Account Balance (Last) > 987654321 Rs O/P (Account Balance (Last) | 987654321 Rs)
Last... (5 Replies)
Hey,
I am new to regualar expression. I wanted to extract the information from a pipe delimited file which has some entries like
L|S2CMG1B|||-11178399||1|-8.65|IRCSH|BOND||||N|S|IRDL|AUD||CRP|STD|CRP|M|0|1|||CSH||||OTHER|01|DE|KFW|50418Y9T5|||||||||||2||||||
In this I want to extract the... (1 Reply)
i have a file whose data is like this::
osr_pe_assign|-120|wg000d@att.com|4|
osr_evt|-21|wg000d@att.com|4|
pe_avail|-21|wg000d@att.com|4|
osr_svt|-11|wg000d@att.com|4|
pe_mop|-13|wg000d@att.com|4|
instar_ready|-35|wg000d@att.com|4|
nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
I have a large(ish) pipe delimited file.
The last line of the file contains a total row count and a checksum:
END|1537451|1328569446
After making other adjustments to the file, I need to strip out the checksum and apply a new value - I have a script to generate the checksum and 'cat' it... (3 Replies)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
Hi Guys,
i am reading a pipe delimited file using awk command.
I have tested the gawk separately. it was fine.
But when i execute the script. i am getting the following error saying command not found.
Can somebody point out as what i am doing wrong.
Cheers!!! (3 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies
LEARN ABOUT DEBIAN
poe::pipe::oneway
POE::Pipe::OneWay(3pm) User Contributed Perl Documentation POE::Pipe::OneWay(3pm)NAME
POE::Pipe::OneWay - a portable API for one-way pipes
SYNOPSIS
my ($read, $write) = POE::Pipe::OneWay->new();
die "couldn't create a pipe: $!" unless defined $read;
DESCRIPTION
The right way to create an anonymous pipe varies from one operating system to the next. Some operating systems support "pipe()". Others
require "socketpair()". And a few operating systems support neither, so a plain old socket must be created.
POE::Pipe::OneWay will attempt to create a unidirectional pipe using "pipe()", "socketpair()", and IO::Socket::INET, in that order.
Exceptions are hardcoded for operating systems with broken or nonstandard behaviors.
The upshot of all this is that an application can portably create a one-way pipe by instantiating POE::Pipe::OneWay. The work of deciding
how to create the pipe and opening the handles will be taken care of internally.
POE::Pipe::OneWay may be used outside of POE, as it doesn't use POE internally.
PUBLIC METHODS
new [TYPE]
Create a new one-way pipe, optionally constraining it to a particular TYPE of pipe. One-way pipes have two ends: a "read" end and a
"write" end. On success, new() returns two handles: one for the "read" end and one for the "write" end. Returns nothing on failure, and
sets $! to explain why the constructor failed.
my ($read, $write) = POE::Pipe::OneWay->new();
die $! unless defined $read;
TYPE may be one of "pipe", "socketpair", or "inet". When set, POE::Pipe::OneWay will constrain its search to either "pipe()", a UNIX-
domain "socketpair()", or plain old sockets, respectively. Otherwise new() will try each method in order, or a particular method
predetermined to be the best one for the current operating environment.
BUGS
POE::Pipe::OneWay may block up to one second on some systems if failure occurs while trying to create "inet" sockets.
SEE ALSO
POE::Pipe, POE::Pipe::TwoWay.
AUTHOR & COPYRIGHT
POE::Pipe::OneWay is copyright 2000-2008 by Rocco Caputo. All rights reserved. POE::Pipe::OneWay is free software; you may redistribute
it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-15 POE::Pipe::OneWay(3pm)