How can i write an expression with if statement, applymap and left() / right() functions?

[Mattia]

Hi guys,

attached is a sample data file (is a personal/desktop) edition.

The output i want to obtain is the following:

if field5 = 0,  the first 5 number of field4 and the last two of the same field.

applymap and left() / right () functions can coexist?

Thanks,

Mattia

[sunny_talwar · Accepted solution]

May be this

If([FIELD5] = 0, Left(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 7) & ',' & Right(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 2)) as New_Field