Parse value using Regx

Hello,

I have a few values that are stored as strings in our MYSQL db. I need to parse these to get them to appear proper. I’ve tried using both the transform function as well as the value mapping, but i can’t get either to work.

String Value examples in DB:
202427
073000
121015

Should become:
20:24:27
07:30:00
12:10:15

Regx condition: ^(\d{2})(\d{2})(\d{2})$
Display Text: $1:$2:$3

Should work according to regex101: regex101: build, test, and debug regex

Next i’m trying to parse a similar string of coordinates.

String values in DB:
1249.818864
5551.354998
55551.354998
551.354998

Should become:
12° 49’ 81
55° 51’ 35
555° 51’ 35
5° 51’ 35

Regex: /^(\d{1,3})(\d{2}).(\d{2})\d*$/gm
replace: $1° $2’ $3

Should also work according to regex101: regex101: build, test, and debug regex

Does anyone have an idea what i’m doing wrong?

Sincerely
Narux

I’m still looking for a solution to this. Does nobody have an idea what is going wrong?