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
    Posts
    3

    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
    Posts
    777

    Default

    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.
    pdi-ce-4.4.0-stable
    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.