question Extract Text - Extracting delimited data in Archives of Support Questions (Read Only)

Extract Text - Extracting delimited data

mayank_rathi — Thu, 13 Jul 2017 01:31:40 GMT

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? 🙂

MattWho — Sun, 18 Aug 2019 08:27:02 GMT

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

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

mayank_rathi — Wed, 19 Jul 2017 23:20:32 GMT

Thanks Matt. 🙂