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
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