Hi all,
This is my sample input excel.
In excel if we are getting any other words other than highlighted words (refer, Control, list, Vision) that particular cell should be written as blank.
Expected output.
How to do this.
Please help.
ColB.Equals("refer") and ColB.Equals("vision") and ColB.Equals("control") or ColC.Equals("refer") and ColC.Equals("vision") and ColC.Equals("control") or ColD.Equals("refer") and ColD.Equals("vision") and ColD.Equals("control")
Hi @THIRU_NANI
Can you please check this workflow. Sequence replace wrks2.xaml (10.9 KB)
In output file its copying the same input file.
Thanks,
Lakshmi
@THIRU_NANI ,
ColB.Equals(“refer”) or ColB.Equals(“vision”) or ColB.Equals(“control”) and ColC.Equals(“refer”) or ColC.Equals(“vision”) or ColC.Equals(“control”) and ColD.Equals(“refer”) or ColD.Equals(“vision”) or ColD.Equals(“control”)
above if condition,
showing output like this.
ColB.Equals(“refer”) and ColB.Equals(“vision”) and ColB.Equals(“control”) or ColC.Equals(“refer”) and ColC.Equals(“vision”) and ColC.Equals(“control”) or ColD.Equals(“refer”) and ColD.Equals(“vision”) and ColD.Equals(“control”)
for this condition,
The output is same as input
Above changes have done.