Remove space at end of any text

[Madwolfie]

Hi

For some reason some of my fields in my 3000 odd records have spaces at the end of the data. The text in the field may or may not have spaces in it. How do I ONLY remove the space that is at the end - some of the fields will NOT have a space at the end of course. I tried manually but it is taking ages -) Any ideas gratefully received

[Lee Smith]

If there are spaces in your date fields, then the dates are not dates, but most likely text. You can use the Trim Function to remove spaces as you describe. Read in the help about Trim ( text ) and TrimAll ( text ; trimSpace ; trimType )

Lee

[Madwolfie]

Hi Lee

and thanks, but I think all those functions will remove the spaces between the words as well and my text sometimes has single characters with spaces either side. I just want to remove the end space IF there is one. It is just a plain text field.

[Madwolfie]

Hi

Well a bit of guessing and suck and see and it is done - thanks very much for the pointers - couldn't see the wood for the tress..Thanks

Colin