Kbase P28170: Is is possible to import text with embedded quotes?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/27/2003 |
|
Status: Unverified
GOAL:
Is is possible to import text with embedded quotes?
FIX:
Progress expects character text to be enclosed in quotes, so if you have embedded quotes then there are two options available to you.
1. If you have embedded quotes within the text, then replace these with double quotes. (i.e. if the text string is "1"7", this becomes "1""7".
2. The other option is to use the UNFORMATTED option and manipulate the whole string from within 4GL.
Probably the first suggestion is the easiest method, which should be possible with Search and Replace in an editor, if the file is not too big. Otherwise method 2 may have to be used.