Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdelaqua
Creator
Creator

Replace multiple strings with multiple strings

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.

 

Labels (2)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Use the MapSubstring() function.

-Rob

ericdelaqua
Creator
Creator
Author

Thanks A lot Rob, worked like a charm.