I have a column that contains variable length phrases or words that are separated by hyphen in a variable length string. I would like return only the first character of each phrase/word without building a function.

For example:

row 1: lectus-aliquam-sit-amet-diam-in-magna-bibendum-imperdiet

row 2: nulla-nisl-nunc-nisl-duis-bibendum-felis-sed nnnndbfs

I would like to return:

row 1: lasadimbi

row 2: nnnndbfs

Thank you for your help.

No idea! I cannot figure it out!