delete first character if it's a space.

[air0jmb]

I'm importing a large table from Excel and many records have a space preceding the first text character.

Please help with an expression to delete the first character in a text field if it's a space. And can I use this on a memo field?

Thanks!

Mike

 

[rjoubert]

Use the Trim function...

Trim([YourField])

 

[air0jmb]

Thanks, but I'm having trouble with the IIf part of the expression. Could you provide the complete expression?

Thanks!

Mike

 

[rjoubert]

There's no need for an IIF function...just use the Trim function. It will remove any leading (or trailing) spaces, if there are any. If there are no extra spaces, it won't change the value at all.

 

[air0jmb]

Now I feel silly.

Thanks!