csv export delimiting
Hi all
I'm using a single master band with no header or footer.
I have 3 memo fields, fitted right next to each other. (all fkText)
Print and view is fine.
When I export to csv it works fine if all the memos contain data
I any of these memos are blank/NULL, the export component uses a semi column ';' as the delimiter instead of the specified comma ','. But if the memos contain data then it correctly uses the comma
Using version 4.9 for C++
I'd like the data to be consistent and be delimited with the comma no matter if the field is empty or not.
Thank you
Mark
I'm using a single master band with no header or footer.
I have 3 memo fields, fitted right next to each other. (all fkText)
Print and view is fine.
When I export to csv it works fine if all the memos contain data
I any of these memos are blank/NULL, the export component uses a semi column ';' as the delimiter instead of the specified comma ','. But if the memos contain data then it correctly uses the comma
Using version 4.9 for C++
I'd like the data to be consistent and be delimited with the comma no matter if the field is empty or not.
Thank you
Mark
Comments
A memo with a single space will delimit with the specified comma. A memo without (NULL) delimits with a semi column.
Could I have some confirmation on this please?
CSV does stand for COMMA Separated Values.
I've now upgraded to v4.10 and the problem appears to have been rectified although I can find no mention of it in the release notes.