Upper all CustomerCode

Hi bro,
I want Upper all CustomerCode bc some C00144 or c00144 so I want auto upper C0014. Ex:
CusCode.ToString.trim.toupper.Contains(“C00144”) → OK

But when use array variables CusCodeTH3.ToString.trim.toupper.Contains(CusCode) → Not correct

Hi @anh.nguyen

You can save CusCodeTH3 it as a string instead of array for eg ; “C00632,C00620, …” and then use .toupper and contains

1 Like


Can you try the following expression?

CusCodeTH3.Any(Function(s) s.ToUpper.Contains(CusCode.ToUpper.Trim))


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.