I am importing node content from a CSV file but it is delimiting strings on a "£" symbol when this isn't supposed to happen. I have tried importing to both the Body field and a CCK text field but this still happens. Any ideas please?

Thanks.

Comments

mrtbc’s picture

mrtbc commented

Anyone please?

wusel’s picture

wusel commented

Please have a look at #1298102: Document the need for Byte Order Marker in CSV files with non-ASCII characters-#3.
Maybe it can help you, even if it concerns another import module (Migrate).

Much success.

johnv’s picture

johnv
Primary language Dutch
commented

Saving the CSV file as UTF-8 instead of ANSI resolved this problem for me. (on Windows, the simple Notepad editor has this setting when you do 'Save as..')

wusel’s picture

wusel commented
Title: CSV Import Delimits on £ Symbol » CSV Import Delimits on £ Symbol [solved]
Status: Active » Closed (works as designed)

Please look at http://drupal.org/node/1285276#note2 (for Migrate),
but in Feeds you can change the delimiter to "," or ";" or ...