05-26-2009
convert a pipe delimited file to a':" delimited file
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|
osr_nvt|-1|wg000d@att.com|4|
port_ip_assignment|-35|wg000d@att.com|4|
i want to convert this pipe delimited file to ":" delimited file in such a way that the there is no colon at the end of each row.
plzzzz help
urgent
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, could some help me convert CSV file (with double quoted strings) to pipe delimited file:
here you go with the same data:
1,Friends,"$3.99 per 1,000 listings",8158here " 1,000 listings " should be a single field.
Thanks,
Ram (8 Replies)
Discussion started by: Ram.Math
8 Replies
2. Shell Programming and Scripting
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)
Discussion started by: nithins007
7 Replies
3. Shell Programming and Scripting
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)
Discussion started by: karumudi7
6 Replies
4. Shell Programming and Scripting
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? (8 Replies)
Discussion started by: Shivdatta
8 Replies
5. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies
6. Shell Programming and Scripting
Hi guys,
I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file
for eg:
file 1:
xx|yy|"xyz|zzz"|zzz|12...
using below awk command
awk 'BEGIN {FS=OFS="|" } print $3
i would get xyz
But i want as :
xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies
7. UNIX for Dummies Questions & Answers
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
8. Shell Programming and Scripting
Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant.
The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies
9. Shell Programming and Scripting
Hi All,
How can we convert pipe delimited ( or comma ) file to vertical tab (VT) delimited.
Regards
PK (4 Replies)
Discussion started by: prasson_ibm
4 Replies
10. Shell Programming and Scripting
I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs.
Example:
Input:
"2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456
Output:
... (4 Replies)
Discussion started by: shieksir
4 Replies
LEARN ABOUT DEBIAN
rt::client::rest::attachment
RT::Client::REST::Attachment(3pm) User Contributed Perl Documentation RT::Client::REST::Attachment(3pm)
NAME
RT::Client::REST::Attachment -- this object represents an attachment.
SYNOPSIS
my $attachments = $ticket->attachments;
my $count = $attachments->count;
print "There are $count attachments.
";
my $iterator = $attachments->get_iterator;
while (my $att = &$iterator) {
print "Id: ", $att->id, "; Subject: ", $att->subject, "
";
}
DESCRIPTION
An attachment is a second-class citizen, as it does not exist (at least from the current REST protocol implementation) by itself. At the
moment, it is always associated with a ticket (see parent_id attribute). Thus, you will rarely retrieve an attachment by itself; instead,
you should use "attachments()" method of RT::Client::REST::Ticket object to get an iterator for all attachments for that ticket.
ATTRIBUTES
id
Numeric ID of the attachment.
creator_id
Numeric ID of the user who created the attachment.
parent_id
Numeric ID of the object the attachment is associated with. This is not a proper attribute of the attachment as specified by REST -- it
is simply to store the ID of the RT::Client::REST::Ticket object this attachment belongs to.
subject
Subject of the attachment.
content_type
Content type.
file_name
File name (if any).
transaction_id
Numeric ID of the RT::Client::REST::Transaction object this attachment is associated with.
message_id
Message ID.
created
Time when the attachment was created
content
Actual content of the attachment.
headers
Headers (not parsed), if any.
parent
Parent (not sure what this is yet).
content_encoding
Content encoding, if any.
METHODS
RT::Client::REST::Attachment is a read-only object, so you cannot "store()" it. Also, because it is a second-class citizen, you cannot
"search()" or "count()" it -- use "attachments()" method provided by RT::Client::REST::Ticket.
retrieve
To retrieve an attachment, attributes id and parent_id must be set.
INTERNAL METHODS
rt_type
Returns 'attachment'.
SEE ALSO
RT::Client::REST::Ticket, RT::Client::REST::SearchResult.
AUTHOR
Dmitri Tikhonov <dtikhonov@yahoo.com>
LICENSE
Perl license with the exception of RT::Client::REST, which is GPLed.
perl v5.14.2 2011-12-27 RT::Client::REST::Attachment(3pm)