Hitachi Vantara Pentaho Community Forums
Results 1 to 12 of 12

Thread: Regex to check for special char at the end of the string.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Regex to check for special char at the end of the string.

    Hi,

    I want to remove non printing char from the end of the string using regex please help. how this can be done.

    Thanks,
    Nishank

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Name:  RIS.png
Views: 156
Size:  17.7 KB
    So long, and thanks for all the fish.

  3. #3

    Default

    Hi Marabu,

    Thanks for your quick response.


    How to identify a non printing character?

    Please
    Can you give me one example.
    And How to open a file in pentaho with non printing character is there any encoding required?

    Thanks,
    Nishank

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by Nishank Goel View Post
    How to identify a non printing character?
    You asked the same question in your opening post, only more precise: How to (identify and) remove unprintable characters at the end of a string via Regular Expression.
    At least, that's what I understood.

    Quote Originally Posted by Nishank Goel View Post
    And How to open a file in pentaho with non printing character is there any encoding required?
    You should use the encoding the originator of the file expects you to use.
    So long, and thanks for all the fish.

  5. #5

    Default

    [(^\p{print}]*)$ this is the regex u have given me as a new user I dont know how to search for that particular non printing value.Is there some ascii value required? Can you give me example on this?

    Here we have a lot of encoding options are present. Which is the most suitable.

    Thanks,

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    That RE is ready to use

    And you don't just pick one of the available encodings, you ask the creator of the file which one you're supposed to use.
    So long, and thanks for all the fish.

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.