Replace several values in a column

[Martin_Irle]

I would like to use the replace function for one column to replace each value with another one. Function Replace does it for one value: Replace({FromWeek},"48","CW48" does work.

What is the correct statement to define a row of'replace'-statements for this column.

Replace({FromWeek},"48","CW48" AND Replace({FromWeek},"49","CW49" etc. leads to error messages. Does anyone have an idea?

Thanks, Martin

[Former Member]

Hi Martin,

you can do it like that

Replace(Replace({FromWeek}, "48", "CW48"), "49", "CW49")

But if you really want to put CW in front of each week

"CW" + {FromWeek}

is easier

Regrads

Thorsten