Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
How I can replace
* as CurrentYear
? as PreviousYear
# as PreviousYear
Data | Revenue |
---|---|
*ACTUAL | 2 |
?ACTUAL | 3 |
Revenue# | 4 |
Table Should be like this
Data | Revenue |
---|---|
2017ACTUAL | 2 |
2016ACTUAL | 3 |
REVENUE2016 | 4 |
Hi Satish,
may be like (in Script)
LOAD Field,
Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1) as Data
From Table;
Or You can use Expression directly in straight table.
Regards,
Antonio
Hi Satish,
may be like (in Script)
LOAD Field,
Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1) as Data
From Table;
Or You can use Expression directly in straight table.
Regards,
Antonio
May be this?
=Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)
But not sure, How many field values you need to change?