A function that exlcudes a list of numbers and/or characters from a string

[unshar]

Example:

Equipment Id	Type	Clean Equipment ID
123L	Line	123
123S	Substation	123
S156	Substation	156
123X	Bus	123
123L6	Delivery point	1236

If I want to create the 'Clean Equipment ID" I would have to use a complicated RegEx expression. Wouldnt it be easier for the end-user to have a function to do so? Like Exclude(string,character)?

In this case it could be: exclude([equipment id],"ABCDEFGHIJKLMNOPQRSTUVWXYZ") and if I wanted just letters it could be exclude([equipment id],"0123456789").

[jdunkerley79]

Thnk this achievable wih a relatively simple regex:

REGEX_Replace([Equipment Id],"[A-Z]","")

This will remove all letters. Change [A-Z] to [0-9] to remove all numbers.

[unshar]

This is worth gold! Thanks!