cAN DATA IN A TABLE BE "TRIMMED" FROM THE RIGHT OR LEFT?

[dunnjt]

Data in a field in a table has some "excess" characters. The characters are not identical in each field but the "excess" characters are preceded by a pound sign. Can I ask Access to trim away all those unwanted characters after the pound sign? How?
I am not a code writer but I think there might be a function, macro or property that will accomplish this task. However, I am having no success finding a solution.
Thanks for any suggesttions
Have a pleasant Thursday,
Jerry D.

 

[alvechurchdata]

Use the Instr() function to find the position of the £ sign then the Left() function to get the characters before it:

strTest = "abcd£efg"
lngPos = InStr(strTest, "£")
strTrim = Left$(strTest, lngPos - 1)

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[HarleyQuinn]

If you are using code rather than the query window then I would use the Split() function.

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.