Sequenctial File - Delimited file - NO QUOTE CHARACTER

murur · Post by **murur** » Thu Apr 22, 2004 1:49 pm

I have to generate a output file in CSV format and String MUST NOT be enlcosed by Quotes. In a Sequential File Stage --> Fromat Tab -->Quote character is expecting a character, I couldn't proceed without a value in Quate character.

Any help....

chulett · Post by **chulett** » Thu Apr 22, 2004 1:56 pm

If you try to leave it blank, it will explain what you need to do if you want no quote characters - use "000" (three zeroes).

ray.wurlod · Post by **ray.wurlod** » Thu Apr 22, 2004 4:10 pm

In both the quote character and delimiter character fields you can use the three digit decimal ASCII code value of the required character.

For example, to use Tab as the delimiter, specify 009.

If NLS is enabled you can also use the four digit hexadecimal Unicode code value of the required character. For example, to use Esc as the delimiter, specify 001B.