How to write regex to extract a field from a log?

[Bhuavana]

Hi,

I have a below log :

INFO com.wu.channelservices.businesslogic.impl.ChannelServicesLogicImpl S:METHOD_NAME=GwpCreateSession : WebAppSessionId= : ChannelSessionId= : ClientIp=027050022090 : - databases.database[0].info.name: CAN_STATE_LIST

From above message i need to extract the value of database name[CAN_STATE_LIST] alone from below full text :

databases.database[0].info.name: CAN_STATE_LIST

Could you please share me the corresponding regex for the same?

[ulrich_track]

You can find it out by copying that section in regex101.com and playing around. I found this:

During searchtime:

| rex "name:\s(?<DBname>\S+)"

Or in the field-extractor

(?m)name:\s(?<FIELDNAME>\S+)

[Ayn]

This should be possible to extract using the Interactive Field Extractor.