Editing CSV including html from DJ Catalog



  • Hello,
    I want to use notepad++ for editing my “DJ Catalog” content. The issue is that some columns using mutliple lines with coma inside.
    Here is an example of such a file:
    id,parent_id,group_id,cat_id,producer_id,name,alias,sku,description,intro_desc,price,special_price,tax_rate_id,address,city,postcode,country,state,phone,mobile,fax,website,email,latitude,longitude,available,metatitle,metakey,metadesc,heading,published,access,ordering,featured,hits,params,checked_out,checked_out_time,created,created_by,publish_up,publish_down,category_name,producer_name,author,_nummer,_beschreibung,_lieferumfang
    54,51,“Indikator HA 0,3”,indikator-ha-0-3,"<hr class="“system-pagebreak”" style="“width: 1081.08px; word-spacing: 0px; background-image: url(‘img/pagebreak.png’);”" title="“Analysenbereich”" /><table class="“wacon-table”"><tbody><tr><td>Messbereich Sycon 3000</td><td>Maßeinheit</td></tr><tr><td>0,02 … 0,12</td><td>°dH</td></tr><tr><td>0,36 … 2,13</td><td>ppm</td></tr><tr><td>0,036 … 0,213</td><td>°f</td></tr><tr><td>0,025 … 0,150</td><td>°e</td></tr></tbody></table><p> </p><hr class="“system-pagebreak”" style="“width: 1081.08px; word-spacing: 0px; background-image: url(‘img/pagebreak.png’);”" title="“Kompatible Analysengeräte”" /><table class="“wacon-table”"><tbody><tr><td>Gerät</td><td>Kompatibel</td><td>Bemerkung</td></tr><tr><td>Sycon 2500</td><td>nein</td><td>Abgekündigtes Analysengerät, ersetzt durch Analysengerät Sycon 2502</td></tr><tr><td>Sycon 2501</td><td>nein</td><td>Abgekündigtes Analysengerät, ersetzt durch Analysengerät Sycon 2502</td></tr><tr><td>Sycon 2502</td><td>nein</td><td> </td></tr><tr><td>Sycon 2800</td><td>nein</td><td> </td></tr><tr><td>Sycon 3000</td><td>ja</td><td> Abgekündigtes Analysengerät, ersetzt durch Analysengerät Sycon 2800</td></tr></tbody></table><p> </p><hr class="“system-pagebreak”" style="“width: 1081.08px; word-spacing: 0px; background-image: url(‘img/pagebreak.png’);”" title="“Technische Daten”" /><table class="“wacon-table”"><tbody><tr><td>Parameter</td><td>Wert / Bereich</td></tr><tr><td>Haltbarkeit</td><td>24 Monate</td></tr><tr><td>Menge</td><td>500 ml</td></tr><tr><td>Flasche</td><td>Rundflasche</td></tr></tbody></table>","<p>Der Indikator H25 - 0,02 ist ein Indikator zur Bestimmung der Resthärte bzw. Gesamthärte abhängig vom verwendeten Analysengerät der Sycon Serie.</p><p>Wie alle unsere Indikatoren für unsere eigenen Analysengeräte zeichnet sich auch der H25 - 0,02 durch folgende Merkmale aus</p><ul><li>Verwendung von hochwertigen Rohstoffen</li><li>Herstellung nach eigenem Rezept</li><li>24 Monate haltbar</li></ul><p> </p><p>Den Indikator H25 - 0,02 gibt es auch im preisgünstigen Vorteilspack mit 4 Flaschen.</p>",0.00,0.00,0.000000000000000,0.000000000000000,1,1,1,23,"{"“show_contact_form”":"""","“comments”":"""","“price_restrict”":"""","“item_heading_override”":"""","“show_image_item”":"""","“show_category_name_item”":"""","“show_producer_name_item”":"""","“show_price_item”":"""","“show_old_price_item”":"""","“show_sku_item”":"""","“show_author_item”":"""","“show_hits_item”":"""","“show_date_item”":"""","“show_publishdate_item”":"""","“group_attributes_item”":"""","“items_show_cart_button_item”":"""","“show_intro_desc_item”":"""","“show_navigation”":"""","“show_print_button_item”":"""","“show_files_item”":"""","“show_fileinfos_item”":"""","“show_comments_item”":"""","“related_items_columns”":"""","“related_items_count”":"""","“items_show_variants”":"""","“items_show_image_variants”":"""","“items_show_price_variants”":"""","“items_show_sku_variants”":"""","“items_show_intro_variants”":"""","“items_intro_trunc_variants”":"""","“items_intro_length_variants”":"""","“items_show_cart_button_variants”":"""","“items_show_attributes_variants”":"""","“show_location_details_item”":"""","“location_country_item”":"""","“location_city_item”":"""","“location_address_item”":"""","“location_postcode_item”":"""","“location_phone_item”":"""","“location_mobile_item”":"""","“location_fax_item”":"""","“location_website_item”":"""","“location_email_item”":"""","“show_location_map_item”":"""","“gm_map_width_item”":"""","“gm_map_height_item”":"""","“gm_type_item”":"""","“gm_zoom_item”":"""","“gm_map_marker”":""""}",“0000-00-00 00:00:00”,“2017-03-17 08:49:19”,869,“0000-00-00 00:00:00”,“0000-00-00 00:00:00”,“Rest- & Gesamthärte für Sycon 3000”,32-084115,“Indikator H25 - 0,02”,“Indikator H25 - 0,02 in runder 500 ml Flasche”

    My questions:
    (1) Is it possible that notepad++ views them in columns?
    (2) Is it possbile to include a html syntax highlighting?

    If yes, how is it possbile?

    Thanks,

    Sascha


Log in to reply