DSXchange

Hi all,
could you please suggest how to add a Tab Space between two strings in transformer.

eg. A="ABC"
and B="XYZ"

I need output as "ABC <\t> XYZ"

Thanks in advance

Regards,
Satish

Found the solution

"string1" : Char(9) : "string2"


Char(9) is a conversion function.

Cheers!!

Satish,

try -> "ABC" : CHAR(09) : "XYZ"

sorry.. i was slow...

Performance tip:

Initialize a stage variable (let's call it svTab) to Char(9). Do not provide a per-row derivation for this stage variable. Use svTab rather than Char(9) in your expressions.

This way the Char(9) function is evaluated only once for the job, rather than once per row.

Char() and Seq() functions are quite expensive, because they have to perform a lookup into the terminfo database.