How to remove &symbol in table

[Lucky1]

Hi i have a pivot table with values

Status

Completed

& Completed &pending

Pending

&Pending

I want to remove & symbol if the value start with &symbol i want result like

Status

Completed

Completed &pnlending

Pending

Pending

[BrunPierre]

Try this.

Trim(If(Left(Field, 1) = '&', Mid(Field, 2), Field))

[Lucky1]

Tried not working brunpierre

[BrunPierre · Accepted solution]

[Chanty4u]

Try this in your calucauted dimension 

replace(Status, '&', '')

[Lucky1]

Thanks brun.sorry in my pivot table my values are like &

Completed

If we have & symbol it will start with next line.i have used chr(10)in my code

[Lucky1]

Hi BrunPierre.Thanks for your reply.I have status field like below.not like  & securities services.I want to remove this & symbol if the values start with & symbol

I have status field like this 

[Chanty4u]

Did you tried this ?

YourTable:

LOAD

   Replace(Status, '&', '') as Status

FROM YourDataSource;

Or

Anyone you can use 

In calucauted dimension

replace(Status, '&', '')