Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Split fields into rows with "enter" as delimiter?

  1. #1
    Join Date
    Nov 2014
    Posts
    5

    Question Split fields into rows with "enter" as delimiter?

    Hi all,

    Quite new to Pentaho so sorry if this is a simple question (it should be simple :P) but I'm already trying for two hours.

    I imported an Excel file with a lay-out similar to:

    Task1 Position 1
    Position 2
    Position 3
    Task2 Position 4
    Position 5

    Now I'm trying, by use of the "Split fields to rows" step, to split the positions in separate rows so I'll get:

    Task 1 Position 1
    Task 1 Position 2
    Task 1 Position 3
    Task 2 Position 4
    Task 2 Position 5

    However, I don't know what to use as delimiter. I tried most combinations I could find for carriage return but no luck. Could anyone here point me to the right solution?

    Thanks!

    Rob

  2. #2

    Default

    You have to use .\n as regular expression as delimiter, this should do the trick (see screenshot)

    Name:  split.jpg
Views: 313
Size:  22.4 KB

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.