How to remove unwanted columns and fields in Notepad++

csv notepad++ datafeed
shaunybhoy picture shaunybhoy · Aug 19, 2014 · Viewed 7.5k times · Source

I have a feed with the following columns:

product_name,description,aw_product_id,store_price,merchant_image_url,merchant_deep_link,merchant_category,merchant_product_id

Each line afterwards has all the information in this order. I only require the product_name for each line, not everything that comes afterwards.

So my question is, how do I remove everything and only keep the product_name?

Answer

MRAB picture MRAB · Aug 19, 2014

You could use a regex to replace the comma and everything after it with nothing:

Search: ,.*

Replace: (nothing)

Related questions

Delete every other line in notepad++

Is there a way in Notepad++ to delete every other or nth line? I have a massive list of data and I need to reduce the size. The data itself is not that important and out of a list of 10,000 …

Read More
Remove or replace LF from CSV file

I have some huge csv files where sometimes the lines end with LF instead to CRLF, ie: pippo LF pluto CRLF I would have a line like pippo pluto CRLF I'm trying to use notepad++ under Windows 7 but I'm not …

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More