Tilde ~ Delimiter on Import

[stack]

Does anyone know what the format of the Import statement is when the delimiter is a tilde ~ ?

The syntax is wrong with Import Delimiter "~". I had to change it to ""~"" to get it to run and even then the output file isn't correct.

Thanks.

 

[Chris Kelleher]

Use IMPORT DELIMITER "~~" to specify one tilde character as the delimiter.

 

[stack]

Thank You, Thank You, Thank You!!!

:blush:
Is that documented anywhere? I can never seem to find more than just basic documentation for Progress 4GL.

 

[Chris Kelleher]

Sure, here you go: http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=127&docType=1006&contextId=11888%3A127.196&clusterName=CombinedCluster&contentId=742bd4b5-3ee2-46b7-9017-7c1f7e7ec96c&responseId=4f2e6f6f8c3365a4%3A1b1fbf4%3A1069dc9b333%3A-48fd&groupId=3&answerGroup=4&score=930&page=http%3A%2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FESERVER_P27229.xhtml&result=9&excerpt=How+to+escape+the+tilde+%27%7E%27+and+other+special+characters+in+Progress%3F&resultType=5002#Goto127

This is also in the online help file and the language reference manual.

 

[Lee Curzon]

Link doesn't work.

Try http://tinyurl.com/93tpc
ID: P27229
Title: "How to escape the tilde '~' and other special characters in Progress?"


Chris: you may have more success finding by Solution ID, and linking to that.

Lee