What function will help me determine a variable part of text?

muahmmad_zaidi

I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column.

Question is how do I write a Case formula that will return True or False based on the contents of another column?

For example, the word "Delivery" is placed in different locations on a string in one column. On the Add Formula tile what would the case formula look like if I were attempting to return "True" for all entries that contain "Delivery"?

Thanks in advance!!!

GrantSmith

You can use a CASE statement with a LIKE operator to determine if the word Delivery is in your string:

CASE WHEN `field` LIKE '%Delivery%' THEN 'True' ELSE 'False' END

If you want to have it case insensitive you can use ILIKE instead of LIKE

GrantSmith

You can use a CASE statement with a LIKE operator to determine if the word Delivery is in your string:

CASE WHEN `field` LIKE '%Delivery%' THEN 'True' ELSE 'False' END

If you want to have it case insensitive you can use ILIKE instead of LIKE

muahmmad_zaidi

It worked. Thanks Grant!