Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
This break was caused by a special character and was fixed with the following:
,KeepChar(Description,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as Description
This break was caused by a special character and was fixed with the following:
,KeepChar(Description,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as Description
Export file to CSV: Unexpected row break