How to remove the unwanted characters and special symbols using regular expression?

How to remove the unwanted string given below using regular expression

Input: 21;#700J Crawler- Pre-Calibration_Template.xlsm;19

Desired output: 700J Crawler- Pre-Calibration_Template

[Guillaume]

You can do almost anything with regular expressions as long as the rules are clearly defined. In your particular case, you need to define what unwanted string actually is before we can answer.

Regular expressions work on patterns, so you need to clearly define either which patterns are not allowed, or which patterns are allowed. It seems that numbers are only acceptable in some cases (which cases?) and some patterns of letters and symbols are not allowed (which patterns?)

[raghavendra kandukuri]

Hi Guillaume,

everything before '#' and every thing after'.' need to be cleared or truncated

Answer 1

[Guillaume]

"everything before '#' and every thing after'.' need to be cleared or truncated"

then it's very easy:

regexp(yourinput, '(?<=#)[^.]+', 'match')

which basically keeps everything after the first # until it encounters a .