Skip to main content
4 of 7
added 626 characters in body; edited title
Vituvo
  • 411
  • 9
  • 17

How to delete the the first value and tailing comma from the 7th column in a csv file

I am trying to remove the first value from the 31st column in a csv file. The columns are in quotes and separated by commas like so.

"first_name","last_name","home_address"
"Frank",Russel","123 Hampton road"

the 31st column is the image column and images are separated by commas

"http://ddd.com/124dfr3f.jpg,http://ddd.com/hjasgx37trg.jpg"

The first image and tailing comma has to be removed from the 31st column

Added - Here is an example. I removed 28 columns and this is what is left. Column three is the first image and it comes wrapped nicely. Column 3 and its image stays. Column four needs the first image removed and the trailing comma.

"options","optioncodes","first_image","images","toilet","next"
"sales","deeep","http://pictures.....com/0288/0057320db6c6adabcec517b4e6aaf63fx.jpg","http://firstimage_that_needs_to_be-removed856b9x.jpg,http://image2_-stays_and_so_one/0965/41191dd3318cf3f6ab5b3f4ef5c32171x.jpg,http://image3_-stays_and_so_one/0965/41191dd3318cf3f6ab5b3f4ef5c32171x.jpg","next"
Vituvo
  • 411
  • 9
  • 17