"Loop files filter"

GregMGregM MemberPosts:18Maven
edited June 2019 inHelp
I have a folder with several csv files... along with some other files. What I want to do is loop through only the files that match the following case insensitive filter:

bdo*26*.csv

I can not figure out how to get any filter working. The code below is what I am trying to run just to verify funcitonality and right now I am not even able to filter just csv files. if I leave the filter blank it reads in all the files (including those I don't want). so the read is apparently working. what am I doing wrong in the filter?


any help is appreciated, thanks
Greg





<宏/ >

<运营商激活d="true" class="process" compatibility="5.3.013" expanded="true" name="Process">

<运营商激活d="true" class="loop_files" compatibility="5.3.013" expanded="true" height="76" name="Loop Files" width="90" x="179" y="120">



<运营商激活d="true" class="read_csv" compatibility="5.3.013" expanded="true" height="60" name="Read CSV" width="90" x="246" y="255">
























Answers

  • awchisholmawchisholm RapidMiner Certified Expert, MemberPosts:458Unicorn
    Hello Greg

    Regular expressions - tough at first - then with practice they remain tough.

    Without trying it, I can't be 100% certain but I think this requirement

    bdo*26*.csv

    could be implemented with the following in the filter

    [Bb]do.*26.*\.csv

    If you click on the little icon to the right of the filter dialog, a regular expression helper window comes up that is very good. Type the regular expression in the top field and the possible file name in the third field labelled text. If the regular expression matches, the text will be highlighted.

    regards

    Andrew

    regards

    Andrew
  • GregMGregM MemberPosts:18Maven
    thanks but no luck...

    .*csv finds the csv files
    b.* finds nothing even though there are plenty of files in the directory with names beginning with b

    oddly enough a reboot of the computer and rapidminer and it seems to be working... thanks!
Sign InorRegisterto comment.