Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My problem is I want to compare the set of values of a field with a String.
I m getting problem with substring function.
I m using expression like
=SubStringCount(concat(KRMO_MODULE_NAME,','),'Enrollment')
it is working fine.but values of field KRMO_MODULE_NAME are:
Compliance |
Data Management |
Data Timeliness |
Enrollment |
Enrollment/Discontinuation |
Monitoring |
Monitoring Visits |
Protocol Deviations |
Queries |
Safety |
SDV |
So if I m matching the string with 'Enrollment' , so there are two values containg this part of string.
So it is giving incorrect result.
So which function should i use to compare for the exact substring.?
Need urgent help....
Hi, Try this..
=SubStringCount(concat(KRMO_MODULE_NAME,'@'),'@Enrollment@')
Hi, Try this..
=SubStringCount(concat(KRMO_MODULE_NAME,'@'),'@Enrollment@')
Thanks Arun, It helps me. It is working correctly.
But one doubt what the symbol @ does here?
Hi,
You can use any symbol here,
when it used in concat function, it will make string like @Enrollment@Enrollment/Discontinuation@....etc
So, if you search for @Enrollment@, only one value will be returned.
And one more point,
you should use
=SubStringCount(concat(F1,'@'),'Enrollment@')
because, if Enrollment is first value, concat will return Enrollment@Enrollment/Discontinuation@...so it will return 0.
Try it by selecting Enrollment and Enrollment/Discontinuation in list box.
Thanks Arun.. Its a great help for me.