wild match

[nevilledhamsiri]

Hi

Please find my attachment & explain me how that may be done in a chart without being missed out even a single data. What is colored in yellow to be highlighted

When names are in different formats & need to get highlighted a set of data,

how it is highlighted in the script

how it is done as an expression

how it could be done in list box (Eg-Cust Name)

Thanks

Neville.

[nevilledhamsiri]

The customer I am searching for ends up his name with term Upasena. But the data entry officer has entered this differently. at times with Mr, Mrs. T, K.D etc, Silveray is not in his name but he is the owner. You forget about all that for the moment and show me an expression to pick what ends up with upasena & add some logic to excludes other than Mr, Mrs, T, K.D. Just forget about Sivary as its is completely in different name.

MR.UPSENA

UPASENA

T.UPASENA

K.T.UPASENA

MRS.UPASENA

T.UPASENA

SILVARAY

K.D.UPASENA

[vishsaggi · Accepted solution]

Try this?

LOAD CUSTOMER_NAME,

     PREMIUM,

     IF(Not WildMatch(CUSTOMER_NAME, '*K.T.*') AND WildMatch(CUSTOMER_NAME, '*Upasena*', '*Upsena*', 'SILVARAY'), CUSTOMER_NAME) AS ValidCust

FROM

CUST.xlsx

(ooxml, embedded labels, table is Sheet2);

[nevilledhamsiri]

Thanks Vishwarath

Almost close, If I need to add some more names (such as say K.D.S.S.R.UPASENA, N.UPASENA & so on, how this expression to be modified. since we have already given name upasena in to the expression does the expression automatically pick them?

Regds

Neville

[vishsaggi]

Yes, it should pick them. The only names that will not be picked are the names that start with K.T. as you can see in the Not Wildmatch expression.

[nevilledhamsiri]

Thanks Vishwanath  for tame taken to resolve my issue!

Best Regards

Neville

[vishsaggi]

No problem.