FilesExpand file tree

 master

/

FixSQLDate.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

30 lines (24 loc) · 1010 Bytes

 master

/

FixSQLDate.py

Copy path

Top

File metadata and controls

• Code
• Blame

30 lines (24 loc) · 1010 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

# FixSQLDate.py

# Program goes through a text file or csv file and converts DD/MM/YYYY to SQL friendly date format of YYYY-MM-DD

# It changes and corrects the file imported.

# It is fast, a 2 million line csv file is converted in 10 seconds

import re

filename = input("please specify the file name:")

#filename = '/path/to/filename.csv' #you can also write it here, remember to comment out impute line above if you do

def is_date(expression):

pattern = re.compile('(\d+/\d+/\d+)')

if pattern.match(expression):

expression = expression.split('/')

expression = '-'.join([expression[2],expression[1],expression[0]])

return expression

return expression

data = []

with open(filename,'r') as file:

for line in file.readlines():

line = line.strip().split('\t')

for i in range(len(line)):

line[i]=is_date(line[i])

data.append('\t'.join(line))

with open(filename,'w') as file:

for line in data:

file.write(line+'\n')