Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

lower case without removing numbers

Hi all,

I am trying to join two tables together. Because they are both open fields, there are some differences in names regarding punctuation, use of capitals etc.
I have now transformed the variables to match on like this to overcome this problem: replaceAll(lower(trim(VARIABLE)), "[. ,()-:?]","").

However, this code also deletes all numbers in the variable name and I don't want that.

Any thoughts?

Find more posts tagged with

AI Studio

Accepted answers

Thomas_Ott

If these are nominal values, then I would definately use the Replace operator and do the regex first to remove the puncuation AND then do the lowering/trimming.

Just doing a regex with \W selects all the puncuation and then replace with either a "_" or nothing will get rid of the puncutation. If that's not the desired effect then I would consider splitting off the numbers, doing the lower/trim, and then rejoin the numbers.

All comments

Thomas_Ott

It sounds like you'll need the Rename By Replacing operator and write some REGEX to skip over the numbers in your attribute names.

sgenzer

yes agreed. I would also just try changing the order of that expression. Looks like you're trying to use RegEx after "lower" and "trim". Try doing the replaceAll RegEx first.

Scott

m_meijs

Thanks. I have tried that, but unfortunately it doesn't work. It removes all characters and spaces, but when converting to lower case it still removes the numbers.

Any thoughts on what to add to make sure it doesn't do that ?

Thomas_Ott

If these are nominal values, then I would definately use the Replace operator and do the regex first to remove the puncuation AND then do the lowering/trimming.

m_meijs

This works! Thanks!