Re: A new twist on the last problem (D3/NT)


johnmarshall@xxxxxxxxxx wrote:

Is their any simple tweak that I can do to my synonym to get just those
pesky leading alpha characters? Note that the number of leading alphas
and the following numerics can vary, but the end alpha (after the
numeric) if present at all, is only ever 1 character.

assuming you have at least one leading alpha... the following will
work:

f1;(mca);p;p;(l0);1;_;c1;_;[];=;JT end;1;p;(l0);c1;_;c1;-;[];(mca);~end

.

Relevant Pages

  • Re: A new twist on the last problem (D3/NT)
    ... The practical way seeing these items already exist - write a basic subroutine to parse the ID and return only the leading alpha characters. ... This synonym gave me all the alphas in the record ID so for the above ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)
  • Re: A new twist on the last problem (D3/NT)
    ... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... wanted just the first alpha part before the numeric, ie R, RC, SZY. ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)
  • Re: A new twist on the last problem (D3/NT)
    ... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)
  • A new twist on the last problem (D3/NT)
    ... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... wanted just the first alpha part before the numeric, ie R, RC, SZY. ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)
  • Re: A new twist on the last problem (D3/NT)
    ... I tried this and looks working, but only if the last character is supposed ... to be an extra alpha or a numeric (it doesn't work for an all alphabetic ... This synonym gave me all the alphas in the record ID so for the above ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)