Format the fields in a flatfile

Former Member — Thu, 20 Sep 2007 07:31:59 GMT

Hi all,

I have a flatfile which has 7 fields which I need to format.

The requirement is for every row in the flatfile, I have to check

FOR EVERY ROW in <flatfile>

IF NUMERIC Field

Right-justify field value & Pad with leading zeroes to the LEFT.

WRITE FIELD to <flatfile>

ELSE IF ALPHANUMERIC FIELD

Left-justify field value and Pad leading spaces to the RIGHT.

WRITE FIELD to <flatfile>

ENDIF

Please help me with the sample code.

Thanks and regards,

Anishur

Re: Format the fields in a flatfile

Jelena_Perfiljeva — Thu, 20 Sep 2007 18:28:56 GMT

I hope you don't need a code sample for how to read a file...

For "number / not number" validation and right-justify you can find a sample here:

"Left-justify" - use SHIFT LEFT DELETING LEADING space.

Hope this helps.