on 03-22-2014 4:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.