mrafs Posted May 9, 2004 Share Posted May 9, 2004 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 Link to comment Share on other sites More sharing options...
The Shadow Posted May 10, 2004 Share Posted May 10, 2004 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. Link to comment Share on other sites More sharing options...
mrafs Posted May 14, 2004 Author Share Posted May 14, 2004 thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7141 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now