Skip to main content

Count lines in Long Text field with a formula

R

Is there a way to count how many lines a Long Text field has with a formula?

Currently I am solving with adding a comma at the end of each line inside the Long Text field (LT_Field) and counting with this formula.

ABS(IF(LEN(SUBSTITUTE(TRIM({LT_Field}),",","")) > 1, LEN(SUBSTITUTE(TRIM({LT_Field}),",","")) - 1 , LEN(SUBSTITUTE(TRIM({LT_Field}),",",""))) - LEN(TRIM({LT_Field})))

This works fine but I don’t want to type the commas anymore and just use line breaks instead without my formula breaking:

one, two, three

to:

one
two
three

    2 replies

    J
    Forum|alt.badge.img+18

    Replace all references to a comma "," in your formula with "\n".

    \n is a “new line character” and Airtable uses them (in hidden form) to identify new lines in a Long Text field.

    You can also use \n within a string in a formula to force a newline in the output text, just FYI.

    ABS(IF(LEN(SUBSTITUTE(TRIM({LT_Field}),"\n","")) > 1, LEN(SUBSTITUTE(TRIM({LT_Field}),"\n","")) - 1 , LEN(SUBSTITUTE(TRIM({LT_Field}),"\n",""))) - LEN(TRIM({LT_Field})))
    B
    S
    R
    3 people like this
    • B
      bob_aycock
    • S
      Shelly_Stilger
    • R
      Rod_Tagle
    R
    • Rod_Tagle
    • Author
    • New Participant
    • 4 replies
    • December 6, 2018
    Jeremy_Oglesby wrote:

    Replace all references to a comma "," in your formula with "\n".

    \n is a “new line character” and Airtable uses them (in hidden form) to identify new lines in a Long Text field.

    You can also use \n within a string in a formula to force a newline in the output text, just FYI.

    ABS(IF(LEN(SUBSTITUTE(TRIM({LT_Field}),"\n","")) > 1, LEN(SUBSTITUTE(TRIM({LT_Field}),"\n","")) - 1 , LEN(SUBSTITUTE(TRIM({LT_Field}),"\n",""))) - LEN(TRIM({LT_Field})))

    True MVP right here @Jeremy_Oglesby!! Thanks!

    B
    J
    2 people like this
    • B
      bob_aycock
    • J
      Jeremy_Oglesby

    Reply


    Most helpful members this week

    Terms & Conditions