Field extraction - only 2 characters

rajkskumar — Wed, 10 Feb 2021 16:54:06 GMT

I need to extract two characters to a new field. The query I have written is able to remove the first 6 characters and it retrieves from 7th character till the end.

Data:

{
type: Identifier
value: 1234567890ABCDEF
}

{\"type\":\"Identifier\",\"value\":\"(?:.{6})(?<idCode>.*?)\"}

The query returns "7890ABCDEF" whereas I need only "78". Could someone please help me to fix the issue?

Re: Field extraction - only 2 characters

saravanan90 — Wed, 10 Feb 2021 17:03:25 GMT

This may help..

"value:\s+.{6}(?<val>.{2})"

topic Field extraction - only 2 characters in Installation

Field extraction - only 2 characters

Re: Field extraction - only 2 characters