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:[EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sergey V Dolgov > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).