https://community.qlik.com/t5/QlikView/CSV-Import-with-Carriage-Return-characters/m-p/1727787#M592956 <P>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?</P> Sat, 16 Nov 2024 00:19:28 GMT WHowlett 2024-11-16T00:19:28Z https://community.qlik.com/t5/QlikView/CSV-Import-with-Carriage-Return-characters/m-p/1727787#M592956 <P>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?</P> Sat, 16 Nov 2024 00:19:28 GMT https://community.qlik.com/t5/QlikView/CSV-Import-with-Carriage-Return-characters/m-p/1727787#M592956 WHowlett 2024-11-16T00:19:28Z https://community.qlik.com/t5/QlikView/CSV-Import-with-Carriage-Return-characters/m-p/1730371#M592957 <P>I believe what you seek is in the following Help link:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptSpecifiers/no-eof.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptSpecifiers/no-eof.htm</A></P><P>Regards,<BR />Brett</P> Thu, 23 Jul 2020 16:39:37 GMT https://community.qlik.com/t5/QlikView/CSV-Import-with-Carriage-Return-characters/m-p/1730371#M592957 Brett_Bleess 2020-07-23T16:39:37Z