https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225115#M60798 Tue, 09 May 2017 22:41:59 GMT guha 2017-05-09T22:41:59Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225115#M60798 Tue, 09 May 2017 22:41:59 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225115#M60798 guha 2017-05-09T22:41:59Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225116#M60799 <P><A rel="user" href="https://community.cloudera.com/users/18061/guha.html" nodeid="18061" target="_blank">@Prabir Guha</A></P><P>You can use the replaceText processor to replace tabs with commas in a text/plain input file.</P><P>lets assume my input file's content has the following value: </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="15259-screen-shot-2017-05-09-at-115146-am.png" style="width: 404px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15438iFB7937B94AFA2A4A/image-size/medium?v=v2&amp;px=400" role="button" title="15259-screen-shot-2017-05-09-at-115146-am.png" alt="15259-screen-shot-2017-05-09-at-115146-am.png" /></span></P><P>I could then configure my replaceText processor to do teh following:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="15258-screen-shot-2017-05-09-at-114958-am.png" style="width: 601px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15439i4FDBE660800D6FFF/image-size/medium?v=v2&amp;px=400" role="button" title="15258-screen-shot-2017-05-09-at-114958-am.png" alt="15258-screen-shot-2017-05-09-at-114958-am.png" /></span></P><P>The Search Value is set to a tab.</P><P>The Replacement Value is set to a comma.</P><P>The resulting content is:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="15260-screen-shot-2017-05-09-at-115249-am.png" style="width: 338px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15440i451DC2B988D64778/image-size/medium?v=v2&amp;px=400" role="button" title="15260-screen-shot-2017-05-09-at-115249-am.png" alt="15260-screen-shot-2017-05-09-at-115249-am.png" /></span></P><P>Thanks,</P><P>Matt</P> Sun, 18 Aug 2019 01:36:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225116#M60799 MattWho 2019-08-18T01:36:53Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225117#M60800 <P>@Matt Clarke "The Search Value is set to a tab." How should the search value TAB be set? '\t' or 0x09 </P> Tue, 09 May 2017 22:59:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225117#M60800 guha 2017-05-09T22:59:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225118#M60801 <P>I literally hit the "tab" key on my keyboard.</P> Tue, 09 May 2017 23:05:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-best-to-replace-all-TABs-t-by-COMMAs-in-the-content-of-a/m-p/225118#M60801 MattWho 2017-05-09T23:05:58Z