Anyone any good at regexp?

[OwlHoot]

AFAICS you haven't once mentioned yet what data you want out of that text string.

(although presumably the aim is to extract every useful field)

[mudskipper]

AFAICS you haven't once mentioned yet what data you want out of that text string.

(although presumably the aim is to extract every useful field)

Or what you're doing with the data once it's extracted - where does the database come into things?

[mudskipper]

The structure of the data can be anything

What does this mean?

If you don't know the structure, you can't parse it using regex or anything else.

[original PM]

so are you just looking for a recognisable string somewhere in a larger string?

[suityou01]

OK. Some bizarre questions (not you Owly that was quite astute).

I want to listen for an email. Then strip data out of it. I want the system to be configurable so that the pattern matching "stuff" lives in the database.

So ClientCo then say, right we need a new template I'm not having to roll out a new exe for them.

So incomes the email. Check the subject line, or address it was sent to or whatever you like, to identify which template to get from the database.

Then get the template from the database.

Then use this template to parse the email for data. Then build a comma delimited string of this data. In the order it occurs in the email.

That's it. No more, no less.

So if client co then turn up and say, right Suity we want an email that says

"Apples: 2 Bananas:3 Pears:4" I say sure no problem, just bung a row in that table over there with xyz reg exp.

[suityou01]

And I don't feel like I've drip fed anything. My original question was, can someone give me some regexp to parse this specific string. No more, no less.

[suityou01]

so are you just looking for a recognisable string somewhere in a larger string?

In this case it's more about the colons I think.

Thisisalargestring: And here is some data up until the next space character Thisisanotherlargestring: And here is some more data

Some regxp that turns that lot into

Group1[And here is some data up until the next space character]
Group2[And here is some more data]

Would be absolutely magic. And worth 6 pints.

[darmstadt]

I hate it. Probably cos I don't understand a flipping word.

Very powerful though.

So can anyone help?

And I don't feel like I've drip fed anything. My original question was, can someone give me some regexp to parse this specific string. No more, no less.

No you didn't

[stek]

Seriously farking isn't which is why I asked on here.

FolderGUID:67bfabff-ad78-4d30-918e-811dd2636f83 Outcome:Accept DataItem:SomeData

So I want to parse this.

How would you google that?

I have tried :

RegExp get characters after string literal.
RegExp get characters before space.
RegExp get characters between two strings.

Going mucking fental here.

Awk or cut.

[original PM]

In this case it's more about the colons I think.

Thisisalargestring: And here is some data up until the next space character Thisisanotherlargestring: And here is some more data

Some regxp that turns that lot into

Group1[And here is some data up until the next space character]
Group2[And here is some more data]

Would be absolutely magic. And worth 6 pints.

Yeah I was a PM so have no technical knowledge at all...

but when will it be completed by I have a box to tick?