String manipulation: Upper case with chemicals

KNIME Extensions
1

Hello community,

I have a list of chemicals and want to write the first letter in capitals. However, this does not work for chemicals, which beginn with alpha, beta, gamma and or with numbers. Examples are

ethanol -> Ethanol (That´s easy, here it is the first letter)
1,4-butanediamine -> 1,4-Butanediamine
β-cyclodextrin -> β-Cyclodextrin

How could I solve this?

Thanks in advance!

1 Like
2

Hi @Alkaline and welcome back to KNIME forum,

Please check this expression in the String Manipulation node and let me know if it works as expected:

join(regexReplace($column1$, "[a-z]", ""), capitalize(regexReplace($column1$, "[^a-z]", "")))

:blush:

2 Likes
3

Hi,

thank you very much for your quick reply. Unfortunately, it did not work. The chemical names are quite complex and for some I had additional “-”. I will give a more detailed answer with some examples later.

2 Likes
4

Hi there @Alkaline,

give examples that represent possible formats of chemical names and I’m sure @armingrudd will come up with a right regex :wink:

Br,
Ivan

2 Likes