not filterValues

[mrafs]

I'm trying to figure out how to do the opposite of filter without several combined calculations.

-need to remove some text from a global field

(i.e. 23x 35x 83x (-35x) = 23x 83x)

- the text I want to remove is a field on a current record.

- its for marking/unmarking records

tia

[The Shadow]

You could add a space at the front of the field, so each item looks the same, then use substitute:

Substitute( " " & Field; [" " & ToRemove; "" ] )

but that leaves an extra space at the front, if that bothers you, use:

Let( newText = Substitute( " " & Field; [" " & ToRemove; "" ] ); Right( newText; Length(newText)-1 ) )

to eliminate that leading space also.

[mrafs]

thanks