Re: SQL*Loader POSITION clause question

I don't believe you can use POSITION to do what you want. Maybe using a SQL string (Pg. 6-5 of Oracle 7 Server Utilities Guide)

How about:
mycolumn2 POSITION(3:12) "SUBSTR(:mycolumn2,1,4)||SUBSTR(:mycolumn2,5,2)|| SUBSTR(:mycolumn2,9,2)"

??
In article 385_at_wtc35a.DaytonOH.NCR.COM, Tim Wendt <tim.wendt_at_daytonoh.ncr.com> writes:

>mycolumn2 POSITION (3:6) + POSITION (8:9) + POSITION (11:12),
>where mycolumn2 is made up of more than one POSITION clause. I'm trying to sift
>through the Utilities User's Manual but I can't seem to find an example
>describing this type of manipulation. Thanks in advance!
>
>Tim Wendt
>AT&T Global Information Solutions
>
>
>
>===========================
>"Mmm...beer" - Homer (Simpson)
>===========================
>
>
>
 

---
Gary Meyers                     : Usual disclaimer here
gary.meyers_at_Edm.Arco.COM        : My opinions, etc. etc.