06-08-2009
Thanks for your help. The only problem is that it only works if those are actual values which won't normally be the case in real world situations.
Those are examples to make it easy to get the point across problem across.
Sample data:
01440|27722011|37271144|PI:SK
03421|908900-APA-2121|90-APAJL-11AAP|QM
43033|21XZ121L|QUMU34121A|QM:PI
45131|10-11-21AJQX|34PAM-42|UD
etc...
I was trying convert the last field codes to something like this:
01440|27722011|37271144|Invalid Product,Invalid SKU
03421|908900-APA-2121|90-APAJL-11AAP|Missing Quantity
43033|21XZ121L|QUMU34121A|Missing Quantity,Invalid Product
45131|10-11-21AJQX|34PAM-42|Unknown Destination
etc.
Thanks for your help/time though.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I would like to know if it is possible to sum some specific fields.
I have this
x;x;x;x;x;x;x;x;467,390,611 Bytes;0.435291 GB;0.062247 GB;0.373045 GB;11,225;157
a;a;a;a;a;a;a;a;13,805,156,846 Bytes;12.857054 GB;1.838559 GB;11.018495 GB;151,063;18,933
b;b;b;b;b;b;b;b;232,797,478,723... (5 Replies)
Discussion started by: nakaedu
5 Replies
2. UNIX for Dummies Questions & Answers
Hi
I need to generate these output file from the below input file.
Output :
customer_id as customer,
zip as zip_cd,
catg_cd as catg,
Input:
out.customer::in.customer_id;
out.zip_cd::in.zip;
out.catg::in.catg_cd;
Could you please help me on this.
Please use code tags next... (1 Reply)
Discussion started by: Murugesh
1 Replies
3. Shell Programming and Scripting
Trying to combine strings that are a partial match to another in $1 (usually below it). If a match is found than the $2 value is added to the $2 value of the match and the $3 value is added to the $3 value of the match. I am not sure how to do this and need some expert help. Thank you :).
file
... (2 Replies)
Discussion started by: cmccabe
2 Replies
4. Shell Programming and Scripting
In the below awk I am trying output to one file those lines that match between $2,$3,$4 of file1 and file2 with the count in (). I am also trying to output those lines that are missing between $2,$3,$4 of file1 and file2 with the count of in () each. Both input files are tab-delimited, but the... (7 Replies)
Discussion started by: cmccabe
7 Replies
5. Shell Programming and Scripting
In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited,
that are in $1 of gene which is just a single column of text.
However only the line with the greatest $9 value in input needs to be printed.
So in the example below all the MECP2 and LTBP1... (0 Replies)
Discussion started by: cmccabe
0 Replies
6. Shell Programming and Scripting
Hello All,
Here is am trying to get maximum value of third field depending on
first,second and fourth fields with awk command . delimeter is pipe(|) .
input
0221|09|14.25|aaa
0221|09|44.27|aaa
0221|09|44.33|aaa
0221|09|44.53|bbb
0221|09|34.32|bbb
0221|09|37.13|bbb... (5 Replies)
Discussion started by: sayami00
5 Replies
7. Shell Programming and Scripting
Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2... (6 Replies)
Discussion started by: cmccabe
6 Replies
8. UNIX for Beginners Questions & Answers
Hi there,
I have data with similar structure as this:
CHR START-SNP END-SNP REF ALT PATIENT1 PATIENT2 PATIENT3 PATIENT4
chr1 69511 69511 A G homo hetero homo hetero
chr2 69513 69513 T C . hetero homo hetero
chr3 69814 69814 G C . . homo homo
chr4 69815 69815 C A hetero . . hetero
is... (10 Replies)
Discussion started by: daashti
10 Replies
9. Shell Programming and Scripting
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT PHP
mqseries_begin
MQSERIES_BEGIN(3) 1 MQSERIES_BEGIN(3)
mqseries_begin - MQseries MQBEGIN
SYNOPSIS
void mqseries_begin (resource $hconn, array $beginOptions, resource &$compCode, resource &$reason)
DESCRIPTION
The mqseries_begin(3) (MQBEGIN) call begins a unit of work that is coordinated by the queue manager, and that may involve external
resource managers.
Using mqseries_begin(3) starts the unit of work. Either mqseries_back(3) or mqseries_cmit(3) ends the unit of work.
PARAMETERS
o $hConn
-Connection handle.This handle represents the connection to the queue manager.
o $compCode
-Completion code.
o $reason
-Reason code qualifying the compCode.
RETURN VALUES
No value is returned.
EXAMPLES
Example #1
mqseries_begin(3) example
<?php
$mqbo = array();
mqseries_begin( $conn,
$mqbo,
$comp_code,
$reason);
if ($comp_code !== MQSERIES_MQCC_OK) {
/* reason code 2121 is a warning for more information see MQSeries reference manual.*/
if ($reason !== 2121) {
printf("CompCode:%d Reason:%d Text:%s<br>
", $comp_code, $reason, mqseries_strerror($reason));
}
}
?>
NOTES
Note
mqseries_begin(3) will not function when using MQSeries Client to connect to a Queueu Manager.
SEE ALSO
mqseries_conn(3), mqseries_connx(3), mqseries_back(3), mqseries_cmit(3).
PHP Documentation Group MQSERIES_BEGIN(3)