thanks so much for all of this antonio and especially the explanations - it helps me get my head around it - I will put it to the test over the weekend and see where I end up.
many thanks
karen
>Pattern could be simpler, actually.
>
>
>? PATTERNTRAN("1st-title: ANAME-HER : 3520931 place[21~22]", "(\[\d*).(\d*\])","$1.$2")
>? PATTERNTRAN("1st-title: ANAME-HER : 3520931 place[99 100]", "(\[\d*).(\d*\])","$1.$2")
>? PATTERNTRAN("1st-title: ANAME-HER : 3520931 place[35-36]", "(\[\d*).(\d*\])","$1.$2")
>
>
>There is no need to identify the separator character as a group. Note that the dot in the pattern represents "any character except line breaks", but in the replacement string it corresponds to a real dot. Also, all matches are being replaced (this could be changed by setting differently the .Global property).
>
>For instance
>
>
>? PATTERNTRAN("foo foo bar", "foo","mars")
>
>
>Finally, a great resource to experiment with regular expressions:
http://regexr.com/