Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Length(string), I tried Caculations and String Operations

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Length(string), I tried Caculations and String Operations

    Hello Everyone,

    I would like to filter out rows whose entries in Column A are shorter than 2 symbols. Hence, I have to compute string length. I looked at "Calculator" component and "String operations" component, but could not find anything.

    Can anybody suggest something? Maybe Javascript?

    Regards,
    Alex

  2. #2
    Join Date
    Nov 2008
    Posts
    271

    Default

    The calculator step actually has a "Return the lenght of string A" that gives you back an integer.

    Probably you can achieve a better result using directly a filter rows with Regexp option.
    Last edited by Ato; 09-26-2011 at 03:34 PM.
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Never mind! I found "Formula"

    Sorry!

  4. #4
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you, Andrea!

    I will try it!

  5. #5
    Join Date
    Nov 2008
    Posts
    271

    Default

    No problem. Consider that calculator step should be a bit faster than formula step.
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

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.