ericdelaqua
Creator
2019-02-18
07:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1,590 Views
2 Replies
rwunderlich
Partner Ambassador/MVP
2019-02-18
07:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the MapSubstring() function.
-Rob
ericdelaqua
Creator
2019-02-18
08:09 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks A lot Rob, worked like a charm.
1,585 Views