The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

I want to use a macro inside

PrenticePrentice Member Posts: 66 Maven
edited November 2019 in Help
I have an Excel sheet where the examples of an attribute can be either upper and lower case. However, I want to filter these out with one filter. I've already seen a thread where you put in the expression "matches(lower(word),"eng.+")", this was to filter out the word english, which could be in the forms of English and english. But my text is variable, now I know that I can use a macro for this. The problem is, I don't know the syntax for it to work inside the expression. I've already tried something like "matches(lower(word),%{Macro_Name})" or "matches(lower(word),".+%{Macro_Name}.+")", but with no succes. Is it even possible to do it this way, or is there another way?



Best Answer


Sign In or Register to comment.