Hi, I need to determine if certain row should be included or not. If the "Email Address" column only contains yahoo email address "don't include", if it contains yahoo email address and also other email address "include" this row. Thank you for your help. Email AddresssNotesjohn.andrew@yahoo.comdon't includefjlorenzo@gmail.comincluderomylorenzo@gmail.com;maloudeguzman@yahoo.comincludejoadaya@yahoo.com;thessdalmacio@gmail.com;janebuglosa@outlook.comincludethessdelacruz@yahoo.comdon't include

Sort File Base on Column Value

Hi,

I need to determine if certain row should be included or not. If the "Email Address" column only contains yahoo email address "don't include", if it contains yahoo email address and also other email address "include" this row. Thank you for your help.

Email Addresss	Notes
john.andrew@yahoo.com	don't include
fjlorenzo@gmail.com	include
romylorenzo@gmail.com;maloudeguzman@yahoo.com	include
joadaya@yahoo.com;thessdalmacio@gmail.com;janebuglosa@outlook.com	include
thessdelacruz@yahoo.com	don't include

Workflow

Accepted answers

KaneG

Hi @fjlorenzo,

The quickest solution here is an If statement and replace all the @yahoo.com. Don't worry, it's not actually changing your original data.

IF REGEX_CountMatches(Replace([Email Addresss],'@yahoo.com',''),'@')
THEN 'include'
ELSE "don't include"
ENDIF

All comments

KaneG

Hi @fjlorenzo,

The quickest solution here is an If statement and replace all the @yahoo.com. Don't worry, it's not actually changing your original data.

IF REGEX_CountMatches(Replace([Email Addresss],'@yahoo.com',''),'@')
THEN 'include'
ELSE "don't include"
ENDIF

fjlorenzo

Hi @KaneG ,

Thank you so much. Would you be able to explain how this works? Just wanted to understand the IF statement how it works.

Regards,

Florence

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703