Possible to rename one data value?

[#1]

I am quite familiar with changing field names using the "as" modifier in the load script, but is it possible to rename a data point in a field within a load script (or even better - an object)?  If so, how?

I.E if my field is "Fruits" and I want to rename "oRanjes" to "Oranges", is that possible without editing the underlying data?

[munna1317]

PLZ find the attachments ,

through Mapping load and by using Applymap we can do it.

[munna1317]

hi marco ,,

Through Mapping load and Apply Map we can change spelling for that by using another table its very simple scenario ,

Thxs and regards ,

HArish

[Colin-Albert · Accepted solution]

Yes you can use replace in the load script or on the from end.

Obviously it is better to do it once in the script, but you can test it on the from end.

Also you can cascade several replace commands together.

     replace(replace(replace(field,'aa','cc'),'mm','nn'),'xx','yy')

[#5]

This worked great - thank you for your patience, Colin!

[#6]

Hi Harish -

Thank you for the help!  I see how this works now   Many thanks!