Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Extract Number Field

  1. #1
    Join Date
    Mar 2016
    Posts
    18

    Smile Extract Number Field

    Hi all
    I wanna a help please
    I wanna to extract ONLY CodeNumber for my Multiplie rows
    Ex : Alian John c3434 i wanna just that c3434
    Dude barack david V6790 i wanna just that V6790
    how can i do thats ???

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

    Default

    If it's a field value, you can use a regular expression to extract that code number, for example: ^.* (\w+)$
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2016
    Posts
    13

    Default

    Hi Zaki,
    You can use the regex evaluation step and add below in regex
    .*([a-zA-Z][0-9]{4}).*


    This should help your cause

    Regards.

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.