Databricks Community

dkhodyriev1208

Using SELECT INITCAP("text (e.g., text, text, etc.)") abbreviations with periods like e.g. are not being fully capitalized.Current behavior:Input: "text (e.g., text, text, etc.)"Output: "Text (e.g., Text, Text, Etc.)"Expected behavior:Output: "Text ...

dkhodyriev1208

Thanks for suggestion.Good option, but few concerns here: there is no space in my original example for e.g. so it would require more sophisticated regex or custom udf.I think that the root cause of the issue is some limitation of initcap function, th...

Databricks Community

User Stats

User Activity

Spark SQL INITCAP not capitalizing letters after periods in abbreviations

Re: Spark SQL INITCAP not capitalizing letters after periods in abbreviations