TRIM Function In a Query - Is It Possible

D

Dave Gibson

Hi,

Would anyone please be able to advise me if their is some form of TRIM
function available for use in the query grid. I wish to delete leading
and trailing spaces and non printable characters etc that are in a
dataset that I have.

I have a table called "T_StudBookData" which contains a field called
"Dam" that contains the data that I wish to carry out the TRIM on.

The table comes from over 50 separate external files that are updated
regularly so I really need to be able to carry out the operation in
one pass on the consolidated data set.

I run a small macro to import all the data so a small VBA module that
would do the job could be placed in my macro if that is an option.

Unfortunately, I do not have the skill to write VBA code to a module.
If anyone could help wiyth the issue I would be most grateful.

Best Regards
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
Macro warning in word 1
Duplicate pst, or is it? 1
Word VBA - Delete text from bulleted paragraphs 1
Is this possible? 0
Change a great number of words in word files, with a macro as short as possible. 5
Is it possible to edit colours already saved as part of a custom theme? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top