Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: how to remove break line or Enter from data in a column

  1. #1
    Join Date
    Jun 2017
    Posts
    25

    Default how to remove break line or Enter from data in a column

    Hi, im doing a project to integrate data from a database to text file output. But a column in the database have data that got a breakline in it, although when viewing the data in the database it shown as 1 column, but the textfile output resulting in 2 row produce from a single row of data in the database.

    how can i remove the breakline/enter when integrated to textfile output

    i attached the screenshot for the data in this case.
    Name:  cap.jpg
Views: 258
Size:  10.9 KB
    data in database

    Name:  cap3.PNG
Views: 251
Size:  3.9 KBName:  cap2.PNG
Views: 252
Size:  3.6 KB
    Textfile output


    I try to use value mapper and regex to remove the breakline but im not sure if the step is correct. see the step below:
    Name:  sol.PNG
Views: 256
Size:  3.6 KB
    Name:  sol1.jpg
Views: 255
Size:  7.2 KB

    hope u guys can help me.

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

    Default

    The simple regular expression [\n\r] should work.
    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.