How to convert a text string delimited by a pipe to json

[Milton_Bengui]

I have text data delimited by a pipe “|” as shown below and need to separate the values to store them into different variables or a JSON file to use them as variables.

Data = 00292|120230155|NETC1.2023.155-1|4385529|20520|20240601102113|PAID

Thanks

[ManishMandot]

Hey @Milton_Bengui

Welcome to make community

You can use the split function here

[Milton_Bengui]

Where? Can you please be more precise?
Thanks

[Michaela]

Hey @Milton_Bengui, you can use the split() function. This is how you would write it:

split(map_your_data_field;|)

[Milton_Bengui]

It is returning…

The setup:

Thanks

[ManishMandot]

@Milton_Bengui

mapping

output

[Milton_Bengui]

I managed to get it right, by parsing the text value from the converted encoding.
It seems to get the string directly from the module Convert encoding is not accepted.
Thanks