Sponsored Content
Full Discussion: Formatting Output file
Top Forums Shell Programming and Scripting Formatting Output file Post 302208884 by ynir on Wednesday 25th of June 2008 07:37:53 AM
Old 06-25-2008
MySQL

Code:
# cat aaa
Num Name ID Place ADDR City Country
1024|Name1|ID1|Street1|ADDR1|Boston|UK
1025|Name2|ID3|Street2|ADDR2|London|USA

# awk  'FS=OFS="|" {if (NR == 1) print $0; else print $1,$2,"XX",$3,$4,$5,"YY",$6,$7}' aaa
Num Name ID Place ADDR City Country
1024|Name1|XX|ID1|Street1|ADDR1|YY|Boston|UK
1025|Name2|XX|ID3|Street2|ADDR2|YY|London|USA

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help with formatting an output file

Hi guys, I need help with formatting the output of a file. Below is the script I use to generate a file called output.xls. DAY=`TZ=MYT+16 date '+%b'` DAY1=`TZ=MYT+16 date '+%e'` ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c3-7... (4 Replies)
Discussion started by: kumaran21
4 Replies

2. Shell Programming and Scripting

formatting output

my script is as follows cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'` cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'` if then if then rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt ... (1 Reply)
Discussion started by: swkambli
1 Replies

3. Shell Programming and Scripting

Formatting Output from a file

Hi guys. I'm new to Bash Programming. I've a little problem here. I have a text file, lets say data.txt, with the data: John Tan:Male:20:Singapore Mary:Female:23:Malaysia Abdul Rahman Bin Ali:Male:30:India (: is the delimiter) I want to display it like this: Name Gender Age... (6 Replies)
Discussion started by: andylbh
6 Replies

4. Shell Programming and Scripting

File output formatting

I have a file that list information about users and want to format the output into columns using Shell scripting. There are about 50 to 75 users. Example current file output fname lname address hiredate dept fname lname address hiredate dept Desired output fname ... (4 Replies)
Discussion started by: daveisme
4 Replies

5. Shell Programming and Scripting

Output formatting .

below is a CPU utilization Log for ABC server. However for every 15 minutes it generates 3 CPU values(with interval of 2 sec). Host CPU CPUtotal CPU% time ABC 101.1 2 50.55 14 : 15 ABC 100.5 2 50.25 14 : 15 ABC 100.2 2 50.1 14 : 15 ABC 100.9 2 50.45 14 : 30 ABC 100.5 2 50.25 14 : 30 ABC... (5 Replies)
Discussion started by: pinga123
5 Replies

6. Shell Programming and Scripting

Formatting output

Hi, I have a file like this -------------------------- 1 aaa xxx 55 -------------------------- 1 aaa www 32 -------------------------- 2 bbb yyy 11 -------------------------- 2 bbb zzz 34 ------------------------- 2 bbb ttt ... (3 Replies)
Discussion started by: tdev457
3 Replies

7. Shell Programming and Scripting

Formatting output

I have the output like below: DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance SERIAL: 68173531021 ========================================================================== Path# Adapter/Path Name State Mode Select Errors 0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies

8. Shell Programming and Scripting

Formatting the Output

Hi, I am trying to use printf command and format certain output in a specific format as under: While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies

9. Shell Programming and Scripting

Help needed in formatting the Output file

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT: <tell://me/sudheer> <tell://me/400> ... (3 Replies)
Discussion started by: raosr020
3 Replies

10. Shell Programming and Scripting

Formatting File Decryption Output

Below is the out put of the decrypt command. Decrypt Command: /usr/bin/gpg --yes --batch --output file.xml --decrypt file.xml.gpg Output: gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29 "XYZ <xyz@abc.com>" gpg: encrypted with 2048-bit ELG-E key, ID ECB614CF,... (5 Replies)
Discussion started by: Ariean
5 Replies
Business::PayPal::API::DirectPayments(3pm)		User Contributed Perl Documentation		Business::PayPal::API::DirectPayments(3pm)

NAME
Business::PayPal::API::DirectPayments - PayPal DirectPayments API SYNOPSIS
use Business::PayPal::API qw(DirectPayments); ## see Business::PayPal::API documentation for parameters my $pp = new Business::PayPal::API( Username => 'name_api1.example.org', Password => 'somepass', CertFile => '/path/to/tester1.cert_key_pem.txt', KeyFile => '/path/to/tester1.cert_key_pem.txt', sandbox => 1, ); my %response = $pp->DoDirectPaymentRequest ( PaymentAction => 'Sale', OrderTotal => 13.59, TaxTotal => 0.0, ShippingTotal => 0.0, ItemTotal => 0.0, HandlingTotal => 0.0, InvoiceID => 'your-tracking-number', CreditCardType => 'Visa', CreditCardNumber => '4561435600988217', ExpMonth => '01', ExpYear => '2007', CVV2 => '123', FirstName => 'James', LastName => 'PuffDaddy', Street1 => '1st Street LaCausa', Street2 => '', CityName => 'La', StateOrProvince => 'Ca', PostalCode => '90210', Country => 'US', Payer => 'Joe@Example.org', ShipToName => 'Jane Doe', ShipToStreet1 => '1234 S. Pleasant St.', ShipToStreet2 => 'Suite #992', ShipToCityName => 'Vacation Town', ShipToStateOrProvince => 'FL', ShipToCountry => 'US', ShipToPostalCode => '12345', CurrencyID => 'USD', IPAddress => '10.0.0.1', MerchantSessionID => '10113301', ); DESCRIPTION
Business::PayPal::API::DirectPayments implements PayPal's DirectPayments API using SOAP::Lite to make direct API calls to PayPal's SOAP API server. It also implements support for testing via PayPal's sandbox. Please see Business::PayPal::API for details on using the PayPal sandbox. DoDirectPaymentRequest Implements PayPal's DoDirectPaymentRequest API call. Supported parameters include: PaymentAction ( Sale|Authorize, Sale is default ) OrderTotal TaxTotal ShippingTotal ItemTotal HandlingTotal InvoiceID CreditCardType CreditCardNumber ExpMonth ( two digits, leading zero ) ExpYear ( four digits, 20XX ) CVV2 FirstName LastName Street1 Street2 CityName StateOrProvince PostalCode Country Payer ShipToName ShipToStreet1 ShipToStreet2 ShipToCityName ShipToStateOrProvince ShipToCountry ShipToPostalCode CurrencyID (USD is default) IPAddress MerchantSessionID as described in the PayPal "Web Services API Reference" document. Returns a hash containing the results of the transaction. The Ack element and TransactionID are the most useful return values. Example: my %resp = $pp->DoDirectPaymentRequest( PaymentAction => 'Sale', OrderTotal => '10.99', ... ); unless( $resp{Ack} !~ /Success/ ) { for my $error ( @{$response{Errors}} ) { warn "Error: " . $error->{LongMessage} . " "; } } ERROR HANDLING See the ERROR HANDLING section of Business::PayPal::API for information on handling errors. EXPORT None by default. SEE ALSO
<https://developer.paypal.com/en_US/pdf/PP_APIReference.pdf> AUTHOR
Daniel Hembree <danny@dynamical.org> COPYRIGHT AND LICENSE
Copyright (C) 2006 by Daniel P. Hembree This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.5 or, at your option, any later version of Perl 5 you may have available. perl v5.14.2 2009-12-07 Business::PayPal::API::DirectPayments(3pm)
All times are GMT -4. The time now is 01:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy