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

How To
1

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

make.com_1

Thanks

2

Hey @Milton_Bengui

Welcome to make community

You can use the split function here

3

Where? Can you please be more precise?
Thanks

4

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

split(map_your_data_field;|)

2 Likes
5

It is returning…
make.com_3

The setup:

make.com_2
make.com_2732×309 32.9 KB

Thanks

6

@Milton_Bengui

mapping

image
image1247×432 59.6 KB

output

image
image1380×552 65.1 KB

7

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

2 Likes