Search String

[#1]

Hi All,

I am using the following search string to create a dynamic report:

=SubStringCount(Concat(Fields, '|'), 'UPSShipmentNumber')

However, when I select only 'UPSShipmentNumber', it also returns 'ShipmentNumber'.  Is there any way to limit it to only an exact match?

[Anonymous · Accepted solution]

You have to rename 'ShipmentNumber' to anything that is not a substring of 'UPSShipmentNumber' (or anything else).

Regards,

Michael

[#3]

That was my fear. Thanks for the reply, Michael.

[Anonymous]

Why "fear"?

[#5]

It shouldn't be a problem, I just have a lot that are like that in my actual data.

[MayilVahanan]

Hi

Try like this,

Hope that helps

[Anonymous]

There is always a little bit modified solution.  The field values, for example:
A
ABC
BC
XYZ

Here A and BC are substrings of ABC.  Here is what you can do.  Load table with two fields, the first one is for selection, the second to use in condition.  Only the second field must be without substrings.

In your condition, use this:
=SubStringCount(Concat(NewField, '|'), 'Value of New Field')

Regards,
Michael