ok, it somewhat helped. I used "latin1" instead of base64 which was able to convert the data to string characters for me. Just now the seperation? I used a csv node but when I try to seperate it using the semicolon(; )/comma(,) it doesn't work. Instead the server will lose connection. So how could I better do the relevant data extraction. Is another program more relevant??
Current code:
[{"id":"aec7375b.582a88","type":"e-mail in","z":"a3693599.be25b8","name":"","protocol":"IMAP","server":"imap.gmail.com","useSSL":true,"port":"993","box":"INBOX","disposition":"Read","repeat":"60","x":170,"y":220,"wires":[["74ef9fed.0b6aa","44ff2d6d.f70a74"]]},{"id":"74ef9fed.0b6aa","type":"function","z":"a3693599.be25b8","name":"","func":"msg.payload=msg.attachments[0].content.toString('latin1');\nreturn msg;","outputs":1,"noerr":0,"x":290,"y":280,"wires":[["44ff2d6d.f70a74","e97fb838.ecde98"]]},{"id":"44ff2d6d.f70a74","type":"debug","z":"a3693599.be25b8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":550,"y":220,"wires":[]},{"id":"e97fb838.ecde98","type":"csv","z":"a3693599.be25b8","name":"","sep":";","hdrin":"","hdrout":"","multi":"one","ret":"\\n","temp":"TIMESTAMP_UTC [s],DATE_UTC,I_L1 [A],I_L2 [A],I_L3 [A],I_N [A],U_L1 [V],U_L2 [V],U_L3 [V],PF_L1 [-],PF_L2 [-],PF_L3 [-],P_L1 [W],P_L2 [W],P_L3 [W],Q_L1 [Var],Q_L2 [Var],Q_L3 [Var],S_L1 [VA],S_L2 [VA],S_L3 [VA],P3P [W],P3PP [Var],P3PA [VA],E_L1 [Wh],E_L2 [Wh],E_L3 [Wh],EP_L1 [Varh],EP_L2 [Varh],EP_L3 [Varh],EA_L1 [VAh],EA_L2 [VAh],EA_L3 [VAh],E3P [Wh],E3PP [Varh],E3PA [VAh],THD_I_L1 [%],THD_I_L2 [%],THD_I_L3 [%],THD_I_N [%],THD_U_L1 [%],THD_U_L2 [%],THD_U_L3 [%],E_ID1 [Wh],E_ID2 [Wh],E_ID3 [Wh],E_ID4 [Wh],E_ID5 [Wh],E_ID6 [Wh],E_ID7 [Wh],E_ID8 [Wh],E_ID9 [Wh],E_ID10 [Wh],E_ID11 [Wh],E_ID12 [Wh],E_ID13 [Wh],E_ID14 [Wh],E_ID15 [Wh],E_ID16 [Wh],E_ID17 [Wh],E_ID18 [Wh],E_ID19 [Wh],E_ID20 [Wh],E_ID21 [Wh],E_ID22 [Wh],E_ID23 [Wh],E_ID24 [Wh],E_ID25 [Wh],E_ID26 [Wh],E_ID27 [Wh],E_ID28 [Wh],E_ID29 [Wh],E_ID30 [Wh],E_ID31 [Wh],E_ID32 [Wh],E_ID33 [Wh],E_ID34 [Wh],E_ID35 [Wh],E_ID36 [Wh],E_ID37 [Wh],E_ID38 [Wh],E_ID39 [Wh],E_ID40 [Wh],E_ID41 [Wh],E_ID42 [Wh],E_ID43 [Wh],E_ID44 [Wh],E_ID45 [Wh],E_ID46 [Wh],E_ID47 [Wh],E_ID48 [Wh],E_ID49 [Wh],E_ID50 [Wh],E_ID51 [Wh],E_ID52 [Wh],E_ID53 [Wh],E_ID54 [Wh],E_ID55 [Wh],E_ID56 [Wh],E_ID57 [Wh],E_ID58 [Wh],E_ID59 [Wh],E_ID60 [Wh],E_ID61 [Wh],E_ID62 [Wh],E_ID63 [Wh],E_ID64 [Wh],E_ID65 [Wh],E_ID66 [Wh],E_ID67 [Wh],E_ID68 [Wh],E_ID69 [Wh],E_ID70 [Wh],E_ID71 [Wh],E_ID72 [Wh],E_ID73 [Wh],E_ID74 [Wh],E_ID75 [Wh],E_ID76 [Wh],E_ID77 [Wh],E_ID78 [Wh],E_ID79 [Wh],E_ID80 [Wh],E_ID81 [Wh],E_ID82 [Wh],E_ID83 [Wh],E_ID84 [Wh],E_ID85 [Wh],E_ID86 [Wh],E_ID87 [Wh],E_ID88 [Wh],E_ID89 [Wh],E_ID90 [Wh],E_ID91 [Wh],E_ID92 [Wh],E_ID93 [Wh],E_ID94 [Wh],E_ID95 [Wh],E_ID96 [Wh],E_ID97 [Wh],E_ID98 [Wh],E_ID99 [Wh],E_ID100 [Wh],E_ID101 [Wh],E_ID102 [Wh],E_ID103 [Wh],E_ID104 [Wh],E_ID105 [Wh],E_ID106 [Wh],E_ID107 [Wh],E_ID108 [Wh],E_ID109 [Wh],E_ID110 [Wh],E_ID111 [Wh],E_ID112 [Wh],E_ID113 [Wh],E_ID114 [Wh],E_ID115 [Wh],E_ID116 [Wh],E_ID117 [Wh],E_ID118 [Wh],E_ID119 [Wh],E_ID120 [Wh],E_ID121 [Wh],E_ID122 [Wh],E_ID123 [Wh],E_ID124 [Wh],E_ID125 [Wh],E_ID126 [Wh],E_ID127 [Wh],E_ID128 [Wh],I_TRMS_ID1 [A],I_TRMS_ID2 [A],I_TRMS_ID3 [A],I_TRMS_ID4 [A],I_TRMS_ID5 [A],I_TRMS_ID6 [A],I_TRMS_ID7 [A],I_TRMS_ID8 [A],I_TRMS_ID9 [A],I_TRMS_ID10 [A],I_TRMS_ID11 [A],I_TRMS_ID12 [A],I_TRMS_ID13 [A],I_TRMS_ID14 [A],I_TRMS_ID15 [A],I_TRMS_ID16 [A],I_TRMS_ID17 [A],I_TRMS_ID18 [A],I_TRMS_ID19 [A],I_TRMS_ID20 [A],I_TRMS_ID21 [A],I_TRMS_ID22 [A],I_TRMS_ID23 [A],I_TRMS_ID24 [A],I_TRMS_ID25 [A],I_TRMS_ID26 [A],I_TRMS_ID27 [A],I_TRMS_ID28 [A],I_TRMS_ID29 [A],I_TRMS_ID30 [A],I_TRMS_ID31 [A],I_TRMS_ID32 [A],I_TRMS_ID33 [A],I_TRMS_ID34 [A],I_TRMS_ID35 [A],I_TRMS_ID36 [A],I_TRMS_ID37 [A],I_TRMS_ID38 [A],I_TRMS_ID39 [A],I_TRMS_ID40 [A],I_TRMS_ID41 [A],I_TRMS_ID42 [A],I_TRMS_ID43 [A],I_TRMS_ID44 [A],I_TRMS_ID45 [A],I_TRMS_ID46 [A],I_TRMS_ID47 [A],I_TRMS_ID48 [A],I_TRMS_ID49 [A],I_TRMS_ID50 [A],I_TRMS_ID51 [A],I_TRMS_ID52 [A],I_TRMS_ID53 [A],I_TRMS_ID54 [A],I_TRMS_ID55 [A],I_TRMS_ID56 [A],I_TRMS_ID57 [A],I_TRMS_ID58 [A],I_TRMS_ID59 [A],I_TRMS_ID60 [A],I_TRMS_ID61 [A],I_TRMS_ID62 [A],I_TRMS_ID63 [A],I_TRMS_ID64 [A],I_TRMS_ID65 [A],I_TRMS_ID66 [A],I_TRMS_ID67 [A],I_TRMS_ID68 [A],I_TRMS_ID69 [A],I_TRMS_ID70 [A],I_TRMS_ID71 [A],I_TRMS_ID72 [A],I_TRMS_ID73 [A],I_TRMS_ID74 [A],I_TRMS_ID75 [A],I_TRMS_ID76 [A],I_TRMS_ID77 [A],I_TRMS_ID78 [A],I_TRMS_ID79 [A],I_TRMS_ID80 [A],I_TRMS_ID81 [A],I_TRMS_ID82 [A],I_TRMS_ID83 [A],I_TRMS_ID84 [A],I_TRMS_ID85 [A],I_TRMS_ID86 [A],I_TRMS_ID87 [A],I_TRMS_ID88 [A],I_TRMS_ID89 [A],I_TRMS_ID90 [A],I_TRMS_ID91 [A],I_TRMS_ID92 [A],I_TRMS_ID93 [A],I_TRMS_ID94 [A],I_TRMS_ID95 [A],I_TRMS_ID96 [A],I_TRMS_ID97 [A],I_TRMS_ID98 [A],I_TRMS_ID99 [A],I_TRMS_ID100 [A],I_TRMS_ID101 [A],I_TRMS_ID102 [A],I_TRMS_ID103 [A],I_TRMS_ID104 [A],I_TRMS_ID105 [A],I_TRMS_ID106 [A],I_TRMS_ID107 [A],I_TRMS_ID108 [A],I_TRMS_ID109 [A],I_TRMS_ID110 [A],I_TRMS_ID111 [A],I_TRMS_ID112 [A],I_TRMS_ID113 [A],I_TRMS_ID114 [A],I_TRMS_ID115 [A],I_TRMS_ID116 [A],I_TRMS_ID117 [A],I_TRMS_ID118 [A],I_TRMS_ID119 [A],I_TRMS_ID120 [A],I_TRMS_ID121 [A],I_TRMS_ID122 [A],I_TRMS_ID123 [A],I_TRMS_ID124 [A],I_TRMS_ID125 [A],I_TRMS_ID126 [A],I_TRMS_ID127 [A],I_TRMS_ID128 [A],I_AC_ID1 [A],I_AC_ID2 [A],I_AC_ID3 [A],I_AC_ID4 [A],I_AC_ID5 [A],I_AC_ID6 [A],I_AC_ID7 [A],I_AC_ID8 [A],I_AC_ID9 [A],I_AC_ID10 [A],I_AC_ID11 [A],I_AC_ID12 [A],I_AC_ID13 [A],I_AC_ID14 [A],I_AC_ID15 [A],I_AC_ID16 [A],I_AC_ID17 [A],I_AC_ID18 [A],I_AC_ID19 [A],I_AC_ID20 [A],I_AC_ID21 [A],I_AC_ID22 [A],I_AC_ID23 [A],I_AC_ID24 [A],I_AC_ID25 [A],I_AC_ID26 [A],I_AC_ID27 [A],I_AC_ID28 [A],I_AC_ID29 [A],I_AC_ID30 [A],I_AC_ID31 [A],I_AC_ID32 [A],I_AC_ID33 [A],I_AC_ID34 [A],I_AC_ID35 [A],I_AC_ID36 [A],I_AC_ID37 [A],I_AC_ID38 [A],I_AC_ID39 [A],I_AC_ID40 [A],I_AC_ID41 [A],I_AC_ID42 [A],I_AC_ID43 [A],I_AC_ID44 [A],I_AC_ID45 [A],I_AC_ID46 [A],I_AC_ID47 [A],I_AC_ID48 [A],I_AC_ID49 [A],I_AC_ID50 [A],I_AC_ID51 [A],I_AC_ID52 [A],I_AC_ID53 [A],I_AC_ID54 [A],I_AC_ID55 [A],I_AC_ID56 [A],I_AC_ID57 [A],I_AC_ID58 [A],I_AC_ID59 [A],I_AC_ID60 [A],I_AC_ID61 [A],I_AC_ID62 [A],I_AC_ID63 [A],I_AC_ID64 [A],I_AC_ID65 [A],I_AC_ID66 [A],I_AC_ID67 [A],I_AC_ID68 [A],I_AC_ID69 [A],I_AC_ID70 [A],I_AC_ID71 [A],I_AC_ID72 [A],I_AC_ID73 [A],I_AC_ID74 [A],I_AC_ID75 [A],I_AC_ID76 [A],I_AC_ID77 [A],I_AC_ID78 [A],I_AC_ID79 [A],I_AC_ID80 [A],I_AC_ID81 [A],I_AC_ID82 [A],I_AC_ID83 [A],I_AC_ID84 [A],I_AC_ID85 [A],I_AC_ID86 [A],I_AC_ID87 [A],I_AC_ID88 [A],I_AC_ID89 [A],I_AC_ID90 [A],I_AC_ID91 [A],I_AC_ID92 [A],I_AC_ID93 [A],I_AC_ID94 [A],I_AC_ID95 [A],I_AC_ID96 [A],I_AC_ID97 [A],I_AC_ID98 [A],I_AC_ID99 [A],I_AC_ID100 [A],I_AC_ID101 [A],I_AC_ID102 [A],I_AC_ID103 [A],I_AC_ID104 [A],I_AC_ID105 [A],I_AC_ID106 [A],I_AC_ID107 [A],I_AC_ID108 [A],I_AC_ID109 [A],I_AC_ID110 [A],I_AC_ID111 [A],I_AC_ID112 [A],I_AC_ID113 [A],I_AC_ID114 [A],I_AC_ID115 [A],I_AC_ID116 [A],I_AC_ID117 [A],I_AC_ID118 [A],I_AC_ID119 [A],I_AC_ID120 [A],I_AC_ID121 [A],I_AC_ID122 [A],I_AC_ID123 [A],I_AC_ID124 [A],I_AC_ID125 [A],I_AC_ID126 [A],I_AC_ID127 [A],I_AC_ID128 [A],I_DC_ID1 [A],I_DC_ID2 [A],I_DC_ID3 [A],I_DC_ID4 [A],I_DC_ID5 [A],I_DC_ID6 [A],I_DC_ID7 [A],I_DC_ID8 [A],I_DC_ID9 [A],I_DC_ID10 [A],I_DC_ID11 [A],I_DC_ID12 [A],I_DC_ID13 [A],I_DC_ID14 [A],I_DC_ID15 [A],I_DC_ID16 [A],I_DC_ID17 [A],I_DC_ID18 [A],I_DC_ID19 [A],I_DC_ID20 [A],I_DC_ID21 [A],I_DC_ID22 [A],I_DC_ID23 [A],I_DC_ID24 [A],I_DC_ID25 [A],I_DC_ID26 [A],I_DC_ID27 [A],I_DC_ID28 [A],I_DC_ID29 [A],I_DC_ID30 [A],I_DC_ID31 [A],I_DC_ID32 [A],I_DC_ID33 [A],I_DC_ID34 [A],I_DC_ID35 [A],I_DC_ID36 [A],I_DC_ID37 [A],I_DC_ID38 [A],I_DC_ID39 [A],I_DC_ID40 [A],I_DC_ID41 [A],I_DC_ID42 [A],I_DC_ID43 [A],I_DC_ID44 [A],I_DC_ID45 [A],I_DC_ID46 [A],I_DC_ID47 [A],I_DC_ID48 [A],I_DC_ID49 [A],I_DC_ID50 [A],I_DC_ID51 [A],I_DC_ID52 [A],I_DC_ID53 [A],I_DC_ID54 [A],I_DC_ID55 [A],I_DC_ID56 [A],I_DC_ID57 [A],I_DC_ID58 [A],I_DC_ID59 [A],I_DC_ID60 [A],I_DC_ID61 [A],I_DC_ID62 [A],I_DC_ID63 [A],I_DC_ID64 [A],I_DC_ID65 [A],I_DC_ID66 [A],I_DC_ID67 [A],I_DC_ID68 [A],I_DC_ID69 [A],I_DC_ID70 [A],I_DC_ID71 [A],I_DC_ID72 [A],I_DC_ID73 [A],I_DC_ID74 [A],I_DC_ID75 [A],I_DC_ID76 [A],I_DC_ID77 [A],I_DC_ID78 [A],I_DC_ID79 [A],I_DC_ID80 [A],I_DC_ID81 [A],I_DC_ID82 [A],I_DC_ID83 [A],I_DC_ID84 [A],I_DC_ID85 [A],I_DC_ID86 [A],I_DC_ID87 [A],I_DC_ID88 [A],I_DC_ID89 [A],I_DC_ID90 [A],I_DC_ID91 [A],I_DC_ID92 [A],I_DC_ID93 [A],I_DC_ID94 [A],I_DC_ID95 [A],I_DC_ID96 [A],I_DC_ID97 [A],I_DC_ID98 [A],I_DC_ID99 [A],I_DC_ID100 [A],I_DC_ID101 [A],I_DC_ID102 [A],I_DC_ID103 [A],I_DC_ID104 [A],I_DC_ID105 [A],I_DC_ID106 [A],I_DC_ID107 [A],I_DC_ID108 [A],I_DC_ID109 [A],I_DC_ID110 [A],I_DC_ID111 [A],I_DC_ID112 [A],I_DC_ID113 [A],I_DC_ID114 [A],I_DC_ID115 [A],I_DC_ID116 [A],I_DC_ID117 [A],I_DC_ID118 [A],I_DC_ID119 [A],I_DC_ID120 [A],I_DC_ID121 [A],I_DC_ID122 [A],I_DC_ID123 [A],I_DC_ID124 [A],I_DC_ID125 [A],I_DC_ID126 [A],I_DC_ID127 [A],I_DC_ID128 [A],P_ID1 [W],P_ID2 [W],P_ID3 [W],P_ID4 [W],P_ID5 [W],P_ID6 [W],P_ID7 [W],P_ID8 [W],P_ID9 [W],P_ID10 [W],P_ID11 [W],P_ID12 [W],P_ID13 [W],P_ID14 [W],P_ID15 [W],P_ID16 [W],P_ID17 [W],P_ID18 [W],P_ID19 [W],P_ID20 [W],P_ID21 [W],P_ID22 [W],P_ID23 [W],P_ID24 [W],P_ID25 [W],P_ID26 [W],P_ID27 [W],P_ID28 [W],P_ID29 [W],P_ID30 [W],P_ID31 [W],P_ID32 [W],P_ID33 [W],P_ID34 [W],P_ID35 [W],P_ID36 [W],P_ID37 [W],P_ID38 [W],P_ID39 [W],P_ID40 [W],P_ID41 [W],P_ID42 [W],P_ID43 [W],P_ID44 [W],P_ID45 [W],P_ID46 [W],P_ID47 [W],P_ID48 [W],P_ID49 [W],P_ID50 [W],P_ID51 [W],P_ID52 [W],P_ID53 [W],P_ID54 [W],P_ID55 [W],P_ID56 [W],P_ID57 [W],P_ID58 [W],P_ID59 [W],P_ID60 [W],P_ID61 [W],P_ID62 [W],P_ID63 [W],P_ID64 [W],P_ID65 [W],P_ID66 [W],P_ID67 [W],P_ID68 [W],P_ID69 [W],P_ID70 [W],P_ID71 [W],P_ID72 [W],P_ID73 [W],P_ID74 [W],P_ID75 [W],P_ID76 [W],P_ID77 [W],P_ID78 [W],P_ID79 [W],P_ID80 [W],P_ID81 [W],P_ID82 [W],P_ID83 [W],P_ID84 [W],P_ID85 [W],P_ID86 [W],P_ID87 [W],P_ID88 [W],P_ID89 [W],P_ID90 [W],P_ID91 [W],P_ID92 [W],P_ID93 [W],P_ID94 [W],P_ID95 [W],P_ID96 [W],P_ID97 [W],P_ID98 [W],P_ID99 [W],P_ID100 [W],P_ID101 [W],P_ID102 [W],P_ID103 [W],P_ID104 [W],P_ID105 [W],P_ID106 [W],P_ID107 [W],P_ID108 [W],P_ID109 [W],P_ID110 [W],P_ID111 [W],P_ID112 [W],P_ID113 [W],P_ID114 [W],P_ID115 [W],P_ID116 [W],P_ID117 [W],P_ID118 [W],P_ID119 [W],P_ID120 [W],P_ID121 [W],P_ID122 [W],P_ID123 [W],P_ID124 [W],P_ID125 [W],P_ID126 [W],P_ID127 [W],P_ID128 [W],","skip":"0","x":370,"y":380,"wires":[["44ff2d6d.f70a74"]]}]
