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?
This may help..
"value:\s+.{6}(?<val>.{2})"