I have a CSV file I want to Load in a script. One of the fields is a long string of text that may contain CR characters (multiple lines). Qlikview must read these as being the end of a record and as such tries to create a new record when it encounters one of these. Is there someway to get it to ignore these and keep them as part of the field they belong to? I guess another way to put it would be - Can the End of Record character be specified as something else?
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
