Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I want to create a new flag field whenever the term below terms are found in Name or Desc columns.
CD or Disc or CD Disc
ID | Name | Desc | Pos |
6957 | GBC Poly Designer Binding Covers | Office Supplies Disc | OFF-BI-10000320 |
6958 | HTC One Mini | Technology | OFF-AR-10004999 |
6959 | Laser & Ink Jet Business Envelopes | Office Supplies Disc | OFF-BI-10001116 |
6960 | Cardinal Holdit Data CD Disc Pockets | Office Supplies | OFF-AP-10002651 |
6961 | HTC One Mini CD | Furniture | OFF-AP-10001634 |
Please suggest.
Thanks
You can use substringcount:
if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag
You can use substringcount:
if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag
Thank you so much @Marijn
You're welcome @surajap123 !