Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible to replace multiple strings with multiple strings in the script.
I have this strings:
value,Newvalue
ADC,ABCD
AC,ABC
BC,ABC
And I have the following data :
table:
Load* Inline [Key,Value
key1 , 129BC32 ADC456AC
];
How can I replace the string in the values field on the table with the value of the map above? This is a big data exercise and a simple solution will be appreciated.
Use the MapSubstring() function.
-Rob
Thanks A lot Rob, worked like a charm.