Help

Splitting dimensions into 3 columns

Topic Labels: Formulas
Solved
Jump to Solution
2954 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachel_Erickson
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions

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

See Solution in Thread

6 Replies 6

See this very similar post:

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:
image

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?
image

image

image

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!