Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT: awk problem
('binary' encoding is not supported, stored as-is)
>----- Original Message -----
>From: Maria Aurora VT de la Vega
><mtdelavega_at_pse.org.ph>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Wed, 15 May 2002 00:23:22
>
>I'm hoping that there are awk gurus also in this
>list.
>
>my problem:
>when I use awk, it cuts off a part of the line
>
>$ cat -n *0509*|awk '{if ((substr($0,34,2) == "1I")
>&& (length($0)) ==
>107) {print $0}}'|sort
> 1248 110 20020509909000010931381IF110 201
>90900001PCOR AJ
>S10000 10000 00001.7600MD
> 1249 110 20020509909000020931511IF110 201
>90900002PCOR AJ
>S10000 10000 00001.7800MD
> 1250 110 20020509909000030931591IF110 201
>90900003PCOR AJ
>S20000 20000 00001.8000MD
> 1251 110 20020509909000040932551IF110 201
>90900004PCOR AJ
>B10000 10000 00001.6800MD
> 1253 110 20020509909000050933021IF110 201
>90900005PCOR AJ
>B10000 10000 00001.6600MD
> 1254 110 20020509909000060933091IF110 201
>90900006PCOR AJ
>B20000 20000 00001.6400MD
> 1255 110 20020509909000070935361IF110 201
>90900007MERB AJ
>S1000 1000 00040.5000MD
> 1256 110 20020509909000080935421IF110 201
>90900008MERB AJ
>S1000 1000 00041.0000MD
> 1257 110 20020509909000090935491IF110 201
>90900009MERB AJ
>S1000 1000 00041.5000MD
> 1258 110 20020509909000100936101IF110 201
>90900010MBT AJ
>S1000 1000 00041.5000MD
> 1259 110 20020509909000110938211IF110 201
>90900011FPH AJ
>S1000 1000 00027.5000MD
> 1260 110 20020509909000120938291IF110 201
>90900012FPH AJ
>S1000 1000 00028.0000MD
> 1261 110 20020509909000130938561IF110 201
>90900013PCOR AJ
>S10000 10000 00001.7400MD
> 1262 110 20020509909000140939271IF110 201
>90900014MERB AJ
>S1000 1000 00040.5000MD
>
>i am supposed to get a longer line
>getting line 1248 as an example:
>
>$ grep "110 20020509909000010931381IF110 201
>90900001PCOR" *0509*
>110 20020509909000010931381IF110 201 90900001PCOR
> AJ
>S10000 10000 00001.7600MD C0905L
>
>^^^^^^
>
>LOST PART
>
>if I look at the file in windows notepad, this same
>line has 4box
>characters between 00001.7600MD and C0905L
>I am not sure what those 4 box characters are.
>
>help.
>
>Thanks.
>
>=)
>--
>Maria Aurora VT de la Vega OCP
>Database Specialist
>Philippine Stock Exchange, Inc.
>
Regards,
Stephane Faroult
Oriole
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: sfaroult_at_oriolecorp.com 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 - 04:43:19 CDT
![]() |
![]() |