Json ingestion --> Data models Inquiry around best practices

[Marius]

Populating a data model with json feed:

One of the fields "mnemonic" looks like this in _raw "mnemonic":"119fw3q-wrl-834v:abc:E10251:2048:119fw3q:You can do it! - TKO"

Strangely the mnemonic field in the data model only captures until the first colon ":"

mnemonic = "119fw3q-wrl-834v"

Does anyone have advise how to get around this without changing the character? Tried some stuff with rex in eval bu _raw is not available for use in eval functions. Thanks in advance

[Marius · Accepted solution]

Solved this by using the add via regular expression dropdown option:

\"mnemonic\"\:\"(?<mnemonic>.+?)\",

Give me the Karma Baby