Extract Text - Extracting delimited data

[#1]

Hello All,

I am trying to extract data using ExtractText such that

Original Text = T03%%350%%11502998%%2151%%3312,56%%3

String.1 = T03

String.2 = 11502998

How can I do that using ExtractText?

Also, can someone please guide me to good resources ( website, blog etc.) so that I can parse such trivial strings by myself in future? 🙂

[#2 · Accepted solution]

@M R

I find the following very useful when trying to build Java regular expressions:

http://myregexp.com

The Java regular expression:

^(.*?)%%(.*?)%%(.*?)%%(.*?)%%(.*?),(.*?)%%(.*?)$

It has 7 capture groups that will result in:

When you add a ew property to the extractText processor with a property name of "string" and use the above java regex.

Of course if you are only looking for two capture groups, you could use the following regex instead:

^(.*?)%%.*?%%(.*?)%%.*?%%.*?,.*?%%.*?$

Thanks,

Matt

[#3]

Thanks Matt. 🙂