Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: barney-2074; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Merging delimited text files with maximum value found

    Hello,

    I am trying to merge multiple text files using the maximum value found at a particular row & column

    All the text files have exactly the same number of rows and columns, as per the below...
  2. To partially answer my question (I'm not sure if...

    To partially answer my question (I'm not sure if it efficient, but it works)

    Step 1. Use java expressions to extract degrees, minutes & seconds values

    degrees:...
  3. Convert degrees minutes seconds to decimal degrees

    Hello

    What is the most efficient way to convert a value in degrees minutes & seconds to decimal degrees ?
    For example:

    135°49'54" --> 137.83166667

    I can use a series of split strings & ,...
  4. Hello thank you for all the answers and...

    Hello

    thank you for all the answers and comments.
    I ended up using the marabu approach, as per @gutlez example

    The key part is that it uses a java expression to set a flag, then groups by that...
  5. Extracting data from a headings in a text file

    Hello,

    I am trying to extract data from a file in the following format into a tabular form, with the text in red repeated for each record beneath it in blue, until the next red value (where it is...
  6. Hi Marubu thank you very much- that is...

    Hi Marubu

    thank you very much- that is fantastic.
    I think I understand how it works & I will see if I can develop it further


    Andrew
  7. Splitting text file at specific strings

    Hello

    I want split a text file at specific strings. The data file is structured with several sub-headings such as:
    %T TASK
    %T POBS
    %T UDFTYPE

    with data in between these headings. The data is...
Results 1 to 7 of 7
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.