View Single Post
 
Old 03-06-2013, 02:34 PM
dmarie123 dmarie123 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Dec 2012
Location: New Yuk
Posts: 23
dmarie123 is on a distinguished road
Default

Hi Paul,

I apologize for not responding sooner. I was snowed in with the rest of the Midwest.

As far as the numbers, I want to match the format of the text that is found so if it
finds a prefix with a colon then the found text and colon should stay as is. If it only finds the text then it should also stay as is. I don't want to add a colon.
From: To:
SSID: 123456789 >>> SSID: 12-3456789
The above will either have two spaces after the colon or it will appear w/in text:
SSID 123456789 >>> SSID 12-3456789

The other number will also appear after the text, a colon, and two spaces:
SID2: 1234567891 >>> SID2: 1234567891 (Approved: )

That's why I did the numbers that way. I wasn't aware yours caught both. If I add an extra space inside the brackets will it do both a colon and two spaces?? That would be cleaner code-wise.

Also, where do I put the code to format the text to Arial, size 11, left-justified?

Thank you Paul, I really appreciate you refining everything and teaching me in the process. Hopefully one of these days I'll be passing it on!

Donna
Reply With Quote