how to load from text file but don't want all the fields be on a different line ?!?

[ivan_will]

Hi All,

want to load some fields with one value in it but when I load it from a text file have the situation:

so I want to have all the information on one line ! ? How to do that? In the load script I use if-clauses and textbetween funktions

Thanks in advance 🙂

[maneshkhottcpl]

Hi,

Please send me urtext file as sample.

[ivan_will]

text something like this: where 1) , 2) , 3) are the number of each new line

1) ID<>320<>jksdjjdifudsfhd

2) Model<>BMW<>fkdo osao os poiooeieldlk

3) date<>idfi34<>2003

So I use textbetween function and if-clauses ?

[maneshkhottcpl]

Hi,

if u send me txtfile and ur sample applicatio i will surly help u.

[suniljain]

pls post sample text file . it will help to find exact solution.

because from your above discussion it still not clear the format of data in text file.

[ivan_will]

links for download:

the source file: http://dox.bg/files/dw?a=8fe64363fa

the QV file: http://dox.bg/files/dw?a=4b91b69829

have to change the path for the text file 🙂

[ivan_will]

Hey Any ideas? I can make it using temporary table but want the reload process be faster cause have huge amount of data

[ivan_will]

? ? ?

[lironbaram]

hei ivan

try this example

hope its helps you

[ivan_will]

Yes , I know that but want to load the data without using temp tables! Want the reload be faster because have a lot of info !!!