Regex Pattern Help

[Login123]

I want regex pattern for this string,

2020-12-23T07:00:01.000000+05:30 45.79.121.190 {“hostname”:“li2119-190memberslinodecom”,“os”:{“name”:“CentOS Linux”,“family”:“redhat”,“version”:“7 (Core)”,“platform”:“centos”,“kernel”:“3.10.0-1127.13.1.el7.x86_64”,“codename”:“Core”},“containerized”:false,“ip”:[“45.79.121.190”,“2400:8904::f03c:92ff:fed4:e4f0”,“fe80::f03c:92ff:fed4:e4f0”],“name”:“li2119-190.members.linode.com”,“id”:“c29d751565e74afdbaade6c8a36dd2ef”,“mac”:[“f2:3c:92:d4:e4:f0”],“architecture”:“x86_64”}

required output is-

hostname - li2119-190memberslinodecom, name- CentOS Linux, family-redhat, version-7, platform-centos, ker-nel3.10.0-1127.13.1.el7.x86_64, codename-Core, name-li2119-190.members.linode.com, id-c29d751565e74afdbaade6c8a36dd2ef

Can somebody pls help me .

[NIVED_NAMBIAR (NIVED N)]

Hi @Login123

Welcome to forum

Since the format of string is like json

So you can use deserialize json activity to deserialize the string to jobject from which u can acquire required value by key , value logic

Hope it helps you

Regards

Nived N

Happy Automation

[Login123]

Thanks for your reply @NIVED_NAMBIAR ,but i want to do this using regex pattern.

[Pradeep_Shiv]

Hello @Login123,

use this pattern and Replace your required String (?<=“family”:“)(.*?)(?=”,) for testing I’ve used family here, you can test with all your input string.

Test here = Click here

Cheers
@Login123

[Login123]

@Pradeep_Shiv I tried for other string , but i am facing an error,

how to add multiple patterns?

[Pradeep_Shiv]

Just use once, replace family instead name
@Login123

[Login123]

@Pradeep_Shiv I want full regex pattern for all the values…

[Pradeep_Shiv]

you can assign it for different variables,

@Login123