Upper all CustomerCode

anh.nguyen · June 3, 2022, 6:36am

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

Lak_Ui · June 3, 2022, 6:41am

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

Yoichi · June 3, 2022, 6:43am

Hi,

Can you try the following expression?

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

Regards,

system · June 6, 2022, 6:43am

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