JasonCannon
IS-IT--Management
I have just started working with records that have excess spaces within titles and names and I am trying to find the best way to "clean them up."
I cannot trim out all the spaces as I need them between the words.
Examples:
- "A AA Self Storage" should read "AAA Self Storage"
- "A A A Carolina" and "A AA Carolina" should read "AAA Carolina"
- "A A Al-Anon" should read "AA Al-Anon"
- "BB T Bank" should read "BBT Bank"
etc.
Trying to find a better way than to have a long CASE .. ENDCASE statement.
Any suggestions?
Thanks.
"..if you give a man a fish he is hungry again in an hour. If you teach him to catch a fish you do him a good turn."
-- Anne Isabella Thackeray Ritchie.
I cannot trim out all the spaces as I need them between the words.
Examples:
- "A AA Self Storage" should read "AAA Self Storage"
- "A A A Carolina" and "A AA Carolina" should read "AAA Carolina"
- "A A Al-Anon" should read "AA Al-Anon"
- "BB T Bank" should read "BBT Bank"
etc.
Trying to find a better way than to have a long CASE .. ENDCASE statement.
Any suggestions?
Thanks.
"..if you give a man a fish he is hungry again in an hour. If you teach him to catch a fish you do him a good turn."
-- Anne Isabella Thackeray Ritchie.