Wildmatch in excel

[shanky1907]

Hi,

I want to use wildmatch like function in excel for a specific column.

Please reply if you have any idea.

Thanks in advance.

[amit_saini]

Shashank,

Just a small example below:

Suppose I'm having excel sheet with column name City and I want to change city names for example Punjab as P1 , Haryana  than below is Syntax .

Syntax:

LOAD Products,

City,

pick( WildMatch(City,'*Punjab*','*Haryana*','*Delhi*'),'P1','P2','P3')

as Data

FROM

1. Prcatice.xlsx

(ooxml, embedded labels, table is Sheet3);

[Gysbert_Wassenaar]

Questions about Excel functions are better asked somewhere else, but perhaps the example here helps: www.mrexcel.com/forum/excel-questions/524460-wildcard-within-match-function.html