Text Between Two Delimiters?

[Rachel_RBC]

Hello,
I have a mess of a formula that I'm having trouble figuring out where I'm missing arguments. I also wonder if this is the best/easiest way to accomplish this.

I want to return the text between two delimiters, the first "~", and then "^_^". In the below sample Data, I want to it to return 5lb. All of our data should have the delimiters, but I would like to account for my coworkers possibly not following directions when this input data is created on another app.

Sample Data (Cell D21 on 'Input' sheet):
--start--
Source: Justin Goldman

~

5lb

^_^

High value item!
--end--

My messy formula: =IFERROR(IF(Input!D21="","",TEXTAFTER(iferror(TEXTBEFORE(Input!D21,"^_^"),textafter(Input!D21,"~")),"~"),"Not Given")
Right now I get an error for too few arguments, I believe. The tool tips stopped showing up.

Any help is greatly appreciated!

 

[etaf]

this works
=IF(D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(D21,"^_^"),TEXTAFTER(D21,"~")),"~"))
you may be missing )

i have just removed the INPUT! for simplicity to show here

=IFERROR(IF(input!D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(input!D21,"^_^"),TEXTAFTER(input!D21,"~")),"~")),"not given")

Book1
	A	B	C	D
1	5lb
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21				--start-- Source: Justin Goldman ~ 5lb ^_^ High value item! --end--
Sheet4

Cell Formulas
Range	Formula
A1	A1	=IFERROR(IF(D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(D21,"^_^"),TEXTAFTER(D21,"~")),"~")),"not given")

 

[Rachel_RBC]

this works
=IF(D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(D21,"^_^"),TEXTAFTER(D21,"~")),"~"))
you may be missing )

i have just removed the INPUT! for simplicity to show here

=IFERROR(IF(input!D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(input!D21,"^_^"),TEXTAFTER(input!D21,"~")),"~")),"not given")

Book1
	A	B	C	D
1	5lb
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21				--start-- Source: Justin Goldman ~ 5lb ^_^ High value item! --end--
Sheet4

Cell Formulas
Range	Formula
A1	A1	=IFERROR(IF(D21="","",TEXTAFTER(IFERROR(TEXTBEFORE(D21,"^_^"),TEXTAFTER(D21,"~")),"~")),"not given")

Thank you so much! That did the trick.

 

[etaf]

you are welcome