Trim to second underscore 1

[CRilliterate]

I have names like
A_1_WE_SILV
Q_2_UU
and I need to trim to before second underbar like A_1

How do I do that?

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[mbutch]

Left (searchfield, InStr (InStr (1, searchfield, "_") + 1, searchfield, "_") - 1)

 

[CRilliterate]

All I did - I just replaced searchfield with actual field name, right?
I got:
'String lenght is less then 0 or not an integer'
and it is NOT an integer...it is a string.


Thanks mbutch, any thoughts about an error? I will go try to alter your formula if I could.

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[mbutch]

Yes, the formula is correct. It may be throwing an exception because you have either a null value in the field or some of the names don't have underscores. Try doing a check on the field first:

IF Not IsNull(searchfiled)
THEN formula
ELSE ""

If that isn't your problem, you will have to check to make sure the string containes underscores like

IF Not IsNull(searchfiled)
THEN
IF InStr(InStr(1, searchfield, "_") + 1, searchfield, "_") - 1 > 1
THEN formula
ELSE whatever you want to do instead
ELSE

 

[CRilliterate]

Brilliant, thanks, working, have a star!!!!!!!!

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server