Strip Leading Spaces

[manu]

Apologies for bringing this up again!!

I could really use some help with "How to lose leading spaces in a string"

Thanks for all help

 

[mrabrams]

LTrim in Help files is what you are looking for.

 

[Rich_Lovina]

Your simple Find/Replace command when in tables will do this too, but her just hit your space bar as the 'thing' you want to find and in replace just hit replace. This works only if your string has only leading spaces. Test it and see...its very quick

 

[manu]

so I need to use LTRIM, would this be entered on the critera section of Query Grid?

An example would be helpful, given my field name is "Field10"

Regards,

 

[mrabrams]

Use an update query.

On the line that says Update To type the following:

LTrim([field10])

One click and your entire table has been trimmed.

 

[manu]

Many Many Thanks for bearing with me..

This was rather basic, but I guess on a Monday, my brain was just not there,

Regards,

 

[mrabrams]

Glad we could help.

Is it really only Monday?

:}}