Formula syntax may be incorrect

Deano478

Hi all,

I have an expression like so: Replace([_CurrentField_], 'Sum_', "") AND Replace([_CurrentField_], 'First_', "")

However when I run the function I just renames the columns with names like so:

0.000000

0.000002

and so any input on what i'm doing wrong is very much appreciated

Transformation

Accepted answers

Deano478

I did a bit more tweaking and was able to just rejig my expression like so:

IF Contains([_CurrentField_], 'Sum_') Then Replace([_CurrentField_], 'Sum_', "") ELSEIF Contains([_CurrentField_], 'First_') Then Replace([_CurrentField_], 'First_',"") ELSE [_CurrentField_] ENDIF

thank you @Prometheus for taking the time

All comments

Prometheus

@Deano478 Try using Replace([_CurrentField_], 'Sum_', "") in one expression window and Replace([_CurrentField_], 'First_', "") in another expression window that refers to the same column.

Deano478

I did a bit more tweaking and was able to just rejig my expression like so:

IF Contains([_CurrentField_], 'Sum_') Then Replace([_CurrentField_], 'Sum_', "") ELSEIF Contains([_CurrentField_], 'First_') Then Replace([_CurrentField_], 'First_',"") ELSE [_CurrentField_] ENDIF

thank you @Prometheus for taking the time

binu_acs

@Deano478 Another option with nested Replace function

Replace(Replace([_CurrentField_], 'Sum_', ""), 'First_', "")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703