Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Removing weird characters like † from a string.

  1. #1
    Join Date
    Oct 2011

    Default Removing weird characters like † from a string.

    I'm just wondering how to remove characters such as † from a string. I have to remove excess spaces and 'normal' weird chars like * quite often in my transformations, however the † stumped me.

  2. #2
    Join Date
    Nov 2008


    Try using the Replace In String step with a regex expression of \u2020 for the Search parameter. It looks like 2020 (hex) is the code for the Dagger character, at least in the Windows 1252 Character Set.
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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.