Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to remove a line break from a table

  1. #1
    Join Date
    May 2017
    Posts
    2

    Default How to remove a line break from a table

    Hi All,

    I was assigned a task to remove line break from the table. First I need to know whether any line break exists or not. if the line break exists , how to remove it. Can you help me in this regard.

    Anybody please revert.

    Regards,
    Simi
    Last edited by Simi; 05-18-2017 at 11:06 AM.

  2. #2
    Join Date
    May 2016
    Posts
    186

    Default

    I would try replacing the line break for a blank when querying the database.
    If not possible, you can try in the report something like a combination of functions like REPLACE a UNICHAR(10). I use UNICHAR(10) to insert line breaks when I need to a text, so maybe you can use it to try to take them out, although you'll have to delve into the possible different types of linebreaks, maybe there are other types of UNICHAR codes for different linebreaks (windows/unix style, tabs working as linebreaks, etc)
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

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 - 2017 Pentaho Corporation. All Rights Reserved.