Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to replace a sub string based on a wildcard match. How would I do this? The function "Replace" does not seem to accept wildcards, but conceptually I would like to be able to do something like this:
Replace(MyField, 'b.d', 'XYZ'))
Then examples of field values and results results would look like this:
so only bd get replaced when there is something in the middle of it?
I think you will need to use the substring/index function and concatenate the XYZ in the middle of it deleting bd when there is something between bd
I think you could use mapsubstring() for it. Here two examples what is meant:
Yes, it is a bit bloat but works:
load * Inline
](delimiter is ',');
Load * inline
] (delimiter is '|');
MapSubString('replacemap',Field) as replace_step,
replace(MapSubString('replacemap',Field),'@','NewString') as Final
drop table base;