how to remove certain chracter from string

[cancer2006]

using CRW8.5 and access97

I like to know if there is a function that will remove hyphen(-) from social security numbers. Thanks.

 

[dgillz]

The Replace() function will do this. Look at the help files for full context on how to use this function.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[bdreed35]

Here is an example of the syntax you shoud use for your formula:

Replace({table.ssn},"-","")

~Brian

 

[cancer2006]

I solved that problem by the following code.
Thanks,

stringvar ssnumber;
ssnumber := Left({EInfo.ssn},3) + Mid( {EInfo.ssn},5,2) + Right({EInfo.ssn},4) ;

 

[dgillz]

Why use the variable? It is not needed.

Dbreed's formula is perfect.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[synapsevampire]

Either solution works, howeverdgillz appropriately points out that you do NOT need a variable.

I think that the replace if the most elegant.

However since you enjoy alternatives, you might also use:

join(split({table.field},"-"),"")

-k