I'm trying to transform strings in Alteryx using one regex tool as follows
Original:
lorem ipsum. DOLOR SIT AMET.
Looking for:
Lorem ipsum. Dolor sit amet.
Now, I did manage to match this pattern with the following REGEX
(^\w)|\.\s(\w)
But I'm not sure how to replace it in Alteryx.
Any ideas? I expected \U$1\U$2
and copy unmatched to work.
Could you please try following, written with your shown samples. This is creating 4th capturing groups, where 1st capturing will have like:
D
, 2nd capturing group containsOLOR
, 3rd capturing group containsSIT
and 4th capturing group containsAMET
in shown samples.Online demo for above regex
So you could try following command:
$1 \U$2 \U$3 \U$4