Extracting a specific part of a text

AppSheet AppSheet Q&A
,
1

Hello Everyone,

I need your guidance to acheive this result.

I have a column that has a counted Qty out of the total Qty

example:

10/25 (needed result: 25)

126/423 (needed result: 423)

1689/2013 (needed result: 2013)

How can I pull the Qty after the the “/” sometimes there is a 3 digits, 4 digits, 5 digits, not fixed ?

shall i use Right() ? shall it be nested with something to make it pull everything after the " / " ? as i cant tell how many digits after the " / " is there.

thanks in advance

2

SPLIT

INDEX

1 Like
3

@dbaum Thanks for your response, shall these two expressions be used nested to acheive my result? ?
in Column A:
25/25
extract everything after the “/” (25 in this example)

Am new to text extractions, never done this before, appreciate your help.

4

figured it out
INDEX(SPLIT([Column A],“/”),2)
it worked , thanks

3 Likes