search cancel

Delimited File Generation is not adding empty values in the trailer

book

Article ID: 215270

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

      We are facing issue with delimited file generation through datamaker when the last fields are optional/blank.

Data Maker is not putting/adding the delimiter when there is no data for the columns at the end it is not just for one last column if there are last 10 columns which are blank then for those columns delimiter is not created.

Environment

Release : 4.8

Component : CA Agile Requirements Designer - TMX Script Generator

Resolution

To add empty delimiter values in datamaker, add TRAILING_DELIMITERS=Y to the definition file like below:

     Use below definition file as a sample and re-register the delimited file.

HEADER=Y,TRAILER=Y,DELIM=|,SIZES=Y,LINE_SEPARATOR=<CR><LF>,LINE_TERMINATOR=<EMPTY>,OUTPUT_FILE_MASK=BLANK_TEST,OUTEXT=TXT,TRAILING_DELIMITERS=Y
FIRST_NAME,20
LAST_NAME,20
AGE,10
GENDER,1