Re: how do you check a string before replace

Salad's way is simpler and easier, but if you want to test character by
character, the ASCII code of a numeric character is greater than 48 and less
than 58 and the most commonly used blank/space character's ASCII code is 32.

Larry Linson
Microsoft Office Access MVP

"sparks" <sparks@xxxxxxxxxxx> wrote in message
news:lq2vt4pd3agfvujv85sijosvtc97q7ko7v@xxxxxxxxxx
I have a ton of strings I am parsing out and the only problem I have
is knowing whats a date and whats a special chr in a text field.

##/##/## is a date and so is #/#/## while bob/fred/mary is not.

so I checked and its ok for me to just replace all the non date / with
an underscore.
This way I can populate a table with the date and comment I pull out
of each memo field.

replace sounds nice but how do I check and see if the chr in front of
or behind the / is a number or a " " or a chr?

is this the best way to go?




__________ Information from ESET Smart Security, version of virus
signature database 3999 (20090410) __________

The message was checked by ESET Smart Security.

http://www.eset.com






__________ Information from ESET Smart Security, version of virus signature database 3999 (20090410) __________

The message was checked by ESET Smart Security.

http://www.eset.com




.

Relevant Pages

  • Need help to remove tbas, carriage retrun, and other!!!
    ... ASCII code of the character ... that I link to) to specify the string that you want to ... optionally the ascii chr number of the delimiter ... 'At the start point of the string (1 character after the ...
    (microsoft.public.access.queries)
  • Re: how do you check a string before replace
    ... the ASCII code of a numeric character is greater than 48 and less than 58 and the most commonly used blank/space character's ASCII code is 32. ... is knowing whats a date and whats a special chr in a text field. ... The message was checked by ESET Smart Security. ...
    (comp.databases.ms-access)
  • Re: Text files
    ... The most common form of text files use ASCII code, and there is no character ... Microsoft's DOS started its life as a CP/M look alike for the 8086/8 ... and added automatically a CTRL-Z at the end of text files ...
    (comp.lang.c)
  • Re: Does the cell have a number?
    ... CODEreturns the ascii code for each character - I'm looking for numbers ... I would like to be able to determine if any part of the cell>>>contents is a number, even if the string starts with, or contains ...
    (microsoft.public.excel.worksheet.functions)
  • Re: My symbols turn to question marks
    ... the space between & and #) where the number is the ASCII code for the ... It is possible that your server is delivering the page with UTF-8 character ... > marks or other oddball symbols. ... > question mark. ...
    (microsoft.public.frontpage.client)