Skip to content

Instantly share code, notes, and snippets.

@halbuki

halbuki/EXREP

Last active September 6, 2022 11:00
Show Gist options
  • Save halbuki/c676f0fbf482aac6a1fb845fdddfef88 to your computer and use it in GitHub Desktop.
Save halbuki/c676f0fbf482aac6a1fb845fdddfef88 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Lambda functions for Power Query Replacer functions
Raw
EXREP
/* USE NAMESPACE "Replacer" */
ReplaceText = LAMBDA(_text, _old, _new,
SUBSTITUTE(_text, _old,_new)
);
ReplaceValue = LAMBDA(_value, _old, _new,
IF(_value = _old, _new, _value)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment