"N Harkawat" wrote...
If the number that you want to extract always begins after second instance
of "|" and ends just before "^" then use the following: -
....

If these assumptions hold, better to use Edit Replace to eliminate the ^s,
then use Data Text to Columns, Delimited, specify | as the delimiter, and
skip the first two fields.