I want to stripout the '-'

pavankatra · Post by **pavankatra** » Tue Apr 27, 2010 4:16 am

Hi,
I want to stripout the '-' from the string,so could anyone please suggest me which function is more helpful.

Thanks in Advance

Thanks
Pavan Kumar

ray.wurlod · Post by **ray.wurlod** » Tue Apr 27, 2010 4:56 am

Convert()

pavankatra · Post by **pavankatra** » Tue Apr 27, 2010 5:02 am

ray.wurlod wrote:Convert() ...

hi ray,
i have used convert function like
convert('-',' ',inputlinkname)

can you please let me know whether it is right or not.

THanks
Pavan Kumar

nani0907 · Post by **nani0907** » Tue Apr 27, 2010 5:11 am

hello .that correct.you are converting it to space .trim it also

pavankatra · Post by **pavankatra** » Tue Apr 27, 2010 5:23 am

nani0907 wrote:hello .that correct.you are converting it to space .trim it also

yes
that is working,Thanks RAY
Thanks
Pavan

chulett · Post by **chulett** » Tue Apr 27, 2010 5:34 am

Or just convert it to an empty string rather than a space, save the whole 'trim' part.

pavankatra · Post by **pavankatra** » Wed Apr 28, 2010 9:39 am

chulett wrote:Or just convert it to an empty string rather than a space, save the whole 'trim' part. ...

yes it is resolved.
my input is 12345-3-2
expected output is:1234532

for this i used StripWhiteSpace(convert(columnname,'-',' ')).

Thanks
Pavan Kumar

ray.wurlod · Post by **ray.wurlod** » Wed Apr 28, 2010 4:58 pm

Code: Select all

Convert("-", "", InLink.ColumnName)

was all you needed.

chulett · Post by **chulett** » Wed Apr 28, 2010 5:16 pm

Exactly.