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 = 8)

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?

See this very similar post:

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…
1 Like

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.

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

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

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}&""`

.

YES thank you! That did the trick!

system
closed
September 26, 2021, 8:32pm
#8
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.