Page 1 of 1
I want to stripout the '-'
Posted: Tue Apr 27, 2010 4:16 am
by pavankatra
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
Posted: Tue Apr 27, 2010 4:56 am
by ray.wurlod
Convert()
Posted: Tue Apr 27, 2010 5:02 am
by pavankatra
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
Posted: Tue Apr 27, 2010 5:11 am
by nani0907
hello .that correct.you are converting it to space .trim it also
Posted: Tue Apr 27, 2010 5:23 am
by pavankatra
nani0907 wrote:hello .that correct.you are converting it to space .trim it also
yes
that is working,Thanks RAY
Thanks
Pavan
Posted: Tue Apr 27, 2010 5:34 am
by chulett
Or just convert it to an empty string rather than a space, save the whole 'trim' part.
Posted: Wed Apr 28, 2010 9:39 am
by pavankatra
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
Posted: Wed Apr 28, 2010 4:58 pm
by ray.wurlod
Code: Select all
Convert("-", "", InLink.ColumnName)
was all you needed.
Posted: Wed Apr 28, 2010 5:16 pm
by chulett
Exactly.