Tell us what’s happening:
Describe your issue in detail here.
Hello to everyone, I’m having trouble with the capitalize challenge, I can’t figure out how to capitalize the first letter of all the symbols in the elements table. Your code so far
I have used this code:
UPDATE elements SET symbol = initcap(symbol) WHERE symbol ~ '^[a-z]'
It works, but it also changes the T to lower case of the mT symbol.
If anyone can help me, i would appreciate it. Your browser information:
User Agent is: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36 Edg/101.0.1210.32
Challenge: Periodic Table Database - Build a Periodic Table Database
I’ve edited your code for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.
You can also use the “preformatted text” tool in the editor (</>) to add backticks around text.