Formatting fields

[Yoshitake]

I'm trying to format my database table fields to fill my
fixed width fields file correctly, but I have no clue
about the formatting masks available.

[Frank]

Could you tell me what is formatting masks?

When creating a Text Structure, you select a fix field or character delimited document. By choosing fix field document, you can specify field width for each field. Furthermore, you can set the format for any field. Except for the DateTime data element, the format of the field is taken from C++. For DateTime format you can find the specification in the help text for user function CVTDate().

Frank

[Yoshitake]

Could you tell me what is formatting masks?
Frank

Hi, Frank!
Formatting masks are the symbols used within the famous printf
function.
Recently, Java supports it also, so I expect the "Format" column in the
"Text instructions" to be like that.
Am I wrong?
What masks are supported?

[Frank]

You are right. The format is the same as it is used in printf function. For writing target we just pass the format to the sprintf function, thus whatever the printf support it should be ok. In addition to the format used in strftime function, the DateTime data element also use some intuitive format as specified in the CVTDate help text.

Frank

[Yoshitake]

Thank you, Frank!