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

muahmmad_zaidi
muahmmad_zaidi Member
in Magic ETL

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!!!

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • muahmmad_zaidi
    muahmmad_zaidi Member

    It worked. Thanks Grant!

Categories