FilesExpand file tree

 master

/

csv_dialect_variations.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

51 lines (41 loc) · 1.25 KB

 master

/

csv_dialect_variations.py

Copy path

Top

File metadata and controls

• Code
• Blame

51 lines (41 loc) · 1.25 KB

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

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

import csv

import logging

import sys

logging.basicConfig(stream=sys.stderr, level=logging.INFO)

csv.register_dialect(

"escaped", escapechar="\\", doublequote=False, quoting=csv.QUOTE_NONE

)

csv.register_dialect("singlequote", quotechar="'", quoting=csv.QUOTE_ALL)

quoting_modes = {getattr(csv, n): n for n in dir(csv) if n.startswith("QUOTE_")}

logging.info("==> %s", quoting_modes)

TEMPLATE = """

Dialect: "{name}"

delimiter = {dl!r:<6} sikpinitialspace = {si!r}

doublequote = {dq!r:<6} quoting = {qu}

quotechar = {qc!r:<6} lineterminator = {lt!r}

escapechar = {ec!r:<6}

"""

for name in sorted(csv.list_dialects()):

dialect = csv.get_dialect(name)

logging.info(

"%s",

TEMPLATE.format(

name=name,

dl=dialect.delimiter,

si=dialect.skipinitialspace,

dq=dialect.doublequote,

qu=quoting_modes[dialect.quoting],

qc=dialect.quotechar,

lt=dialect.lineterminator,

ec=dialect.escapechar,

),

)

writer = csv.writer(sys.stdout, dialect=dialect)

writer.writerow(

(

"col1",

1,

"10/01/2010",

"special chars: \" ' {} to parse".format(dialect.delimiter),

)

)