Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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