Need to check for substring within string?

[kre1973]

I have the following string data in Excel:

{"NSD, Q-3557, WAN SUPPORT", "FIELD NETWORK"}
{"ACTUARIAL VALUATION SYSTEMS", "COMPUTER OPERATIONS"}
{"MQ", "COMPUTER OPERATIONS", "MQ", "HO CASE MGMT SUPPORT"}
{"Q-6996 ESA, PASSWORD SUPPORT", "EIMT-EBSS/WINSIGN/SITEMNDR/LDAP", "Q-5576, THE SERVICE CENTER"}
{"Q-6996 ESA, PASSWORD SUPPORT"}
{"COMPUTER OPERATIONS"}
{"WINDOWS SRVR TEAM INTERNAL SUP", "COMPUTER OPERATIONS", "EMAT"}
{"ACTUARIAL EXPERIENCE STUDIES", "COMPUTER OPERATIONS"}
{"NSD, Q-4354, FIELD PC SUPPORT", "AGENCY BUSINESS SYSTEMS"}
{"ACTUARIAL EXPERIENCE STUDIES", "COMPUTER OPERATIONS"}
{"COMPUTER OPERATIONS"}

I'm using a formula to look for the substring "COMPUTER OPERATIONS" within the strings above. The formula works great, except I need to check to see if "COMPUTER OPERATIONS" is the last occurance of the substring within the string.

I hope I explained it correctly.

thanks

{table.col} like "*COMPUTER OPERATIONS*"

 

[dgillz]

Instrrev({YourField},"COMPUTER OPERATIONS")> will return the starting position of the last occurrence of the substring, or zero if it is not found.

Does this help?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Try something like this:

stringvar array x := "";
if instr({table.string},",") > 0 then
x := split({table.string},",") else
x := {table.string};
x[ubound(x)] = "COMPUTER OPERATIONS";

This will return true if "COMPUTER OPERATIONS" is the last element in the array.

-LB