Substitute

[Vegard]

How can I use the substitute command to add a space after a "." or a "," to every occurence in a text field, but only if the space is not already there.

I`ve tried the following:

Substitute(field name; ".*" ; ". ")

Very thankful for any help

Vegard

[jhesketh]

Just a thought...

replace(field name, ".", ". ")

followed by

replace(field name, ". ", ". ")

This puts a space in regardless, then reduces any double spaces to singles.

Jeff Hesketh

quote:

---

Originally posted by Vegard:

How can I use the substitute command to add a space after a "." or a "," to every occurence in a text field, but only if the space is not already there.

I`ve tried the following:

Substitute(field name; ".*" ; ". ")

Very thankful for any help

Vegard

---