I'm trying to convert the following values: 1-7-05 to 1-07-05. Can this be done with actions or is it not possible? Any help would be great.
This can be easily solved with a Replace with regular expression action:
Field: YourFieldNameHere
Regular Expression: (\d)-(\d)-(\d\d)
Replace matches with: $1-$num($2,2)-$3
Best regards,
~ Florian
Thanks Florian.