topic split a string into multiple columns in Talend Studio

split a string into multiple columns

Anonymous — Sat, 16 Nov 2024 03:17:59 GMT

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

Re: split a string into multiple columns

TRF — Tue, 11 Feb 2020 20:09:16 GMT

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

Re: split a string into multiple columns

Anonymous — Wed, 12 Feb 2020 01:30:59 GMT

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

thanks,

Sirisha