Data Table - Extract Value from Value Pair

[gary.cobden]

I have a Data Table with the following example data in columns 1 and 2
Column 1 - TASK0172192
Column 2 - { “link”: “https://xxxx.service-now.com/api/now/table/task/12c297e81bb842504424c88b274bcb96”,
“value”: “12c297e81bb842504424c88b274bcb96”}

I need to extract the Value eg “12c297e81bb842504424c88b274bcb96” from Column 2

Anybody able to assist please

Thx

[mkankatala (Mahesh Kankatala)]

Hi @gary.cobden

Use the below regular expression to extract the required output in Column2,

(?<=value.*)[\w\d]+(?=.\})

Hope it helps!!

[ppr (Peter Preuss)]

Column2 looks like a JSON String

strJSON = coumn2 value

[Jayesh_678 (Jayesh)]

Hi,

Input:-

Output:-

Xaml file:-

Main.xaml (7.5 KB)

Thanks