How to select a string if the original data is not "perfect"?

Hi to all,
I am faced with a “trivial” problem but, which is blocking me.
With a Select Item I have to select the specific name that is passed by a path.
The problem is that on the database, the data is passed in lowercase, while in the list, it is uppercase?

from DB: Tim
in select item is TIM
image

Since, not all names in the list are always capitalized, and apparently there is no exact rule, is there any way to make it work?

I would like to avoid a decoding table, as it could be variable data.

thanks a lot !!
aaron

Can you explain the issue more?

Use StringComparison.CurrentCultureIgnoreCase here’s a sample of the implementation

image

HI,

Can you try the following steps?

First, get all items of the Select using GetFullText activity etc.
Let’s say, string array variable : items.

items = strItems.Split(vbcrlf.ToCharArray,StringSplitoptions.RemoveEmptyEntries)

Then, extract target item from the above, using LINQ etc (case-ignore).

selectString = items.Where(Function(s) s.ToLower=target.ToLower).FirstOrDefault

Finally, if the result is not null, it’s item we should select.

Regards,