How to avoid line wrap if the column data contains return code after execute EXPORT command and output to CSV data file? (DBMR: 2126)?

~ 0 min
2016-03-09 11:05

There is incorrect handling result output to CSV file if the column data which contains return code when execute “Export command”; i.e Table has only one record but more than one records judged by DBMaker if the record include return code. We can get expected output result by setting the parameters in description file.

For example:

This is the previous description file.

FORMAT=VARIABLE

COLUMN_DELIMITER=','

ROW_TERMINATOR="\n"

QUOTATION=SINGLE_QUOTE

NUMBER_OF_ROWS_FOR_EACH_TRANSACTION=-1

After execute “Export into testtb.csv table testtb description desc.txt;” command with above description file, Incorrect line wrap displayed in CSV file.

We can modify the original contents as following in description file to ensure output result correct and do not automatically new lines.

The modified description file.

FORMAT=VARIABLE

COLUMN_DELIMITER=','

ROW_TERMINATOR="\r\n"

QUOTATION=DOUBLE_QUOTE

NUMBER_OF_ROWS_FOR_EACH_TRANSACTION=-1

Version: DBMaker5.x, DBMaker4.2, DBMaker5.x

Product: Normal

Platform: Window xp

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags