Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parse a string to remove each instance of more than 1 space??
Getting a bit too in-depth for my lack of knowledge. Hugh, your Instr example works just as well as fstrahberger's, the speed of running both routines is unnoticable, on the plus side I dont need to reference 'VBScript Regular Expressions 1.0' which will be usefull, as I will be putting this...- robduck
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Parse a string to remove each instance of more than 1 space??
Thats brilliant, didnt realise you could incorporate vbscript into it, your a star. Thanks- robduck
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Parse a string to remove each instance of more than 1 space??
Im new to VBA in Outlook, can't say its the nicest language. Ok, what im trying to do - if possible, is create a tilde delimited file, for each instance of more than 1 space I need to remove it: BEFORE: USD United States Dollars 0.5244310047 1.9068285264 EUR Euro...- robduck
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
