No documitaiton how to read a csv with a custom delimiter

[guysoft]

Hey,
I want to read a csv that has tab as its delimiter.
I can't find anything in the documentation or code on how to force that.
Can you please explain what is missing to implement this/give a usage example?

Thanks,

[chfw]

please find it here. I will organise it later.

[guysoft]

Thats reading, not saving.

[chfw]

My bad. Here is a read example:

>>> import pyexcel as p
>>> s=p.get_sheet(file_name='test.csv', delimiter='\t')
>>> s
test.csv:
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
| 4 | 5 | 6 |
+---+---+---+
>>> exit()
$ cat test.csv
1       2       3
4       5       6

[guysoft]

Thanks!

[dimaninc]

@chfw hey man
i'm trying the code but it doesn't work:

Traceback (most recent call last):
  File "crawler.py", line 142, in <module>
    sheet = pyx.get_sheet(file_name=config['offersFolder'] + config['offersFilename'] + '.csv', delimeter=';')
...
File "/Users/dimaninc/Envs/t/lib/python3.6/site-packages/pyexcel_io/readers/csvr.py", line 151, in row_iterator
    return csv.reader(self.__file_handle, **self._keywords)
TypeError: 'delimeter' is an invalid keyword argument for this function

i've also searched for the keyword 'delimeter' in your sources but didnt find anything

[chfw]

delimeter -> delimiter?

https://github.com/pyexcel/pyexcel-io/search?utf8=%E2%9C%93&q=delimiter&type=

[dimaninc]

@chfw oh thanks man, i'm an idiot :)

[chfw]

“To err is human, to forgive, divine.”

― Alexander Pope, An Essay on Criticism