Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

how to find 922 record 03 or 88 not found code 922 change 922 to 904

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to find 922 record 03 or 88 not found code 922 change 922 to 904
# 1  
Old 06-28-2011
how to find 922 record 03 or 88 not found code 922 change 922 to 904
Code:
%%START CBLOADER CBLOADER                   BRBAI2   000090
01,011600033,011600033,110516,0834,2,90,,2/
02,011600033,011103093,1,110317,0834,,2/
03,105581,,015,+00000416418,,,901,+00000000148,,,922,+000000

00354,,/
03,113806,,015,+00000559618,,,901,+00000000096,,,922,+000000

00621,,/
88,902,+0000000025218,,/
88,100,+0000000000000,0000000,,400,+0000000000000,0000000,/
03,8903816,,015,+00000000000,,,045,+00000000000,,,901,+00000
03,10921029,,015,+00000000000,,,901,+00000000000,,,922,+0000
49,+00000000000000000,00004/
98,+00000425683599208,37275,000148890/
99,+00000425683599208,00001,000148892/

this is my input file my question is
1)Code 922 can be found on either the ‘03’ Record, the ‘88’ Record, or not found on the Account at all. Always change ‘922’ Code to ‘904’ BAI Code when ever found and move the record to the Output File.
2)If ‘922’ BAI Code does not exist on ‘03’ Record, ‘901’ BAI Code will be there instead, move ‘03’ Record to Output File untouched.

Moderator's Comments:
Mod Comment Please use code tags, thanks.
Last edited by zaxxon; 06-28-2011 at 06:33 AM.. Reason: code tags
# 2  
Old 06-28-2011
expecting this..
Code:
% sed -n '/^03/p;/^88/p' input_file | sed 's/,922,/,904,/g' > output_file

This User Gave Thanks to jayan_jay For This Post:
sgoud
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need code for updating second record to first record in shell scripting

Hi,, I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows.. SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies

2. Shell Programming and Scripting

Delete only if duplicates found in each record

Hi, i have another problem. I have been trying to solve it by myself but failed. inputfile ;; ID T08578 NAME T08578 SBASE 30696 EBASE 32083 TYPE P func just test func chronology func cholesterol func null INT 30765-37333 INT 37154-37318 Link 5546 Link 8142 (4 Replies)
Discussion started by: redse171
4 Replies

3. UNIX for Dummies Questions & Answers

12. If an ‘88’ Record with BAI Code ‘902’ was found on input file and not written to Output file, re

This is my input file like this 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 49,+00000000000416920,00002/ 03,5313236,,015,+00231036992,,,045,+00231036992,,,901,+00000048428,,/ 88,100,+0000000000000,0000000,,400,+0000000000000,0000000,/ 88,902,+0000000079077,,/... (0 Replies)
Discussion started by: sgoud
0 Replies

4. UNIX for Dummies Questions & Answers

922’ Code does not exist on ‘03’ Record, ‘901’ Code will be there instead, move ‘03’ Record to Outp

My input file like this 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/ 03,188986,,015,+00005211517,,,901,+00000002227,,,922,+00000005308,,/... (6 Replies)
Discussion started by: sgoud
6 Replies

5. UNIX for Dummies Questions & Answers

‘922’ Code does not exist on ‘03’ Record, ‘901' Code will be there instead, move ‘03’ Record to Out

My input file like this 01,011600033,011600033,110516,0834,2,90,,2/ 02,011600033,011103093,1,110317,0834,,2/ 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 49,+00000000000416920,00002/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/... (1 Reply)
Discussion started by: sgoud
1 Replies

6. UNIX for Dummies Questions & Answers

If ‘922’ Code does not exist on ‘03’ Record, ‘901’ Code will be there instead, move ‘03’ R

01,011600033,011600033,110516,0834,2,90,,2/ 02,011600033,011103093,1,110317,0834,,2/ 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+000000 00354,,/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+000000 00621,,/ 88,902,+0000000025218,,/... (1 Reply)
Discussion started by: sgoud
1 Replies

7. UNIX for Dummies Questions & Answers

922’ Code does not exist on ‘03’ Record, ‘901’ Code will be there instead, move ‘03’ Record to Outpu

01,011600033,011600033,110516,0834,2,90,,2/ 02,011600033,011103093,1,110317,0834,,2/ 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+000000 00354,,/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+000000 00621,,/ 88,902,+0000000025218,,/... (1 Reply)
Discussion started by: sgoud
1 Replies

8. Shell Programming and Scripting

prompt to delete each record when pattern is found

Hello!. I am working on a very simple program and I have been trying different things. This is so far what I have done and there is one small detail that still does not work. It finds all the records in a phonebook per say: ./rem Susan More than one match; Please select the one to remove: ... (3 Replies)
Discussion started by: bartsimpsong
3 Replies

9. Shell Programming and Scripting

How can I parse a record found in /etc/passwd into variables?

I am working with the Oracle 10.2.0.3 job scheduler on Solaris 10, and unfortunately, the scheduler executes scripts in such a way that several default shell environment variables are not defined. For example, $HOME, $USER, and $LOGNAME are missing. How can I parse the appropriate record in... (7 Replies)
Discussion started by: shew01
7 Replies
Login or Register to Ask a Question