Convert characters

Hi.

I've tried to make this somehow but I can't seem to make all work. Here's
the story. I want to convert all c, s, z to c, s, z. I've managed to make
this with formula

REPLACE([Column_name], SEARCH("c",[Column_name]),1,"c")

But this works only for ONE character. Probably I can repeat it for others
s, z. But what if there are more same characters in one word?

For example cc would be converted only to cc. But i'd need it translated to
cc.

Can anybody help me?

Thanks
Boris

englantilainen
Sat Sep 25 11:09:10 CDT 2004

I've just re-read your question and I'm not really surprised nobody has tried
to answer it.

Here are a couple of extracts from it

> I want to convert all c, s, z to c, s, z [??]

> cc would be converted only to cc [??]
> But i'd need it translated to cc [??]

Maybe you'd like to re-phrase it !

Mike Walsh Helsinki Finland

"Boris Gomiunik" wrote:

> Hi.
>
> I've tried to make this somehow but I can't seem to make all work. Here's
> the story. I want to convert all c, s, z to c, s, z. I've managed to make
> this with formula
>
> REPLACE([Column_name], SEARCH("c",[Column_name]),1,"c")
>
> But this works only for ONE character. Probably I can repeat it for others
> s, z. But what if there are more same characters in one word?
>
> For example cc would be converted only to cc. But i'd need it translated to
> cc.
>
> Can anybody help me?
>
> Thanks
> Boris
>
>
>

Boris
Mon Sep 27 01:29:53 CDT 2004

Sorry. I meant c to è, s to ¹ and and z to ¾. So èè is converted to cè, ¹¹
to s¹ and ¾¾ to z¾.

"Mike Walsh" <englantilainen@hotmail.com> je napisal v sporoèilo
news:570BC236-B4B8-4888-976E-5BFC29BC1232@microsoft.com ...
> I've just re-read your question and I'm not really surprised nobody has
> tried
> to answer it.
>
> Here are a couple of extracts from it
>
>> I want to convert all c, s, z to c, s, z [??]
>
>> cc would be converted only to cc [??]
>> But i'd need it translated to cc [??]
>
> Maybe you'd like to re-phrase it !
>
> Mike Walsh Helsinki Finland
>
> "Boris Gomiunik" wrote:
>
>> Hi.
>>
>> I've tried to make this somehow but I can't seem to make all work. Here's
>> the story. I want to convert all c, s, z to c, s, z. I've managed to make
>> this with formula
>>
>> REPLACE([Column_name], SEARCH("c",[Column_name]),1,"c")
>>
>> But this works only for ONE character. Probably I can repeat it for
>> others
>> s, z. But what if there are more same characters in one word?
>>
>> For example cc would be converted only to cc. But i'd need it translated
>> to
>> cc.
>>
>> Can anybody help me?
>>
>> Thanks
>> Boris
>>
>>
>>