Jukkie Posted April 19, 2004 Share Posted April 19, 2004 Hello, I have a field called "a". In field "b" I want to delete the spaces and points that are field in field "a" I use: Substitute(a;" ";"") The spaces are now gone, but how can I delete in the same formula the points? Greetings Jukkie FileMaker Version: 6 Platform: Windows XP Link to comment Share on other sites More sharing options...
Lee Smith Posted April 19, 2004 Share Posted April 19, 2004 Assuming by points you meant periods ".", than this should do it. Substitute(Substitute(a, " ", '''), "..", "") If not, than replace my .. with what ever you mean. Lee Link to comment Share on other sites More sharing options...
Jukkie Posted April 20, 2004 Author Share Posted April 20, 2004 Hello Lee, Yes I did mean periods instead of points! and the formula works for me -) Thanks Jukkie Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7312 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