Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Marius_
Contributor III
Contributor III

Export file as CSV

I execute a normal Store file to csv.

The file that is generated force an unexpected rowbreak:

Any idea why?

Site Plant Name Posting Date Weekday EmployeeNo PG JobDescriptionGeneric NameSurname Description Oggend MEte Afternoon Naweek In Eerste Uit Laaste Weegtyd TotalHours Soort
G24 Buc Silo ######## Thu 40114 3 Loco Operator Simon M Ontvangstes                
,0,0,1,0,0.29927083333333,0.74825231481481,2.7755555555556,1.00,1                      
G24 Buc ######## Thu 23940 4 Control Board Operator Jacob M Ete nie gevat nie 0 1 0 0 0.299271 0.748252 2.775556 1 1
Labels (1)
1 Solution

Accepted Solutions
Marius_
Contributor III
Contributor III
Author

This break was caused by a special character and was fixed with the following:

,KeepChar(Description,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as Description

View solution in original post

2 Replies
Marius_
Contributor III
Contributor III
Author

This break was caused by a special character and was fixed with the following:

,KeepChar(Description,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as Description

Marius_
Contributor III
Contributor III
Author

Export file to CSV: Unexpected row break