topic help needed with fm download in Application Development and Automation Discussions

help needed with fm download

Former Member — Mon, 04 Dec 2006 17:34:04 GMT

Hi,

I AM ABLE TO DOWNLOAD THE TEXT FILE INTO TAB DELIMITED FILE.

BUT THE PROBLEM IS THAT I NEED THE TAB IMMEDIATELY AFTER THE VALUE.

SAY IF I HAVE A FIELD OF LENGTH 20 BUT THE VALUE IS ONLY 15 DIGITS

I NEED TAB IMMEDIATELY AFTER 15 DIGITS BUT WHAT MY CODE IS DOING IS

IT WRITES 15 DIGIT VALUE THEN LEAVE 5 DIGIT BLANK SPACE AND THEN GIVES TAB

FLD1 IS LENGTH 10

FLD2 IS LENGTH 8

THIS IS WHAT I AM GETTING

FLD1 FLD2

1234567899 TEST

9 TESTF

I NEED SOMETHING LIKE THIS

12345678 TEST

1 TESTF

Thanks

Former Member — Mon, 04 Dec 2006 17:42:21 GMT

U need to define your internal table with character fields and you can use the below option.

Set the below parameter as X

TRUNC_TRAILING_BLANK - 'X': Blanks are removed.

ferry_lianto — Mon, 04 Dec 2006 17:50:27 GMT

Hi,

Please try to set parameter WRITE_FIELD_SEPARATOR = 'X' in FM GUI_DOWNLOAD.

Regards,

Ferry Lianto