Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Ignore some lines with specific words from file comparison
Top Forums Shell Programming and Scripting Ignore some lines with specific words from file comparison Post 302174257 by jakSun8 on Monday 10th of March 2008 02:12:03 PM
Old 03-10-2008
Ignore some lines with specific words from file comparison
Hi all,

I need help in doing this scenario. I have two files with multiple lines. I want to compare these two files but ignoring the lines which have words like Tran, Loc, Addr, Charge. Also if i have a word Credit in line, i want to tokenize (i.e string after character "[" ) that line and compare a substring of it.

File looks like

Record 1
Tran@1050e1f[
airbillNbr=1324576
origLocInfo=Loc@1c29ab2[
locId=923
state=FL
locCntry=US
postal=32817
locNbr=456
locCurr=CAD
lglEntity=E
]
destLocInfo=Loc@337838[
locId=298
state=FL
locCntry=US
postal=32845
locNbr=456
locCurr=CAD
lglEntity=E
]
shpDt=Tue Jan 08 00:00:00 EST 2008
shprAddrInfo=Addr@18558d2[
acctNbr=123456789
name=Peyton Manning
company=Giants
address1=Sports Nation
address2=
city=New York
state=NY
country=US
postal=76543
]
Charge@19c26f5[
code=305
crdtCard=Credit@15eb0a[creditCardTypeCode=M,creditCardExpDate=Sat Feb 28 00:00:00 EST 2009]

Any help is appreciated.
Thanks,
Jak
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to ignore the Spaces while string Comparison

I want to ignore the spaces while doing string comparison between two files. Iam using "comm" command to compare the files. (1 Reply)
Discussion started by: sudhakaryadav
1 Replies

2. UNIX for Dummies Questions & Answers

Ignore a string pattern while doing file comparison/difference

Here is my problem. I have to find the differences in 2 XML files This is my Old File contents - File1 <FILEHDR> <Bag xsi:nil='true'></Bag> </FILEHDR> This is my New File contents - File2 <FILEHDR> <Bag xsi:nil='true' ></Bag> </FILEHDR> When I do the following diff -b File1 File2... (1 Reply)
Discussion started by: sksahu
1 Replies

3. Shell Programming and Scripting

To fetch specific words from a file

Hi All, I have a file like this,(This is a sql output file) cat query_file 200000029 12345 10001 0.2 0 I want to fetch the values 200000029,10001,0.2 .I tried using the below code but i could get... (2 Replies)
Discussion started by: girish.raos
2 Replies

4. Shell Programming and Scripting

Keep lines with specific words up in an order

I hava a file with following data: number|CREDIT_ID|NULL date|SYS_CREATION_DATE|NULL varchar2|GGS_COMMIT_CHAR|NULL varchar2|GGS_OP_TYPE|NULL number|GGS_SCN|NULL| number|GGS_LOG_SEQ|NULL number|GGS_LOG_POS|NULL number|GGS_ORACREC_SCN|NULL varchar2|BATCH_ID|NULL char|GGS_IMAGE_TYPE|NULL ... (6 Replies)
Discussion started by: kolesunil
6 Replies

5. UNIX and Linux Applications

Reading a file for specific words

Hi I have a script where the user calls it with arguments like so: ./import.sh -s DNSNAME -d DBNAME I want to check that the database entered is valid by going through a passwd.ds file and checking if the database exists there. If it doesn't, the I need to send a message to my log... (4 Replies)
Discussion started by: ladyAnne
4 Replies

6. UNIX Desktop Questions & Answers

Display a specific words from a multiple lines

well, i am so not familiar with this kind of things but i am gonna explain extactly what i am looking for so hopfully someone can figure it out :) i have a command that shows memory usage besides the process name, for example(the command output): 500 kb process_1 600 kb process_2 700 kb... (4 Replies)
Discussion started by: Portabello
4 Replies

7. Shell Programming and Scripting

How to ignore single or multiple lines between /* and */ while reading from a file in unix?

I have a file proc.txt: if @debug = 1 then message 'Start Processing ', @procname, dateformat(now(*), 'hh:mm:ss'), @julian type info to client; end if; /* execute immediate with quotes 'insert into sys_suppdata (property, value, key_name) location ''' || @supp_server || '.' ||... (5 Replies)
Discussion started by: kidncute
5 Replies

8. UNIX for Dummies Questions & Answers

Extract lines with specific words with addition 2 lines before and after

Dear all, Greetings. I would like to ask for your help to extract lines with specific words in addition 2 lines before and after these lines by using awk or sed. For example, the input file is: 1 ak1 abc1.0 1 ak2 abc1.0 1 ak3 abc1.0 1 ak4 abc1.0 1 ak5 abc1.1 1 ak6 abc1.1 1 ak7... (7 Replies)
Discussion started by: Amanda Low
7 Replies

9. Shell Programming and Scripting

how to print specific lines or words

Hi, Please have a look on below records. STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: The value of the row is: EMPLID = 220677 COMPANY = 919 BALANCE_ID = 0 BALANCE_YEAR = 2012 STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated ... (4 Replies)
Discussion started by: Sachin Lakka
4 Replies

10. UNIX for Dummies Questions & Answers

Ignore all lines except the --- dash line in a text file.

How do you write a script to ignore all lines except the --- dash lines and then remove --- dashes from the data in a text file? Also how do you separate data in a text file with a tab (for example, column1 (software) and column2 (date) ) ? Here is my scripts : I am getting errors in... (3 Replies)
Discussion started by: dellanicholson
3 Replies

LEARN ABOUT DEBIAN

postal-list

postal-list(1)							      Postal							    postal-list(1)

NAME

       postal-list - program to show how postal expands user names

SYNOPSIS

       postal-list user-list-filename conversion-filename

DESCRIPTION

       This  program shows the expansion that the postal program uses on email addresses.  This can be used to make sure that you're configuration
       files do what you expect them to, and can also be used to produce a list of user-names for an account creation script (in case you want	to
       create a million test accounts in a conveniant fashion).

       The  user-list-filename is the name of a file which contains a list of user's email addresses.  This can be just user-names or fully quali-
       fied email addresses.

       The conversion-filename parameter will be the name of a file containing the conversions to apply to email addresses.  Each line in the file
       can  either  be	a  comment  (starting with "#") or is to contain two parameters.  The first parameter is the regular expression.  For each
       email that is to be sent a randomly selected user-name will be checked against all regular expressions, the first match will determine  the
       translation  that  is to be applied.  The translation will be the second parameter on the line.	It will contain a number of "." characters
       specifying characters in the name that are not to be translated.  To specify the translations a range of characters can be specified inside
       square brackets.  For example to have every address starting with "a" have a character from "01234567890abc" as it's second character and a
       character from "xyz" as it's third character you would have the following: ^a .[0-9abc][xyz]

RETURN CODES

       0      No Error

       1      Bad Parameters

AUTHOR

       This program, it's manual page, and the Debian package were written by Russell Coker <russell@coker.com.au>.

AVAILABILITY

       The source is available from http://doc.coker.com.au/projects/postal/ .

       See http://etbe.coker.com.au/category/benchmark for further information.

SEE ALSO

       postal(8),rabid(8),regex(7)

russell@coker.com.au						       0.70							    postal-list(1)
All times are GMT -4. The time now is 04:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy