Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Removing Non-ASCII characters

  1. #1

    Default Removing Non-ASCII characters

    Is there a way to remove all non-ASCII characters (greater than 127) in a text file through Kettle ?
    I checked the forums and didn't see anything that might help.

  2. #2


    Even better is there a way to convert from Unicode to ASCII for a specific field in a text file ?

  3. #3


    have a look at the plugin Asciify



  4. #4
    DEinspanjer Guest


    The Asciify plugin will do what you asked in your first question. Replace anything > 127 with a question mark. One thing to keep in mind if you use it, you'll have to set the KETTLE_PLUGIN_PACKAGES variable to make sure that the plugin gets loaded into Kettle.

    on Linux
    export KETTLE_PLUGIN_PACKAGES=com.illunus
    or for Windows
    set KETTLE_PLUGIN_PACKAGES=com.illunus

    in a shell window before you run Spoon/Kitchen/Pan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.