Use perl & regexps
jairamk_at_geocities.com wrote:
>
> Hi! Everyone!
> I have to load to a flatfile with the following format
> <Header Fields> <Repeating group>.......
> ie
> col1|col2|col3|col4|col5_1|col5_2|...|col5_n|col6_1|col6_2|...|col6_n
>
> into a table of having the format
>
> (col1,col2,col3,col4,col5,col6)
>
> so essentially one physical record in the file will translate into
> n logical database records... the problem is how do i specify field
> positions in the control file... The examples show how to do it to fixed
> length format files but not with delimited files...
> i am at my wits end with this...
> any help will be great...
> thanx in advance
> jairam
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 25 1999 - 08:52:49 CDT
