I had a VBA expert create a program for me, and it has worked perfectly for
months. However, recently I found there was an error because at a certain
point the program excludes certain inputs that meet a certain criteria. The
exact code is:
If Left$(Instrument$, 3) <> "SPX" Then
The problem is there is one scenario where the instrument starts with "SPX"
but I don't want to exclude it. There are twelve different strings that
might start with SPX, is there anyway to specify the first four letters, and
exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
where "SPX" currently is and putting "or" between them, but I keep getting
errors. ANy ideas?

Thanks

Adam Bush

You don't say which 4th letter you want to keep so I am putting in Z

If Left$(Instrument$, 3) <> "SPX" or left$(Instrument$,4) = "SPXZ" Then

Peter Richardson

"(E-Mail Removed)" wrote:

> I had a VBA expert create a program for me, and it has worked perfectly for
> months. However, recently I found there was an error because at a certain
> point the program excludes certain inputs that meet a certain criteria. The
> exact code is:
> If Left$(Instrument$, 3) <> "SPX" Then
> The problem is there is one scenario where the instrument starts with "SPX"
> but I don't want to exclude it. There are twelve different strings that
> might start with SPX, is there anyway to specify the first four letters, and
> exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
> where "SPX" currently is and putting "or" between them, but I keep getting
> errors. ANy ideas?
>
> Thanks
>
> Adam Bush

Peter,

Thank you very much for your help. I thought for some reason I had to list
the strings to exclude, not to include.

Thanks Again,

Adam Bush

"barnabel" wrote:

> You don't say which 4th letter you want to keep so I am putting in Z
>
> If Left$(Instrument$, 3) <> "SPX" or left$(Instrument$,4) = "SPXZ" Then
>
> Peter Richardson
>
> "(E-Mail Removed)" wrote:
>
> > I had a VBA expert create a program for me, and it has worked perfectly for
> > months. However, recently I found there was an error because at a certain
> > point the program excludes certain inputs that meet a certain criteria. The
> > exact code is:
> > If Left$(Instrument$, 3) <> "SPX" Then
> > The problem is there is one scenario where the instrument starts with "SPX"
> > but I don't want to exclude it. There are twelve different strings that
> > might start with SPX, is there anyway to specify the first four letters, and
> > exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
> > where "SPX" currently is and putting "or" between them, but I keep getting
> > errors. ANy ideas?
> >
> > Thanks
> >
> > Adam Bush

If I am not mistaken, your suggested If-Then statement can be replaced by
this one...

If Not Instrument$ Like "SPX[!Z]*" Then

Rick


"barnabel" <(E-Mail Removed)> wrote in message
news:6B3CF90A-4AA5-49C7-BCA1-(E-Mail Removed)...
> You don't say which 4th letter you want to keep so I am putting in Z
>
> If Left$(Instrument$, 3) <> "SPX" or left$(Instrument$,4) = "SPXZ" Then
>
> Peter Richardson
>
> "(E-Mail Removed)" wrote:
>
>> I had a VBA expert create a program for me, and it has worked perfectly
>> for
>> months. However, recently I found there was an error because at a
>> certain
>> point the program excludes certain inputs that meet a certain criteria.
>> The
>> exact code is:
>> If Left$(Instrument$, 3) <> "SPX" Then
>> The problem is there is one scenario where the instrument starts with
>> "SPX"
>> but I don't want to exclude it. There are twelve different strings that
>> might start with SPX, is there anyway to specify the first four letters,
>> and
>> exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
>> where "SPX" currently is and putting "or" between them, but I keep
>> getting
>> errors. ANy ideas?
>>
>> Thanks
>>
>> Adam Bush

Quite true but I don't want to have to teach and debug somebody else's
regular expressions if they don't know what they are.

"Rick Rothstein (MVP - VB)" wrote:

> If I am not mistaken, your suggested If-Then statement can be replaced by
> this one...
>
> If Not Instrument$ Like "SPX[!Z]*" Then
>
> Rick
>
>
> "barnabel" <(E-Mail Removed)> wrote in message
> news:6B3CF90A-4AA5-49C7-BCA1-(E-Mail Removed)...
> > You don't say which 4th letter you want to keep so I am putting in Z
> >
> > If Left$(Instrument$, 3) <> "SPX" or left$(Instrument$,4) = "SPXZ" Then
> >
> > Peter Richardson
> >
> > "(E-Mail Removed)" wrote:
> >
> >> I had a VBA expert create a program for me, and it has worked perfectly
> >> for
> >> months. However, recently I found there was an error because at a
> >> certain
> >> point the program excludes certain inputs that meet a certain criteria.
> >> The
> >> exact code is:
> >> If Left$(Instrument$, 3) <> "SPX" Then
> >> The problem is there is one scenario where the instrument starts with
> >> "SPX"
> >> but I don't want to exclude it. There are twelve different strings that
> >> might start with SPX, is there anyway to specify the first four letters,
> >> and
> >> exclude SPXJ, SPXK, SPXG, SPXH, etc? I tried listing all these scenarios
> >> where "SPX" currently is and putting "or" between them, but I keep
> >> getting
> >> errors. ANy ideas?
> >>
> >> Thanks
> >>
> >> Adam Bush
>
>