Validating strings, with and without case sensitivity

[Bigmonki]

Hi,

Second Monday morning challenge, and I promise I did not have a beer yesterday that impairing the thought process!!! 

We have a baseline data set and want to compare it to a value held in a comparison system. The field ACTYPE is containing a string of letters, the order of the letters is not an issue, but in this case we need to know:

• Does the case match
• Are we missing any letters
• Have any letters been added

There is a challenge on a similar field where the same rules above apply, but the sequence of letters must match!

Our baseline and comparison system will have the same fields and names, only the data may vary and there are no delimiters in the VALUE!

[afv2688 · Accepted solution]

Hello @Bigmonki,

hope this helps

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Bigmonki]

Brilliant, thank you for your help. Perfect solution.