Remove multiple strings from a field value

[maddysalunke]

Hi all,

I have a table with column called "Group"

it has values like

Group

Group Client - ALL

Group Client- ABC

Group Client - XYZ

.

.

.

]

In the filter , I want to remove "Group Client -" chars from the value.

Any idea ?

PurgeChar(Group,'Group Client -') is not working.

[Or]

Replace(Group,'Group Client -','') perhaps?

[BrunPierre]

Like this.

Trim(SubField(Group,'-',-1))

[Kushal_Chawda]

@maddysalunke  one more way

LOAD *,
     trim(TextBetween(Group,'-','')) as String
FROM Table;