Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You have to rename 'ShipmentNumber' to anything that is not a substring of 'UPSShipmentNumber' (or anything else).
Regards,
Michael
You have to rename 'ShipmentNumber' to anything that is not a substring of 'UPSShipmentNumber' (or anything else).
Regards,
Michael
That was my fear. Thanks for the reply, Michael.
Why "fear"?
It shouldn't be a problem, I just have a lot that are like that in my actual data.
Hi
Try like this,
Hope that helps
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