This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
integration:rawdata:delimited:options [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:delimited:options [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 3: | Line 3: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Adminstration: Raw Data Files ====== | + | ====== Integration: Raw Data Files ====== |
===== Delimited Files ===== | ===== Delimited Files ===== | ||
Line 79: | Line 79: | ||
ESCAPE='c' | ESCAPE='c' | ||
- | As an alternative to quoting, delimited files may use an escape character to indicate that the subsequent character should not be considered a delimiter, but rather is part of the data. Rather than quoting the data, an escape character precedes every occurrence of the delimiter in the data itself. (Ironically, if the escape character itself exists in the data, then it too must be escaped using its own character.) Escaping may be turned off using the OFF setting. In this example, the default escape character of \ is used prevent commas, apostrophes and quotes from being considered delimiters: | + | As an alternative to quoting, delimited files may use an escape character to indicate that the subsequent character should not be considered a delimiter, but rather is part of the data. Rather than quoting the data, an escape character precedes every occurrence of the delimiter in the data itself. (Ironically, if the escape character itself exists in the data, then it too must be escaped using its own character.) Escaping may be turned off using the OFF setting. In this example, the default escape character of \ is used to prevent commas, apostrophes, and quotes from being considered delimiters: |
^Column\\ Datatype ^ID\\ INTEGER ^COMPANY\\ STRING(31) ^ | ^Column\\ Datatype ^ID\\ INTEGER ^COMPANY\\ STRING(31) ^ |