Re: OT: awk problem

thanks everyone for the help. =)

Sergey V Dolgov wrote:

> 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).

--
"Never attribute to malice that which can be adequately explained by stupidity."

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: mtdelavega_at_pse.org.ph

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).