Fun. I did one in C# and I had the hands using chimney sweeps because I had a Mary Poppins theme.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, May 30, 2018 8:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Retain only the letters and numbers in a string
agree. very nice, Graham.
I'll be interested in those results too!
btw, I just finished making a clock with hands that move in Access. So happy! Angles work, translating coordinates works. Now to wrap it up with a pretty bow :)
have an awesome day,
crystal
On 5/29/18 4:10 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:
> Thanks Graham for the beautiful explanation.
>
>
>
> Respectfully,
>
> [RCEmailSigLogo]
>
> Liz Ravenwood
>
> Data Technologies
>
> Interior Systems
>
> Rockwell Collins
>
> 1851 So. Pantano Rd, Tucson, AZ 85710 USA
>
> (520) 239-4808
>
> Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
>
> rockwellcollins.com<http://www.rockwellcollins.com/>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com]
>
> Sent: Tuesday, May 29, 2018 1:01 PM
>
> To: MS_Access_Professionals@yahoogroups.com
>
> Subject: RE: [MS_AccessPros] Retain only the letters and numbers in a
> string
>
>
>
>
>
>
>
> Hi Liz
>
>
>
> The Replace() function will only replace a specified substring within the input string. It does not handle wildcards. As there is no way or predicting the order or arrangement of the "unwanted" characters in the string, you would need to call Replace() once for each potential character. There are only 62 "wanted" characters (0-9, A-Z, a-z) , so with 256 characters in the ANSI set you would need to call Replace() 194 times. If we're talking Unicode, then we're potentially into 10s of thousands!
>
>
>
> I've been meaning to test the two methods (Crystal's Like and my Case)
> to see if there is any significant difference in speed, but I've been
> a bit busy. I'll post the results here when I get around to it :)
>
>
>
> Warmly,
>
> Graham
>
>
>
> ---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
>
> Interesting. So what does this do that a replace() function doesn't do?
>
>
>
> Respectfully,
>
> [RCEmailSigLogo]
>
> Liz Ravenwood
>
> Data Technologies
>
> Interior Systems
>
> Rockwell Collins
>
> 1851 So. Pantano Rd, Tucson, AZ 85710 USA
>
> (520) 239-4808
>
> Liz_ravenwood@...<mailto:Liz_ravenwood@...><mailto:Liz_ravenwood@...<m
> ailto:Liz_ravenwood@...>>
>
> rockwellcollins.com<http://www.rockwellcollins.com/>
>
>
>
> From:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals
> @yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Profe
> ssionals@yahoogroups.com>]
>
> Sent: Sunday, May 27, 2018 11:02 AM
>
> To:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals
> @yahoogroups.com>
>
> Subject: Re: [MS_AccessPros] Retain only the letters and numbers in a
> string
>
>
>
>
>
>
>
> hi Steve,
>
>
>
> thanks for testing and reporting your results! [0-9A-Z] would make
> sense since the brackets are substitution for a single character, so
> Access would know that "9" is once character and "A" is a different
> character. Also, A=a, as you probably found out. I never thought about
> comma being interpreted as something to look for, and apparently,
> neither have others that have posted examples -- nice to know! If you
> put a comma in a bracketed expression, it is interpreted literally ...
> I knew that but just never thought about it for series of lists, so
> thank you
>
>
>
> have an awesome day,
>
> crystal
>
> On 5/26/18 10:16 AM, Steve thaw5 thaw5@...<mailto:thaw5@...><mailto:thaw5@....<mailto:thaw5@...>> [MS_Access_Professionals] wrote:
>
> Crystal,
>
>
>
> With further testing I find that commas are included in the return string. I changed the Like to [0-9 A-Z] and found the return string did not contain commas but did contain spaces. So I tried [0-9A-Z] and neither commas nor spaces are included in the return string -- just letters and numbers.
>
>
>
> Evidently the comma in the Like list is not considered by Access to be a delimiter, but, rather, a component of the Like list. Does that sound right to you?
>
>
>
> Steve
>
> On 5/25/2018 8:48 PM, crystal 8 strive4peace2008@...<mailto:strive4peace2008@...><mailto:strive4peace2008@...<mailto:strive4peace2008@...>> [MS_Access_Professionals] wrote:
>
>
>
>
>
> hi Steve,
>
>
>
> here is a function to return letters and digits:
>
>
>
> '~~~~~~~~~~~~~~~~~~~
>
> Function GetLettersDigits(psString As String) As String
>
> '180525 strive4peace
>
> 'PARAMETERS
>
> ' psString is the string with information to extract
>
> Dim sResult As String _
>
> , i As Integer _
>
> , sChar As String * 1
>
>
>
> sResult = ""
>
> 'loop through and only keep letters and digits
>
> For i = 1 To Len(psString)
>
> sChar = Mid(psString, i, 1)
>
> If sChar Like "[0-9,A-Z]" Then
>
> sResult = sResult & sChar
>
> End If
>
> Next i
>
> GetLettersDigits = sResult
>
> End Function
>
> '~~~~~~~~~~~~~~~~~~~
>
>
>
> have an awesome day,
>
> crystal
>
>
>
> On 5/25/18 4:11 PM, Steve thaw5
> thaw5@...<mailto:thaw5@...><mailto:thaw5@....<mailto:thaw5@...>>
>
> [MS_Access_Professionals] wrote:
>
>> In the snippet of code below, CombinedInfo is a string containing
>> upper and lower case letters, numbers, spaces and assorted special
>> characters such as &, *, $, #, @, etc. I need to delete the spaces
>> and special characters, retaining only the letters (upper and lower
>> case) and numbers. What type of test can I use in the For-Next loop to do that?
>> For MyCounter = 1 To Len(CombinedInfo) Debug.Print MyCounter & " " &
>> Mid(CombinedInfo, MyCounter, 1) Next MyCounter Thanks, Steve
>> ------------------------------------
>> Posted by: Steve thaw5
>> <thaw5@...<mailto:thaw5@...>><mailto:thaw5@...<mailto:thaw5@...>>
>> ------------------------------------
>> ------------------------------------
>> Yahoo Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
> Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
------------------------------------
Posted by: crystal 8 <strive4peace2008@yahoo.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.