Flag field based on string data in multiple fields

[surajap123]

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

[Marijn · Accepted solution]

You can use substringcount:

if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag

[surajap123]

Thank you so much @Marijn 

[Marijn]

You're welcome @surajap123 !