How can I extract something from this string text?

[jblomqvist]

Hi all,

I have the following data:

How can I extract the code between the symbols ^ ^ above?

I want those values to exist in a separate field

Thank you!

[Anonymous · Accepted solution]

Either

subfield (FieldName, '^', 2)

or

TextBetween(FieldName, 'CLIENT001^', '^20')

Edit:

or

mid(FieldName,11,7)

or ...

[maxgro]

load

yourfield,

subfield(yourfield, '^' ,1) as firstfield,

subfield(yourfield, '^' ,2) as secondfield,

.........

from

.......