Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to find coresponding line in file?

  1. #1
    Join Date
    Jun 2016
    Posts
    181

    Default How to find coresponding line in file?

    I use "Get File Names=> Mail" steps to send attachments from some directory. Between them I need step that will check the correct address for each attachment.

    For instance short_filename is 1098235.txt so I need to find line in some text file that contains '1098235 some@address.com' (earlier I will cat '1098235' from short_filename field... using JavaScript) and use e-mail addres for Mail step.

    So the file that maps numbers with e-mail address could have content:

    company_number; email_address
    1098234; x@address.com
    1098235; some@address.com
    1098236; z@address.com
    ..; ...

    Any advice?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    So you want to do a stream lookup?

  3. #3
    Join Date
    Jun 2016
    Posts
    181

    Default

    Nobody would expect but it works ;-)
    Thank you!

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.