Kbase P4832: Text field That Contains a Comma is Being Split When Exported
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/12/2009 |
|
Status: Verified
SYMPTOM(s):
Character field is being split when exported and imported.
Character field contains a comma
Character field is imported as two fields.
FACT(s) (Environment):
Progress/OpenEdge Product Family
All Supported Operating Systems
CAUSE:
When importing the file, the comma that was in the text field will be seen as delimiter character, so the field will actually be treated as two fields.
FIX:
Two ways to avoid this:
- Use a delimiter other than comma
- Make sure any exported character values are in quotes so the program importing it will see it is in fact a single string and ignore any commas in it. Note that when using the 4GL EXPORT statement this is done automatically. This assumes the importing programs will handle the quoted strings correctly. The 4GL IMPORT statement does this, as do most other applications that support comma-separated (or other delimiter-seperated) input files.