Extract Number Between Two Delimiter

AppSheet AppSheet Q&A
1

Hi all,
I want to Extract Number from this Text String
12 X 14 X 200#110#50

I want to 110 as Result of App Formula

2

index(split("12 X 14 X 200#110#50", "#"), 2)

2 Likes
3

Steve:

index(split(“12 X 14 X 200#110#50”, “#”), 2)

And the more generic form, reading a column value should work as well… right @Steve?

index(split([ColName], “#”), 2)

1 Like
4

Yep!

5

Thanks @Steve

1 Like