Lat new line

[denzilsyb]

Hallo all

Is there a way to omit the last new line character in the constraint of a transformer? I dont want to have to revert to scripts and/or SEQ stages to do this.

I have tried LINK.COL > 0 and LINK.COL <> @NULL, but no luck.

[ogmios]

Hallo all

Is there a way to omit the last new line character in the constraint of a transformer? I dont want to have to revert to scripts and/or SEQ stages to do this.

I have tried LINK.COL > 0 and LINK.COL <> @NULL, but no luck.

What do you mean with "last new line character in the constraint of transformer". The newlines in an outputfile are generated by the sequential stage.

Ogmios

[denzilsyb]

Hi ogmios

yes, the new line is generated in the SEQ stage, but i have an extra "line" of "data" after all my detail records are listed. i.e.

Code: Select all

col1|col2|col3|CR/LF
dat1|dat2|dat3|[color=red]CR/LF[/color]
<this is an extra record with nothing in, not even NULL>

i want to omit the CR/LF in red above. (ok, not red, but CR/LF)

[ogmios]

In a sequential stage generating a file you have the option "Omit last new-line" on the inputs/format tab (left lower side of the tab).

I guess you need that one.

Ogmios

[denzilsyb]

I was afaid of that. now i just need to go back and insert the stage to the job. thanks ogmios.