Output to Tab delimited flat file

[Frosty the Coder]

I've been asked to change a flat file, currently being generated as a CSV, to tab delimited.

The existing code builds this file by concatenating all columns, with a comma, into a string variable.

My first thought was to use BSFN B01B0155 Pad String with Hex Characters.
This is undocumented and didn't work with the way I tried.

My next thought is to create a character variable (VA rpt_cAA01_Tab_as_Hex) and concat that within the string.

I read in an older JDEList post that '05' is hex for TAB.
Is this correct?

How would I set my cAA01 to a hex value?

Is there a 'best practice' for producing tab delimited?

Please/Thanks

E900, MS SQL server

 

[JMR]

I'd shy away from trying to hardcode a hex value as that could prove unreliable on different systems.

My suggestion: insert a tab character into any editor (can you say Notepad?). Copy that character to the clipboard and then paste it into right side of the variable Assignment expression for your delimiter variable.

 

[Frosty the Coder]

Jeremy,

Thank you!
I believe I used that approach before, but had forgotten it!

 

[jiju]

Is that a table conversion or some report output?

 

[Adrian_Chimirel]

[ QUOTE ]
The existing code builds this file by concatenating all columns, with a comma, into a string variable.

[/ QUOTE ]
No table conversion involved here, jiju. Just a flat file created by an ordinary UBE.

 

[Larry_Jones]

FYI hex 09 is the tab character