Different length of record

[#1]

If I read several text files into one table and I need to increase the last file with a new 'field' at the end

of the line, how can I avoid that the table get records with different length as the last column in the Picture?

kindly

Håkan

[marcus_sommer]

I think you will need to react on the different lenghts. If they come from different files you could simply use different load-statements. If they are different within a file you need to check the lenght of an record maybe with:

if(len(@1:n) > X, then, else)

or also with different loadings and putting the len() check within a where-clause.

- Marcus

[MarcoWedel]

please post some sample data to test with.

thanks

regards

Marco

[#4]

Hello,

I made a Dirty trick to add the extra field with spaces in the file with shorter records and

I will test it in full scale now. Thanks for your help.