udaybhaskameka

 Profile Answers by udaybhaskameka 

• Oct 7th, 2010

 

By using char function.

nikhilanshuman

 Profile Answers by nikhilanshuman 

• Dec 9th, 2010

 

Hi,
Use following function in derivation of the transformer:

convert("123456789","         ",StringName)

Please note that the second argument contains nine spaces.Here,StringName is the string for which the numerical values are to be removed.

Hence,if your string's value is "Test1234"(StringName),it will be converted to "Test".In this way,only character data will be loaded to the target.

Nikhil Anshuman

soum

• Oct 3rd, 2011

 

Hi,

Use following function in derivation of the transformer:

convert("123456789","",StringName)
T12e5st --> Test (desired rlt)esu


convert("123456789"," ",StringName)
T12e5st --> T e st (space will appear in place of digits)

Thanks,
Soum

Guru

• Oct 25th, 2011

 

we have so many ways to resolve it.In transformer take two links . for one link you use Num() .for ur target link enable otherwise condition.

rakesh.u45

 Profile Answers by rakesh.u45 Questions by rakesh.u45

• May 18th, 2012

 

take 2 output links in transformer stage for one target set
in constraint: num()=0 and in another target
set num()<>0
then in target 1 youll get all numeric values in target youll get all characters.....
try this i hope you understand

datastg

• Jun 27th, 2012

 

Can use the below func Convert("0123456789","",YourString)

Vijay

• Sep 1st, 2012

 

Use Isnum() function in Transformer stage it picks only numeric values.

Vinay Sharma

• Oct 4th, 2012

 

use alpha function.
Exp-->alpha(123vinay567)
Ans-->vinay

i thing this is your requeriment..

raj

• Nov 8th, 2012

 

Example : raje123ndh456ar

Code
convert(0123456789,,raje123ndh456ar) = rajendhar 

now it is converted to character string and we can load only character.