topic Re: Export file as CSV in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960572#M11141 <P>Export file to CSV: Unexpected row break&nbsp;</P> Tue, 26 Jul 2022 13:37:22 GMT Marius_ 2022-07-26T13:37:22Z Export file as CSV https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960564#M11139 <P>I execute a normal Store file to csv.</P> <P>The file that is generated force an unexpected rowbreak:</P> <P>Any idea why?</P> <TABLE width="1152"> <TBODY> <TR> <TD width="64">Site</TD> <TD width="64">Plant Name</TD> <TD width="64">Posting Date</TD> <TD width="64">Weekday</TD> <TD width="64">EmployeeNo</TD> <TD width="64">PG</TD> <TD width="64">JobDescriptionGeneric</TD> <TD width="64">NameSurname</TD> <TD width="64">Description</TD> <TD width="64">Oggend</TD> <TD width="64">MEte</TD> <TD width="64">Afternoon</TD> <TD width="64">Naweek</TD> <TD width="64">In Eerste</TD> <TD width="64">Uit Laaste</TD> <TD width="64">Weegtyd</TD> <TD width="64">TotalHours</TD> <TD width="64">Soort</TD> </TR> <TR> <TD>G24</TD> <TD>Buc Silo</TD> <TD>########</TD> <TD>Thu</TD> <TD>40114</TD> <TD>3</TD> <TD>Loco Operator</TD> <TD>Simon M</TD> <TD colspan="2">Ontvangstes</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD colspan="7"><STRONG>,0,0,1,0,0.29927083333333,0.74825231481481,2.7755555555556,1.00,1</STRONG></TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>G24</TD> <TD>Buc</TD> <TD>########</TD> <TD>Thu</TD> <TD>23940</TD> <TD>4</TD> <TD>Control Board Operator</TD> <TD>Jacob M</TD> <TD>Ete nie gevat nie</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>0</TD> <TD>0.299271</TD> <TD>0.748252</TD> <TD>2.775556</TD> <TD>1</TD> <TD>1</TD> </TR> </TBODY> </TABLE> Tue, 26 Jul 2022 13:27:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960564#M11139 Marius_ 2022-07-26T13:27:56Z Re: Export file as CSV https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960567#M11140 <P>This break was caused by a special character and was fixed with the following:</P> <P>,KeepChar(Description,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as Description</P> Tue, 26 Jul 2022 13:30:48 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960567#M11140 Marius_ 2022-07-26T13:30:48Z Re: Export file as CSV https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960572#M11141 <P>Export file to CSV: Unexpected row break&nbsp;</P> Tue, 26 Jul 2022 13:37:22 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Export-file-as-CSV/m-p/1960572#M11141 Marius_ 2022-07-26T13:37:22Z