Edit and cut the json output of a node

Questions
,
1

Describe the issue/error/question

Hello friends, my problem is the following: I am trying to visualize a qr code that I receive in base64 format, I have almost everything ready but the problem is that the node that gives me the qr code does not include the clean base64 code, that is, the base64 code It comes with some words and symbols at the beginning that generate a conflict to display the image in the next node.

So I need to exclude the words and symbols that generate this conflict for me.

The output of my node is:

data:image/png;base64,{code_qr_on_base64}

And I need to remove:

“data:image/png;base64,”

To leave only:

{code_qr_on_base64}

Share the output returned by the last node

[

{

“qrCode”:“data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARQAAAEUCAYAAADqcMl5AAAAAklEQVR4AewaftIAABIASURBVO3BQW7oyrLgQFLw/rfMPsMcFSCo7Pt+IyPsH9Za64KHtda65GGttS55WGutSx7WWuuSh7XWuuRhrbUueVhrrUse1lrrkoe11rrkYa21LnlYa61LHtZa65KHtda65GGttS55WGutS374SOUvVUwqJxWTyknFicpJxRsqU8WJyknFGypTxaRyUvGGylQxqUwVk8pUMamcVNykMlWcqJxUTCp/qeKLh7XWuuRhrbUueVhrrUt+uKziJpW/pPKFyknFVPFGxRsqU8WJyknFpDJVTCpTxaQyVXxRcaIyVZyovKEyVdxUcZPKTQ9rrXXJw1prXfKw1lqX/PDLVN6oeKPiRGWq+Esqk8pUMalMFTepTBWTylRxUjGpTBWTylRxojJVTCpvVEwqJxWTyhsqv0nljYrf9LDWWpc8rLXWJQ9rrXXJD//HqZxUvKEyVUwqJxUnFb9JZao4UTlRmSreUDlRmSreqPiiYlKZVG6qmFT+f/Kw1lqXPKy11iUPa611yQ//x1V8oXKiMlW8UTGpfKEyVfwllZsqJpWp4guVk4ovKiaVE5Wp4v8nD2utdcnDWmtd8rDWWpf88Msq/pLKVPFFxYnKVPFGxf+SijdUpopJZaqYVN5QmSpOKk5UpopJ5Y2KSWWquKnif8nDWmtd8rDWWpc8rLXWJT9cpvKXVKaKSWWqOKmYVKaKN1SmikllqphUpopJZaqYVKaKN1Smit9UMalMFZPKVDGpTBVfVEwqU8UbKlPFicr/soe11rrkYa21LnlYa61L7B/+D1M5qfhC5aaKL1SmijdUTireUPmiYlI5qZhUpooTlTcqJpUvKiaVqeL/soe11rrkYa21LnlYa61LfvhIZaqYVE4qJpU3KiaVN1S+qJhUpopJ5aRiUjlRmSpOKiaVSeWLiknli4pJ5UTlpOJE5Y2KSeVE5Q2VqeJEZaqYVE4qvnhYa61LHtZa65KHtda6xP7hA5WTiknlpOINlaniRGWqmFSmiptUpoo3VE4qJpWTiknlpOImlZOKL1ROKr5QOal4Q+WLiv/Sw1prXfKw1lqXPKy11iU/XFYxqXyhclIxqXxRMamcVJyonKicVEwVJypTxU0qb1S8UXGiMlW8UXGiclLxmyreUJlUTip+08Naa13ysNZalzystdYl9g//Q1SmiknlpopJZaqYVE4qvlB5o+INlTcqJpWpYlI5qZhUTiomlaniRGWqOFE5qThR+UsVk8obFTc9rLXWJQ9rrXXJw1prXWL/8ItUpooTlZOKSeWNit+k8kbFicpUMalMFScqX1RMKlPFpPKbKk5UTiomlaliUjmpOFE5qZhUTipOVN6o+OJhrbUueVhrrUse1lrrkh8+UnlD5Y2KSWWqOFE5UZkq3lCZKiaVE5Wp4guVqeKkYlJ5o2JSmSomlaniRGWqmFSmiqliUvmiYlKZVN6oOKl4Q2WqmFSmipse1lrrkoe11rrkYa21LrF/+B+mclIxqdxUcaJyUnGiclPFFypvVHyhMlVMKm9UvKEyVUwqU8Wk8kbFGypTxRsqJxU3Pay11iUPa611ycNaa13ywy9TmSomlaliqnijYlI5qThRmSpOKv5SxaQyVdxUcaLymypOVN6oOKl4o+KmiknlpGKq+EsPa611ycNaa13ysNZal/zwkcpUMVWcVJyo/CWVE5Wp4jdVnKicqLxRcaJyUnGiMlVMKlPFTRWTyhcVk8pUcaJyUnGTylRx08Naa13ysNZalzystdYl9g+/SOWLihOVqWJSmSpOVKaKL1SmiknlpOJE5aTiROWk4kTli4o3VN6oeEPljYo3VE4qblJ5o+KLh7XWuuRhrbUueVhrrUt++EhlqpgqJpU3VN5QmSomlaniJpWpYlKZKiaVLyr+UsUXKlPFpHJScaIyVfwmlS9Upoo3VE4qJpWbHtZa65KHtda65GGttS754ZepfFHxhsqkMlWcVHxRcVIxqUwVX6i8UfGGyknFpHJSMancVPFFxW+qmFROVKaKk4qTipse1lrrkoe11rrkYa21LrF/+EDlpOJEZaqYVKaKSWWqmFROKiaVqWJSeaPiRGWqOFGZKiaVqWJSmSomlZsqJpWp4kTli4pJZap4Q2WqOFGZKt5QOak4UZkqJpWp4ouHtda65GGttS55WGutS374qGJSmVROKiaVqWJSmSpuqphUTiomlROVN1Smii8q3qiYVKaKm1SmikllqphUJpW/pDJVvKFyUjGpTBVTxaQyVdz0sNZalzystdYlD2utdckPH6lMFZPKVPGGylQxqbxR8UXFScWkMlWcqJyonFRMKicVJyonKlPFpHKiMlX8l1SmiqliUpkqJpWpYlKZKiaVSeUNlaniNz2stdYlD2utdcnDWmtdYv/wgcpvqvhC5aTiROWk4guVLyomlaniROWmikllqjhRmSpuUjmpmFTeqDhR+V9W8cXDWmtd8rDWWpc8rLXWJfYPv0hlqphU3qiYVKaKL1TeqJhUTiomlaliUvmi4guVk4o3VN6omFSmiknljYovVE4q3lCZKiaVqeILlanii4e11rrkYa21LnlYa61LfrhMZap4o+JE5QuVk4oTlUllqphUTipOKiaVqWJS+ULlpGJSmSreqDhR+aLiJpU3VE4qpoqbVP7Sw1prXfKw1lqXPKy11iU/XFYxqUwVJypfqEwVJxVvVLxRcaIyVUwqb1RMKicVU8UXKicVb1RMKl+ofFExqfwmlTdUpopJZaq46WGttS55WGutSx7WWuuSHz5S+aJiUpkq3lA5qThR+U0VU8VJxYnKVDFVfKEyVbxR8YbKVHGicqLyRsUXFScqk8pU8UXFf+lhrbUueVhrrUse1lrrEvuHi1SmiknlL1V8ofJFxaQyVdykclIxqfyXKiaVNyomlS8qblL5SxWTylQxqUwVXzystdYlD2utdcnDWmtdYv/wh1ROKt5QmSq+UJkqJpWp4g2VmyreUDmpeEPli4o3VN6oOFG5qeJE5aTiDZWbKr54WGutSx7WWuuSh7XWuuSHy1ROKiaVE5Wp4g2VqWJSmSomlaniROWNikllqvgvqUwVb1RMKicqb1ScqEwVU8WkMlWcqEwqU8UXKlPFFxWTyk0Pa611ycNaa13ysNZal/zwkcobKm9UvKFyovJGxRcVk8pJxRcqU8VUMamcVLxRMamcqEwVb6icVHyhclIxqZxUTConFV9UTCq/6WGttS55WGutSx7WWusS+4c/pPKbKiaVqeILlZsq3lCZKr5Q+S9VTCpTxaRyUjGpnFRMKlPFpDJVvKHylyomlanipoe11rrkYa21LnlYa61LfvgfU3GiMlVMKlPFpDJVTConFV+ovKFyojJVTCpfVEwqJxW/qeJE5aTipOKk4kRlqjipeENlqjhRmSomlanii4e11rrkYa21LnlYa61L7B8uUjmpmFTeqJhUTiq+UDmpmFSmiknli4pJZap4Q+WkYlKZKt5QmSomlaniRGWqOFGZKk5U/lLFGyonFX/pYa21LnlYa61LHtZa65IfPlKZKiaVLyreqDhReaPiN1XcpDJVvFFxk8pUcVLxhcpU8YbKVDGp/CaVm1ROKm56WGutSx7WWuuSh7XWuuSH/1jFicpUcaIyVZxUnKh8oTJVTCpTxW9SOVE5qThRmSomlaliUpkq3qiYVE5UpoqTikllqjhRmSr+ksqkMlV88bDWWpc8rLXWJQ9rrXXJD5epTBWTyhsVk8p/qeINlZOKSeWkYqqYVCaVk4pJZar4TSonKlPFGxVvqEwVJxUnKlPFpDJVnKicVJxU/KaHtda65GGttS55WGutS374qOKNikllqphU3qh4Q2WqOFE5qfgvVUwqU8WkMlVMKlPFpHKicpPKVPGFylQxqUwVk8pU8UbFpDJVnFScqLxR8cXDWmtd8rDWWpc8rLXWJfYPF6lMFZPKScWJylRxonJS8YbKVDGpvFFxovJGxaQyVUwqX1RMKlPFTSpTxaRyU8UbKlPFpPKXKk5UpoovHtZa65KHtda65GGttS754SOVE5WpYlI5UflNKm9UTCpvVEwqX1RMKlPFpDJVvKFyUjGpTBUnKlPFFxUnKlPFFxUnFZPKVPGGyonKScVND2utdcnDWmtd8rDWWpf88MsqJpU3Kk5UpoqTikllqjhROal4o+INlUnlv6TyhcoXKl9UTCpfVJyonKicVEwVJypTxW96WGutSx7WWuuSh7XWusT+4Rep3FRxojJVnKh8UXGi8kXFTSpTxaRyU8WJyhcVk8obFZPKScUbKlPFicpJxaRyU8UXD2utdcnDWmtd8rDWWpf88JHKScWJyknFicpUMalMFScVk8pUcaIyVUwqN6lMFScVk8pJxaTyhspU8UbFpDKpTBWTyonKFypTxRsqU8WJyhsVJyo3Pay11iUPa611ycNaa11i//CBylTxhspUMalMFW+o/KaKE5WTiknli4oTlTcqJpWp4g2VqWJSOamYVKaKSWWq+EJlqrhJZar4QuWk4qaHtda65GGttS55WGutS+wfLlK5qWJSmSreUHmj4g2Vk4oTlaliUvkvVUwqU8WkMlWcqJxUnKhMFScqU8Wk8kXFicpUMamcVEwqU8VfelhrrUse1lrrkoe11rrE/uEDlS8qJpWTihOVk4pJ5aaKL1T+UsWkMlVMKlPFb1I5qZhUpopJ5aTiROWkYlI5qbhJZar4Sw9rrXXJw1prXfKw1lqX/HBZxYnKGxVfVPyXVKaKSeWNihOV31TxhspfqphU3lA5qZhUTiq+UDmpmComlaniNz2stdYlD2utdcnDWmtdYv/wgcpUcaJyUjGpnFS8oXJS8YbKVHGi8kXFicpU8YXKScUXKlPFFypvVJyofFExqZxUnKicVEwqb1R88bDWWpc8rLXWJQ9rrXWJ/cMfUjmpOFGZKk5UvqiYVKaKN1TeqHhDZaqYVE4q3lA5qXhD5Y2KN1TeqJhUvqiYVE4qJpU3Kv7Sw1prXfKw1lqXPKy11iU//DKVN1RuqnhD5aRiUpkq3qiYVCaVk4o3KiaVE5WpYqp4Q+WNihOVNyreUPlfVnGiclJx08Naa13ysNZalzystdYlP3yk8kbFpDJVnKicqJxUvKEyVZyoTBUnKicVk8qk8obKVHGTylRxUjGpfFExqZyoTBUnFZPKScWkclJxUvFGxaQyqUwVXzystdYlD2utdcnDWmtdYv/wgcoXFScqU8WkclIxqUwVk8pUcaLyRsUXKl9UTCq/qeINlaniJpU3Kt5QOamYVG6qOFGZKm56WGutSx7WWuuSh7XWuuSHjyp+U8UXKlPFScUbFV+onFScVEwqJyonFW+oTBWTylTxhcobFV+onFRMFV9UvKHyv+RhrbUueVhrrUse1lrrkh8+UvlLFScVk8qkMlWcqJxUnKi8UTGpnKhMFZPKVDGpnKhMFV+ovKFyUjGpvFExqZxUfKHyhspUcaIyVZyoTBVfPKy11iUPa611ycNaa13yw2UVN6l8UfGXVKaKmyr+UsUXFTepnFS8oTJVTCqTylRxovJFxf8lD2utdcnDWmtd8rDWWpf88MtU3qh4o+JE5aRiUpkqTlTeUPlCZao4qXhD5SaVqeINlaliUpkqJpWTikllqphUTlROKiaVSeWLipOKSeWmh7XWuuRhrbUueVhrrUt++D9OZao4qZhUTlSmipOKSeWk4kTlROWLiknljYpJZaqYVN6oOKmYVH5TxRsVk8pUMal8oTJV/KWHtda65GGttS55WGutS374/4zKicpJxaRyUvFGxYnKScUbKl9UnKhMFZPKScWJylRxUvGGyonKVDGpTBWTyk0Vk8pUcaIyVdz0sNZalzystdYlD2utdYn9wwcqU8VNKlPFFypTxYnKVDGpfFHxhcpU8YbKb6qYVG6qmFSmikllqvhLKlPFpDJVTCpTxaRyUvGbHtZa65KHtda65GGttS754TKVv6QyVfwmlaliUnlDZaqYVH5TxaTyRsUbFZPKScWk8obKTSpvVEwVJxUnFZPKGyonFV88rLXWJQ9rrXXJw1prXWL/sNZaFzystdYlD2utdcnDWmtd8rDWWpc8rLXWJQ9rrXXJw1prXfKw1lqXPKy11iUPa611ycNaa13ysNZalzystdYlD2utdcnDWmtd8v8AnDtqUOotuOwAAAAASUVORK5CYII=”

}

]

This is how the output looks on my screen and I marked in red what I need to delete so that it does not give me problems when viewing the image

cut
cut1417×604 112 KB

Information on your n8n setup

  • 0.202.1
  • Running n8n via Docker
2

You should just be able to do a replace on the string


return [
  {
  json: {
    
  },
  binary: {
    data: {
      data: $json["qrCode"].replace("data:image/png;base64,", ""),
      mimeType: "image/jpeg",
      fileExtension: 'jpeg',
      fileName: "qrcode.jpeg"
    }
  }
  }
]
2 Likes
3

Thank you very much, its working :blush:

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.