CREATE OR REPLACE FUNCTION public.initcap2(text) RETURNS text LANGUAGE plpgsql AS $function$ DECLARE sentence TEXT := ''; word_array TEXT[]; word TEXT; word_out TEXT; BEGIN sentence := $1;
IF sentence is NULL THEN RETURN NULL; END IF;
word_array := regexp_split_to_array($1, E'[\\[\\]\^\$\.\|\?\*\+\(\)\\~`\!@#%&\\-\\_+={}"<>:;, ]'); FOREACH word IN ARRAY word_array LOOP word_out := upper(left(word, 1)) || lower(substring(word, 2)); sentence := replace(sentence, word, word_out); END LOOP;
Yes, this can be adaptable, and i did simple version of this.
It just split text words with find spaces, capitalise each
pieces(word) and merge together again.
This is a quick and simple work. You can develop over it about your needs.
Try that and tell us about result.
CREATE OR REPLACE FUNCTION initcap2(text) RETURNS text LANGUAGE plpgsql AS $function$ DECLARE sentence TEXT := ''; word_array TEXT[]; word TEXT; word_out TEXT; BEGIN sentence := $1;
IF sentence is NULL THEN RETURN NULL; END IF;
word_array := regexp_split_to_array($1, E'\\s+'); FOREACH word IN ARRAY word_array LOOP word_out := upper(left(word, 1)) || lower(substring(word, 2)); sentence := regexp_replace(sentence, word, word_out); END LOOP;
RETURN trim(sentence); END; $function$ ;
Hello, Metin,
See the following testing response.
ERROR: invalid regular expression: parentheses () not balanced CONTEXT: PL/pgSQL function testinitcap2(text) line 18 at assignment