Renaming dates
#1 : 01/08-19 05:24 viola
Posts: 3
|
Hello, I need help with some things please.
when the month is spelled: Dec-03-2016 to 2016-12-03 (only an example) and the last YYYY.MM.DD to YYYY-MM-DD Thanks! |
#2 : 01/08-19 19:41 David Lee
Posts: 1125
|
You should be able to work these out for yourself.
Try reading the User Guide! 1) Use the List replace method and fill in the fields with... Jan -> 01 Feb -> 02 Mar -> 03 etc etc Then reorder using the Swap method on the 2nd occurrence of "-" 2) Replace method: Replace "." with "-" |
|
#3 : 01/08-19 21:06 viola
Posts: 3
|
Reply to #2:
swap doesn't work in my case :( https://a.uguu.se/E1I3igunVonY_ARen_2019-08-01_2 1-02-47.png but thanks so far, the rest worked :3 |
|
#4 : 01/08-19 22:21 David Lee
Posts: 1125
|
Reply to #3:
What do you expect if you don't describe your problem completely! The answer is described in a simple example in the User Guide - please read it. However... Replace method Replace: (\d{2}-\d{2})-(\d{4}) With: \2 -\1 Use regular expressions |
|
#5 : 02/08-19 01:31 viola
Posts: 3
|
Reply to #4:
Thanks you that solved it! Sorry I read the guide a bit before posting, but it was difficult. Now I understand it better. |