Extract text before some sign and probably space before this sign.

[retko1985]

Hello,

I have a text something like this:

one two three four. [1 2 3 4]

I need to extract only "one two three four."

Would be better to get it without space before [.

Can someone help me please?

Thank you

[techvarun]

KeepChar ( '[1 2 3 4]','0123456789' )

[retko1985]

I cannot use keepchar, I dont know whats in there between [].

And I dont want to keep it, I need to cut it out and get whats left.

[sunny_talwar]

Not sure I understand, but how about PurgeChar

Trim(PurgeChar( ...., '[]')) as ....

[thevingo · Accepted solution]

Trim(SubField('one two three four. [1 2 3 4]','[',1))

[retko1985]

Works great, thanks.