I'm Trying......Tags

Support
#1

I have been trying to learn about Regular Expressions and have to admit that I find it difficult.
Using various bits and pieces I am trying to sort out McX

RE: Mc Words.
Field: Tag
Regular Expression: \bMc(?=.)
Replace Matches with: Mc$upper($1)

Unfortunately this still produces Mcx

Help!

#2

I think that the $upper() does not work in a regexp.
Try Mc\U$1

#3

Thanks for the input.
Unfortunately does not work

#4

$regexp('Mc x','Mc (.)',Mc \U$1)
leads to
Mc X

#5

Still no success with that 'o' I'm afraid.
Don't really know what I'm doing tho'.

#6
Action "Format value" Field: TEST_1 Formatstring: 'Mr. Mcguyver' Action "Format value" Field: TEST_1 Formatstring: $regexp(%TEST_1%,'\bMc(.)','Mc\u$1') ==> TEST_1 = Mr. McGuyver ------------------------- Action "Format value" Field: TEST_2 Formatstring: 'Mr. Mcguyver' Action "Replace with regular Expression" Field: TEST_2 Regular Expression: \bMc(.) Replace matches with: Mc$upper($1) ==> TEST_2 = Mr. McGuyver ------------------------- Action "Format value" Field: TEST_3 Formatstring: 'Mr. Mcguyver' Action "Replace with regular Expression" Field: TEST_3 Regular Expression: \bMc(.) Replace matches with: Mc\u$1 ==> TEST_3 = Mr. McGuyver -------------------------

DD.20160617.1717.CEST

#7
#8

I gave you three different examples to try out.
At first, you should try to follow the examples, they work.
If you have success, then use an example with your values.

DD.20160617.1900.CEST

#9

Got it D.
Thanks very much!!!