Split Text to Multiple Columns

[Rachel_Erickson]

Hi everyone,

I currently have a base where there is a column for DIMENSIONS in the form of manual entry formated as such: 12" x 10" x 8"

I would like to SPLIT the numerical values into 3 different columns (column 1 = 12, column 2 = 10, column 3 = 😎

From my research I have not been able to find an adequate split formula (I know that airtable, unfortunately, doesn’t have an easy way to SPLIT)

How best would I go about splitting this information by a split-like formula?

[Kamille_Parks]

See this very similar post:

Taking Dimensions listed in one field and extracting them into separate fields Formulas

Your could do this with REGEX_REPLACE() For each of your three fields, use this formula structure: VALUE( REGEX_REPLACE( Name, "(\\d*\\.*\\d*)(\\D*)(\\d*\\.*\\d*)(\\D*)(\\d*\\.*\\d*)", "$#" ) ) The formula is looking at a five-part pattern: (length)( x )(width)( x )(height), and then replacing the whole thing with a specific piece from that pattern. The piece is chosen by "$#", where # equals some number between (in your case) 1 and 5. For {Length}, replace "$#" wi…

[Rachel_Erickson]

Ah! Thank you!

One more question for you:

VALUE(
REGEX_REPLACE(
Name,
“(\d*\.\d)(\D*)(\d*\.\d)(\D*)(\d*\.\d)”,
“$#”
)
)

In the “Name” section, is this where I would put the column name I am pulling from? I’m guessing no based on this formula I attempted:

Any guidance on how to appropriately pull from that column is appreciated.

[Rachel_Erickson]

Never mind! THere was a rough [ which was causing the problem. Thank you for your help!

[Rachel_Erickson]

Do you have any guesses as to why this error is happening? I’m wondering if because there are decimals and not an integer?

[Kamille_Parks · Accepted solution]

The formula is written to handle decimals. Since you’re pulling from a Lookup-type field its possible Airtable is reading {Dimensions (IN) Linked} as an array and not a string. In the formula, change: {Dimensions (IN) Linked} to {Dimensions (IN) Linked}&"".

[Rachel_Erickson]

YES thank you! That did the trick!