SET INPUT FORMAT

SET INPUT FORMAT

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

SET INPUT FORMAT

Establishes the format for data input.

Syntax

SET INPUT FORMAT NORMAL|COMMADELIMITED

Comments

The INPUT FORMAT option is NORMAL by default.

Normally, the ADD and CHANGE commands look for input whose format is a simple data stream, separated by delimiter characters. SET INPUT FORMAT enables these commands to read data in “comma delimited” format from unstructured application documents.

When using the comma-delimited format, data base fields are separated from one another by the delimiter character. This is normally a comma, but it can be changed using the SET DELIMITER command. Character-type fields have trailing blanks removed and are enclosed by the text delimiter. This is normally double quotation marks, but can be changed using the SET TEXTDELIMITER command. Numeric fields have leading blanks removed.

Fields that match the current NULLVALUE string (without text delimiters) are evaluated as $Null. Fields comprising of two text delimiters are evaluated as $Null or zero, depending on the field being assigned.

Example

set save
set input format commadelimited
set nullvalue “$null”
add Customers from UnstructuredDoc
set restore

See Also

ADD

SET DELIMITER

SET NULLVALUE

SET OUTPUT FORMAT

SET TEXTDELIMITER

Was this article helpful?
5 out of 5 stars

1 rating

5 Stars 100%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish