Ignore comma (,) or or dot (.) in formula 1

[Jeffcis]

Hi,

One of the column in my datasource has some commas or dot which is happen to be the product name.

For example, the below are product names with comma and dot
WALLGARD 1,3
WALLGARD 2.0

My particular string formula for product name is shown below.
if {@subtotal} > 0
then {Sheet1_.Description} else ""

My question is, how can I mend the above formula to ignore any comma or dot (.) from the product name field.

appreciate any help.
Jeffcis

 

[chelseatech]

Use a replace string function
Replace(Replace({Sheet1_.Description},".",""),",","")

Need it twice. The outer one gets rid of the commas and the inner one does the periods.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm