Re: Text format

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 08/03/04 

Date: Mon, 2 Aug 2004 23:35:48 -0700

Hi
the question was if the lower case letters are ALWAYS
AFTER the last '-'. That is the following string is not in
your data list
AAA-ascv-DD

If this is not an allowed entry it would reduce the
formula complexity

>-----Original Message-----
>Yes, the lower case letters are preceded by "-"
>
>Here is what I think:
>1.SEARCH("-";A1;1) ---> result 3
>2. Test character 4(3+1) from A1 with CODE() to get the
ascii code
>3. Lower case letters have the ascii code >=97, so if
code <97 I will search the A1 text from character 4(or 5)
to the end and see if there are any more "-" characters.
>4. The second "-"have the search result 9 and I'll test
character 10 who have the ascii code >=97. So I'll stop
and copy A1 from 1-st to 8(9-1) characters to result "AA-
BB CC"
>
> Can you tell me how to get for example the 3-rd
character from A1 text ?
>"Frank Kabel" wrote:
>
>> Hi
>> is this text part always after the last '-'?
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>
>> Me wrote:
>> > Hy,
>> >
>> > I have an text how looks like this: "AA-BB CC-dd". I
want to select
>> > the text until the "-dd", so the result would be "AA-
BB CC". So the
>> > text until "-" followed by an lower case letter. How
can I do that ?
>>
>>
>.
>

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: Advanced Filter/Sort for Mixed Number and Letter Variables
    ... you run a query using ASCyou will get the ASCII code number for each, ... you can change the string of numerals into an actual value ... "Michael Conroy" wrote: ... numbers and letters were seperated at one time, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Portable and ok?
    ... you can easily construct constant expressions ... Character and string literals are a bit more difficult. ... You can do the same thing for letters by checking ...
    (comp.lang.c)
  • Re: [Full-Disclosure] TinyURL
    ... Tinyurl will store that long link, ... > It appears that the last four letters are incremented one letter at a ... > one character in the url and came across a link to a kiddie porn site... ... > that types in the string. ...
    (Full-Disclosure)
  • RE: [Full-Disclosure] TinyURL
    ... Tinyurl will store that long link, ... > It appears that the last four letters are incremented one letter at a ... > one character in the url and came across a link to a kiddie porn site... ... > that types in the string. ...
    (Full-Disclosure)