With(
{
tvRGBAText: Split(
Substitute(
Substitute(
ThisItem.RGBATextValue,
"RGBA(",""),")",""),",")
},
RGBA(
Value(First(tvRGBAText).Value),
Value(
Index(
tvRGBAText,
CountRows(tvRGBAText) - 1
).Value
),
Value(
Index(
tvRGBAText,
CountRows(tvRGBAText) - 2
).Value
),
Value(
Index(
tvRGBAText,
CountRows(tvRGBAText) - 3
).Value
)
)
)
Anonymous
April 25, 2025With(
{
parts: Split(Substitute(Substitute(ThisItem.FilterColor, “RGBA(“, “”), “)”, “”), “,”)
},
RGBA(
Value(First(parts).Value),
Value(First(LastN(parts, CountRows(parts) – 1)).Value),
Value(First(LastN(parts, CountRows(parts) – 2)).Value),
Value(First(LastN(parts, CountRows(parts) – 3)).Value)
)
)
Craig White
April 27, 2025Hey there, great shout! This is a better approach than the one I originally posted. You can streamline this even more by replacing First/LastN with the Index function – see the updated code snippet above!