0

I have a requirement to add a tab between two words. Can someone point me to a function that will accomplish this goal?

Input: Word1 Word2
output: word1 <inserted tab> word2

Thanks in advance for any help.

tbtcust
  • 65
  • 6

2 Answers2

1
inLink.Word1 : Char(9) : inLink.Word2

I'd recommend pre-loading the value as the initial value of a stage variable, let's call it svTab, so the function only needs to be evaluated once.

inLink.Word1 : svTab : inLink.Word2
Ray Wurlod
  • 831
  • 1
  • 4
  • 3
-1

Don't know datastage but did you try \t ? Apparently it works for some other functions like delim

Big_Boulard
  • 799
  • 1
  • 13
  • 28
  • 2
    stumbled upon a post that suggested simply concatenate char(9) in the transformer word1:char(9):word2. This worked. – tbtcust Aug 12 '22 at 12:48