Hi all,
I have the following line in the file in the
text file being
sent to me (just an example):
x
16
18
20
22
24 <-
tab (hidden)
Very last character on that line is TAB
character.
I am trying to account for that, but for some
reason can’t
catch it:
vSize_field :=
TRIM(SUBSTR(vLine,C_SIZE_FIELD_START,C_SIZE_FIELD_LEN));
vSize_id := sc_get_size_fn(vSize_field,' ');
WHILE ( vSize_field IS NOT NULL OR
TRIM(vSize_field)
<> ' ' OR TRIM(vSize_id) <> CHR(9) )
LOOP
-- store values in collection
vNext_row := NVL(sc_size.LAST,0)+1;
sc_size(vNext_row) := vSize_id;
-- progress down the line
C_SIZE_FIELD_START := C_SIZE_FIELD_START +
C_SIZE_FIELD_LEN;
-- retrieve current values
vSize_field :=
TRIM(SUBSTR(vLine,C_SIZE_FIELD_START,C_SIZE_FIELD_LEN));
vSize_id := sc_get_size_fn(vSize_field,' ');
END LOOP;
What am I missing?
Thanks,
Eugene
Pipko
Seattle
Pacific Industries
office:
253.872.5243
cell:
206.304.7726
P Please
consider the environment before printing this e-mail
