How To change Row Value while creating Straight table

[sspawar88]

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

[antoniotiman · Accepted solution]

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

[Anil_Babu_Samineni]

May be this?

=Replace(Replace(Replace(Data,'*',Year(Today())),'?',Year(Today())-1),'#',Year(Today())-1)

[Anil_Babu_Samineni]

But not sure, How many field values you need to change?