split a string into multiple columns

[Anonymous]

Hi ,

I need to split the following string into multiple columns

[Document{{severity=WARNING, field=contract.isLessorOf, message=No value chosen for Lessor Of field., validationRule=MISSING_LESSOR_OF, timesReported=5}}]

column_name           value

severity                     WARNING

field                          contract.isLessorOf

message                  No value chosen for Lessor Of field

validationRule         MISSING_LESSOR_OF

timesReported         5

I see that I can use tmap and some string functions .Tried few ways but did not work. Can someone help me on this please ?

Thanks,

Sirisha

[TRF]

The string is not so far from json format.
tExtractJSONFields could be a solution.

[Anonymous]

Tried tExtractJSONFields  but did not work . I used two tExtractJSONFields .  can you please send me an example ?

thanks,

Sirisha