Skip to Content
avatar image
Former Member

Replace several values in a column

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 22, 2014 at 04:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded