Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: new line characters issue

  1. #1
    Join Date
    Aug 2015
    Posts
    313

    Default new line characters issue

    Hi Sir,Madam,

    I am facing issue with error with new line characters. i am using MySQL database , PDI-CE-6.1, java 1.7. I applied replace function which is part of MySQL database but there is no luck. could you please help how can i get in single line using PDI steps/process.

    REPLACE(description, '\n', '') as description


    final result i want in single line
    1/12/16 TTL - LOCATED TRUCK AND INSPECTED VERIFIED WATER PUMP LEAKING - LEAKING THRU WEEP HOLE DRAINED COOLANT AND DISASSEMBLED TRUCK - REMOVED WATER PUMP

    Getting as like below even though when i applied Replace function.

    description ---------------------------------------------------------------------------------------------------------------------------------------------------------------
    1/12/16 TTL - LOCATED TRUCK AND INSPECTED
    VERIFIED WATER PUMP LEAKING - LEAKING THRU WEEP HOLE
    DRAINED COOLANT AND DISASSEMBLED TRUCK - REMOVED WATER PUMP

    Thanks,
    Santhi
    Last edited by santhi; 01-28-2017 at 10:33 AM.

  2. #2
    Join Date
    Aug 2015
    Posts
    313

    Default

    sorry finally googled and git solution after relvent all MySQL DB searches.

    REPLACE(description,'\r','')
    and for future purpose i thouht in better way it as replace(REPLACE(description, '\n', ''),'\r','')

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.