Re: OT: awk problem

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Wed, 15 May 2002 02:43:25 -0800
Message-ID: <F001.00460DA8.20020515024325@fatcity.com>

Hello Maria,

You should look at your file in some hex editor, this symbols might be symbols with hex code 0A or 0D 0A (it means new line). So you have to set correct RS value.

Wednesday, May 15, 2002, 3:28:38 PM, you wrote:

MAVdlV>  
MAVdlV> I'm hoping that there are awk gurus also in this list.my problem:
MAVdlV> when I use awk, it cuts off a part of the line

MAVdlV> $ cat -n *0509*|awk '{if
MAVdlV> ((substr($0,34,2) == "1I")    (length($0)) == 107) {print $0}}'|sort
MAVdlV>   1248  110
MAVdlV> 20020509909000010931381IF110 201 90900001PCOR    AJ       
MAVdlV> S10000       10000      
MAVdlV> 00001.7600MD
MAVdlV>   1249  110
MAVdlV> 20020509909000020931511IF110 201 90900002PCOR    AJ       
MAVdlV> S10000       10000      
MAVdlV> 00001.7800MD
MAVdlV>   1250  110
MAVdlV> 20020509909000030931591IF110 201 90900003PCOR    AJ       

MAVdlV> S20000       20000      
MAVdlV> 00001.8000MD

MAVdlV> i am supposed to get
MAVdlV> a longer line
MAVdlV> getting line 1248 as
MAVdlV> an example:

MAVdlV> $ grep "110 20020509909000010931381IF110
MAVdlV> 201 90900001PCOR" *0509*
MAVdlV> 110 20020509909000010931381IF110
MAVdlV> 201 90900001PCOR    AJ       

MAVdlV> S10000       10000      
MAVdlV> 00001.7600MD C0905L

MAVdlV> if I look at the file in windows notepad, this same line has 4box characters
MAVdlV> between  00001.7600MD and C0905L
MAVdlV> I am not sure what those 4 box characters are.

MAVdlV> help.

MAVdlV> Thanks.

MAVdlV> =)
MAVdlV> --
MAVdlV> "Never attribute to malice that which can be adequately explained by
MAVdlV> stupidity."

MAVdlV> Maria Aurora VT de la Vega OCP
MAVdlV> Database Specialist
MAVdlV> Philippine Stock Exchange, Inc.

MAVdlV>  --
MAVdlV> Please see the official ORACLE-L FAQ: http://www.orafaq.com

--

Best regards,

 Sergey                            mailto:dsv_at_pptus.oilnet.ru

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sergey V Dolgov
  INET: dsv_at_pptus.oilnet.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 15 2002 - 05:43:25 CDT