Problems with loading a multiplie lines field

[#1]

Hello Members,

I habe Problems with a field that sometimes stretches accross serveral lines.

Example:

headline name ! address ! phone ! comment

line 1 1111 ! short ! 3333 ! 4444

line 2 1111 ! really, really, really, really,really, really, really, really,

line 3 loooooooooooooooooooooooooooooooooooooong

line 4 ! 3333 ! 4444

Although I use "!" as Delimiter, Qlikview only stores the really-part into the address field and interprets the long-part as new name.

It is possible, to force Qlikview to ignore the end of line and continue filling fields?

[martin59]

Hello,

Could you send a part of your file to test ? You have several options when you load a table file like your delimiter, end of file option...

Martin

[#3]

Edit: I'll upload a sample of the table. It got messed up in the first try.

[martin59]

Thanks, I'm trying to load it 😉

[martin59]

Is it what you want ?

[#6]

Yes, that was what I needed. Thank you!