Ask Your Question
0

Calc Csv Import

asked 2019-10-02 18:33:54 +0200

pavel9 gravatar image

updated 2019-10-02 18:34:31 +0200

Hi, I have a need that I hope you can solve. I can import and correctly map a CSV, the Inland Revenue however, it provides one that contains text strings with single quotation marks (') and numeric strings with double ones ("). When I import I can only set one of these delimiters, wouldn't it be possible to set them both or otherwise delete them directly in the import? Thanks descrizione immagine

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-10-02 20:23:03 +0200

erAck gravatar image

updated 2019-10-02 20:23:37 +0200

You mean they provide something like

'This is a text',"12345.67",'Another text'

? That would indeed be odd (and not proper CSV). I'd suggest you import with the " string delimiter (which actually is the quoted field quote character and not just a string delimiter) so at least numbers get recognized during the import, and after the import using Find&Replace (Ctrl+H) replace all leading and trailing ' characters with nothing.

edit flag offensive delete link more

Comments

It is really a file. Thank you but I wanted to delete the delimiters on the fly during the import

pavel9 gravatar imagepavel9 ( 2019-10-03 12:33:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-02 18:33:54 +0200

Seen: 149 times

Last updated: Oct 02 '19