Renaming field value in script

[nareshthavidishetty]

Hi,

How to rename field value in script level.

Field: HPTOX

Value with in field : Electric

Here i need to rename Electric into Electric\GE

Thanks..

[Aurelien_Martinez · Accepted solution]

Hi,

Load

  Pick(Match(HPTOX, 'Electric')+1, HPTOX, 'Electric\GE') as HPTOX

[..]

OR

you can use mapping load / applymap function

Aurélien

[nareshthavidishetty]

Hi,

I have the got the answer with the below logic as well.

if(left(HPTOX,8)='Electric','Electic\GE',HPTOX) as HPTOX

Thanks..