In operator

[voroojak]

Hi
If i want to use IN operator in VB , then how can i use it?

i mean i want to something like this

If Mid(WholeLine, 22, 3) In ("JAN" ,"FEB") then

but it gives me error.

i would appreciate any help.
thanks

[hariharanmca]

Hi
If i want to use IN operator in VB , then how can i use it?

i mean i want to something like this

If Mid(WholeLine, 22, 3) In ("JAN" ,"FEB") then

but it gives me error.

i would appreciate any help.
thanks

You can use inStr() function Like

[CODE=vb]If inStr(1,Mid(Who leLine, 22, 3), ("JAN" ,"FEB") ) > 0 then[/CODE]

[voroojak]

thanks
i tried but still gives me error
thanks alot for quick answer

[hariharanmca]

thanks
i tried but still gives me error
thanks alot for quick answer

can you post what you had tried and what is the error you are getting?

[voroojak]

elseif inStr(1,Mid(Who leLine,22,3),(" JAN,"FEB","MAR" ,"APR"))>0 then

and it said
expected :)

thanks

[hariharanmca]

elseif inStr(1,Mid(Who leLine,22,3),(" JAN,"FEB","MAR" ,"APR"))>0 then

and it said
expected :)

thanks

I am not getting what you mean!

What expected?

[voroojak]

the error message is

Expected:)

this is my error message
do u want me to take printscreen?

[mahesh123]

Hi,

Try this code. It may suitable to you.

Switch(Mid("Sam pleTestingXXXXX XXXJAN", 22, 3) = "JAN", "JANUARY", _
Mid("SampleTest ingXXXXXXXXJAN" , 22, 3) = "FEB", "FEBRUARY")


Regards
------------
Mahesh

[hariharanmca]

[CODE=vb]elseif inStr(1,Mid(Who leLine,22,3),(" JAN,"FEB","MAR" ,"APR"))>0 then[/CODE]

Use like this


[CODE=vb]elseif inStr(1,("JAN FEB MAR APR"),Mid(Whole Line,22,3))>0 then[/CODE]

[voroojak]

i will try now
but may i ask what is usage of that 1

what i want to do that if Mid(WholeLine, 22, 3) is equal to jan, feb,... dec,
then i be able to read that fiels and then do something
but i have no idead waht is the role of that 1 and why i have to say >0

thanks alot

[hariharanmca]

i will try now
but may i ask what is usage of that 1

what i want to do that if Mid(WholeLine, 22, 3) is equal to jan, feb,... dec,
then i be able to read that fiels and then do something
but i have no idead waht is the role of that 1 and why i have to say >0

thanks alot

Just consider your
[CODE=vb]Mid(WholeLine, 22, 3) = "JAN"
'Then the inStr will look like
If InStr(1, ("JAN FEB MAR APR"), "JAN") > 0 Then
[/code]

which means
inStr(<Start from Char 1>,<String content As String 1>, <Search String as string 2>) > 0

this > 0 meant string is available else not available
Note : this inStr will return the possition of string 2 in string 1

[voroojak]

thanks alot for your explanation. so i shouldnt put any comma between jan and feb?
if i put coma then it wont work

thankssssssssss ssssss

[Killer42]

... so i shouldnt put any comma between jan and feb?
if i put coma then it wont work

Actually, in this case it probably would. The Instr() function just tells you where inside a string it finds another string. If "JAN" is in there, it probably won't care whether there are commas, spaces or anything else around it.

[hariharanmca]

No, Actully he/she mean "JAN", "FEB",..... etc

[Killer42]

No, Actully he/she mean "JAN", "FEB",..... etc

Good point. Instr() is only designed to search one string, not a bunch of them. Of course, you could easily create a function to accept an array and do a search of it like Instr() if you wanted to. It could be a useful thing to have in one's toolkit.