0

Convert coded text to plain text

Hi. I have this code from Zapier-Jotform

[{"N. de llicència":"Ib 1234","Nom complet":"Mateo Domínguez Fuentes","Data naixament":"02/02/1983","Categoria":"Absoluta"},{"N. de llicència":"IB 1534","Nom complet":"Antonio Fernandez Olives","Data naixament":"03/05/1990","Categoria":"Absoluta"}]

Is there any way to convert it to plain text with any kind of format? For example, separating the field into the "".

Thanks

1 reply

null
    • Sean
    • 3 yrs ago
    • Reported - view

    Hi Mateo,

     

    You can use the item() function. If the code is in a Formula field...

     

    item('JSON Records', 0).'N. de llicència'

     

    to get the first field of the first record. Just change the field name to get a different field and change 0 to 1 to get the second record. If the code is in a Text field, you will need to use the parseJSON() function...

     

    item(parseJSON('JSON Record Text'), 0).'N. de llicència'

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 1Replies
  • 179Views