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