Pattern case to be manipulated

[TomBond77]

Hi experts

We have text for cost center displayed as "HU1000/Not assigned", it can also be "ES1001/Not assigned".

Other values: "HU1000/102647"

I need to set these "*/not assigend" fields blank. But the following coding is not working.

 If( Right(Trim(SCOSTCENT__TEXT), Len(Trim(SCOSTCENT__TEXT)) +6) = 'Not assigned', '', [SCOSTCENT__TEXT]) AS [Cost Center],

Any ideas how to solve this issue?

Thanks

Tom

[TomBond77 · Accepted solution]

solved it:

If( Right(Trim(SCOSTCENT__TEXT), Len(Trim(SCOSTCENT__TEXT)) -7) = 'Not assigned', '', [SCOSTCENT__TEXT]) AS [Cost Center],