"Loop files filter"
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
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">
Tagged:
0
Answers
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
.*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!