Magic ETL

Magic ETL

Word Count

Is there a way to create a field or value that identifies the number of words in a field? Preferably ETL, but Beastmode if necessary.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Coach
    Answer ✓

    It will count them as separate words.

    You could utilize a regexp_replace to condense all multi-spaces to a single space.

    1. LENGTH(`field`) - LENGTH(REPLACE(REGEX_REPLACE(`field`, ' +', ' '), ' ', '')) + 1
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • If you're considering a word as a number of characters separated by a space you can do something like this with a formula tile:

    1. LENGTH(`field`) - LENGTH(REPLACE(`field`, ' ', '')) + 1

    This will count the number of spaces in your field

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • thanks. How will that handle double spaces? Will it count a double or triple (etc.) space as a single space?

  • Coach
    Answer ✓

    It will count them as separate words.

    You could utilize a regexp_replace to condense all multi-spaces to a single space.

    1. LENGTH(`field`) - LENGTH(REPLACE(REGEX_REPLACE(`field`, ' +', ' '), ' ', '')) + 1
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • solid. Thanks man.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In