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

    Default

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

  3. #3

    Default

    Hi
    have a look at the plugin Asciify
    here
    http://wiki.pentaho.com/display/EAI/...ation+Plug-Ins

    Rgds

    Samatar
    Samatar

  4. #4
    DEinspanjer Guest

    Default

    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.