Infamous Regexp

[opazzo]

Hi All,

Could you help me with the following Regexp problem :

I would like a regex findig this :

JV or /JV or JV/ or /JV/ or JV( or (JV or )JV or JV)

But not GJV / JVA/ JVG

I tried that :
\W?[^0-9A-Z_]?JV[^0-9A-Z_]\W?

But I Must be wrong as it keeps find GJV

Any ideas ?

 

[Scott Huish]

You may be able to adapt this to what you are doing.

I used the MOREFUNC add-in for this.

Formula in B1:
=NOT(REGEX.FIND(SUBSTITUTE(A1,"JV",""),"\w")+NOT(ISNUMBER(FIND("JV",A1))))

Book1
	A	B	C	D
1	JV	TRUE
2	GJV	FALSE
3	JVA/	FALSE
4	(	FALSE
5	/JV/	TRUE
Sheet1

 

[brettdj]

Hi All,

Could you help me with the following Regexp problem :

I would like a regex findig this :

JV or /JV or JV/ or /JV/ or JV( or (JV or )JV or JV)

But not GJV / JVA/ JVG

I tried that :
\W?[^0-9A-Z_]?JV[^0-9A-Z_]\W?

But I Must be wrong as it keeps find GJV

Any ideas ?

Are you just trying to match part of a string - or the whole string?

And are these valid matches too?
(JV)
)JV(

Cheers

Dave