space delimited txt file in qlikview

[#1]

Hi

I have a .out file with 20 columns and this file is space delimited. When I take it in Qlikview any column value which has space is moved to two different columns. Could you please suggest how I can fix this. Thanks

I am attaching an example of a .txt file and corresponding qvw file. As you see name is Ab John which is split in two columns, I want it in same column.

Thanks

Message was edited by: Priyadarsini Krishnamurthy Added the attachment.

[#2]

Thanks for the help. Fixed record in transform wizard? Do you mean fixed record? Kindly clarify as I am still struck with the same issue

Thanks

[MarcoWedel]

Hi,

hope this helps

regards

Marco