string function

suresh_dsx · Post by **suresh_dsx** » Sat May 27, 2006 12:27 am

hey guys

i have job seqfile-> tranformer stage ->target

source data

"----John---"
"----paul----"

output is

John
paul

i created a routine for that and i used in tranformer stage.i am getting the result.
but i want a single function to get the output in transformer stage.(i dont want to use routine )
thank you

ray.wurlod · Post by **ray.wurlod** » Sat May 27, 2006 1:16 am

Trim() function is the one you want. Specify the "-" character as the second argument of Trim(), and the third argument is a single character code specifying from where you want them removed. You can learn all the options by reviewing on-line help or from the DataStage BASIC manual.

A second possibility, if you want to discard all "-" characters, is to use the Convert() function to convert them all to "".

Others are likely to suggest the Ereplace() function, but this is not as efficient as Convert() when performing individual character conversion.

chulett · Post by **chulett** » Sat May 27, 2006 7:28 am

Those cwazy Others, whadda they know?

ray.wurlod · Post by **ray.wurlod** » Sat May 27, 2006 3:54 pm

Code: Select all

Convert("s","z",Ereplace(Ereplace(Ereplace("Those cwazy Others, whadda they know?","Th","D",-1,0),"th","dd",1,1),"th","d",1,1))

DSguru2B · Post by **DSguru2B** » Sat May 27, 2006 5:14 pm

Both of you guys are funny. Actually, hilarious