|
I just purchased SoftMaker Office 2010 a few days ago and I'm currently using it to create some mailing labels. While the label functionality seems fairly rudimentary, it will certainly get the job done. However, I noticed something I find odd when using a CSV file as the input database.
When TextMaker parses the fields from the CSV file, leading spaces in each field are kept instead of purged. This is very non-standard and complicates the creation of the CSV by making it much less readable.
So, it seems that TextMaker wants a CSV formatted as follows:
Name,Address,City,State,Zip
Tom Smith,123 My Town,TheTown,CA,12345
As opposed to the much more readable:
Name, Address, City, State, Zip
Tom Smith, 123 My Town, TheTown, CA, 12345
A typical CSV parser would ignore leading and trailing spaces within a CSV field. If the spaces are intended to be kept, the field should be enclosed with double quotes.
If I attempt to use the more readable form shown above, the parser ends up with these fields:
"Name"
" Address"
" City"
" State"
" Zip"
So, adding a format specifier like {Address} to the label will not match the above (which needs to be { Address}, and the field is skipped.
Can the CSV parser be improved to work according to the CSV spec?
Jeff
|
Login
Register
FAQ
Search
