https://community.qlik.com/t5/Talend-Studio/How-to-convert-EBCDIC-file-to-ASCII/m-p/2245510#M31349 <DIV class="lia-message-subject lia-component-message-view-widget-subject"> <DIV class="MessageSubject"> <SPAN>I'm trying to convert EBCDIC to ASCII using Data Mapper.</SPAN> </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> I have created a structure using COBOL copybook with FLAT representation, created output structure with CSV representation. </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> In Data Integration, I have created a new job with tfileinputraw, thmap, tfileoutputraw and executed the job. I still see special characters in the output csv file. I want to convert the EBCDIC format data into ASCII so that I can use it with other file which are in ASCII format. </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JOB.PNG" style="width: 570px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaAk.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151941iBC787D45C72235F7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaAk.png" alt="0683p000009MaAk.png" /></span></SPAN> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="EBCDIC_Structure.PNG" style="width: 299px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Maag.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157181i6F15B973964E988B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Maag.png" alt="0683p000009Maag.png" /></span></SPAN> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MAp.PNG" style="width: 773px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Maal.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140676iCF4272F0BAE42C04/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Maal.png" alt="0683p000009Maal.png" /></span></SPAN> </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> Can someone help me understand if I'm missing something or let me know what should I do to convert to ASCII. </DIV> </DIV> <DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <BR />Thanks. </DIV> </DIV> Sat, 16 Nov 2024 02:00:00 GMT vpachu 2024-11-16T02:00:00Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-EBCDIC-file-to-ASCII/m-p/2245510#M31349 <DIV class="lia-message-subject lia-component-message-view-widget-subject"> <DIV class="MessageSubject"> <SPAN>I'm trying to convert EBCDIC to ASCII using Data Mapper.</SPAN> </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> I have created a structure using COBOL copybook with FLAT representation, created output structure with CSV representation. </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> In Data Integration, I have created a new job with tfileinputraw, thmap, tfileoutputraw and executed the job. I still see special characters in the output csv file. I want to convert the EBCDIC format data into ASCII so that I can use it with other file which are in ASCII format. </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JOB.PNG" style="width: 570px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MaAk.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151941iBC787D45C72235F7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MaAk.png" alt="0683p000009MaAk.png" /></span></SPAN> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="EBCDIC_Structure.PNG" style="width: 299px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Maag.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157181i6F15B973964E988B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Maag.png" alt="0683p000009Maag.png" /></span></SPAN> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MAp.PNG" style="width: 773px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Maal.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140676iCF4272F0BAE42C04/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Maal.png" alt="0683p000009Maal.png" /></span></SPAN> </DIV> <DIV class="MessageSubject"> &nbsp; </DIV> <DIV class="MessageSubject"> Can someone help me understand if I'm missing something or let me know what should I do to convert to ASCII. </DIV> </DIV> <DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <BR />Thanks. </DIV> </DIV> Sat, 16 Nov 2024 02:00:00 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-EBCDIC-file-to-ASCII/m-p/2245510#M31349 vpachu 2024-11-16T02:00:00Z