Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: problem with character (á) in cvs file name

  1. #1

    Default problem with character (á) in cvs file name

    Hi,

    I have some cvs file with the name: ExámenMedico1012011_30062011.cvs, ExámenMedico1012013_30612011.cvs and I nedd to store in a database.

    For process I have a server linux 64 bits and PDI 4.2.1

    The problem is that PDI doesn't recognize the file for processing in linux, but in windows it works.
    The problem is the name of the file (Exámen), the character (á). I tried replace (á) for (a) and works, but the name of the file is with á.
    I tried with a regular expresion *.cvs o something like that but doesn't works.

    The solution can be, change the name of the file in linux, but I dont know how because I tried with the command:
    iconv -f latin1 -t utf8 Exámen01012011_30062011.csv> Examen01012011_30062011.csv

    but the problem is that I need change the name at all files called Exámen... and keep the same name
    and the command only works if I say the exactly name and also this command change the name of the file and content and I just need change tha name.

    I just need that PDI recognize the file for process in linux.

    Thank for your help.

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

    Default

    Try a regular expression of:
    .*\.cvs
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3

    Default

    Hi,

    Thanks for your answer, but the regular expresion doesn't work.

    Thanks

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.