Christoph Jopp ha scritto:
Hi Bart,
Hi Cristophe,
don't know what you are exactly trying to do, but I assume that yoou would not need an array at all. The LoadDataFromFile function opens a file as input stream an reads line by line into an array. As you wrote that you want to iterate over the array and do something with each element, I guess you could do that also directly on the single line given back from 'oInputStream.ReadLine'.
Interestig... I have tried... but I do not find the way... Can you suggest me several lines code or an example?
So a possibility would be to rip off the parts related to assigning the lines to the array and fill in your content manipulation code.
Sorry...I am not able in wich way I can make it... BTW, making a back step, my problem is: I have a quirky DB in txt format, one field in each line. In each line the firsts caracters are codes to identify the tipe field, and a precise code (@V) identify the lines where begin a new record. (They are 15 fields per Record) The first operation is to remove the Carriage Return in all the lines, except the lines that become with code @V (In this way the file (130'000 line) is reduced (rougly) at 8'000 lines.) At last to remove (partially) alls codes, in manner to obtaine fields separatar. i.e. The fields identifiers are: @A, @B, @C, ... @Y A possible separator for final file.csv may be only "@" This is an (simplified) example: ------ original file.txt @A field1 @B field2 @C field3 @... field... @V field15 ----- final File.csv @[EMAIL PROTECTED]@field3....field15 The final File.csv will may easly imported (manually) in calc. thanks for the help Bart --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
