Sep 23, 2021 08:52 AM
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?
Solved! Go to Solution.
Sep 23, 2021 01:28 PM
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}&""
.
Sep 23, 2021 09:30 AM
See this very similar post:
Sep 23, 2021 09:49 AM
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.
Sep 23, 2021 09:49 AM
Never mind! THere was a rough [ which was causing the problem. Thank you for your help!
Sep 23, 2021 01:15 PM
Do you have any guesses as to why this error is happening? I’m wondering if because there are decimals and not an integer?
Sep 23, 2021 01:28 PM
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}&""
.
Sep 23, 2021 01:31 PM
YES thank you! That did the trick!