Created
July 30, 2011 18:06
-
-
Save dipth/1115801 to your computer and use it in GitHub Desktop.
Nykredit -> Freeagent
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Use this regular expression to convert the exported csv-files from Nykredit to the csv-format required by FreeagentCentral. | |
| Use the "convert commas to period", and "Omit headers" option when exporting from Nykredit. | |
| Find: ^(\d{2})-(\d{2})-(\d{4});(.+?);(-?.+?);(N|J);(.+?);(\d{2}-\d{2}-\d{4})$ | |
| Replace: $1/$2/$3,$5,"$4" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment