How to use regex to remove unwanted characters between # and #?

Hey guys!

I wanted to use regex to remove the unwanted data from my text file. It goes like this:

I have 2 doubts here:

1. I know my data always lies between the tags <pre> and </pre>. I have extracted this already.

But between the tags, sometimes ## comes too. I want to replace all the # and the text between them with a space. What's the best way to go about it?

2. Also, is it possible to extract the data from the data in the form 201808010000 (date and time)

Would really appreciate the help!

Accepted answers

I am able to get output as your expected output using some filter.

Please check and let me know.

Assuming these hashtags appear on a single line, you could split to rows on \n and then simply use the expression,

#.*#

And replace it with nothing (or an empty string to be more precise) in the Regex Tool.

If you care to share some data, I'm sure this is possible.

Lets me answer your 2nd question yes you can extract datetime from the string

Formula

DateTimeParse(ToString([DATE]),"%Y%m%d%H%M")

Hope this helps 🙂

I tried this approach earlier. But as it removes any data between #, it also removes 'needed data 1'

If you notice in the pic I shared, 'Needed data 1' also falls between # in a way

I have attached a file of my actual data. I need all the data which lies after this pattern

'201701010538 TAF KROC'

Except for the data which lies between # ofcourse