Menu

"*" ???

2007-09-09
2012-11-13
  • Nobody/Anonymous

    Hi

    i have a .csv file where i have a lot of GPS data inside and i wan to change this lines.

    10.5051400,46.8483400,"6543 M50; Laser; Rtg. Italien NAUDERS"

    the abve line is an example, i want to change around 4000 lines everthing inside " " shoulde be changed to "Mobiles Radar 50 km/h"

    is there any way i coulde do this with a search string or command?

    Sorry for my bad english

    R
    Thomas

     
    • pshute

      pshute - 2007-09-12

      Using the advanced find/replace (control+R), with regex enabled:
      Find: ".*"
      Replace: "Mobiles Radar 50 km/h"

      That will change even lines where something other than "6543 M50; Laser; Rtg. Italien NAUDERS" is contained within the "".  Is that what you meant?

      If so, and if every field is the same width in each line, then you could also try the new column mode (alt+C) and simply type in the replacement text.  Requires version 4.2.2, I think.

       
    • Nobody/Anonymous

      Load the file into Excel you will get 3 columns
      Yousing your eg
      row 1 col a 10.5051400
      row 1 col b 46.8483400
      row 1 col c 6543 M50; Laser; Rtg. Italien NAUDERS

      In row 1 col d put the function @concatenate(a1,",",b1,",","""Mobiles Radar 50 km/h""")

      Then simply copy the result & paste into notepad.

      Not using Notepad++, but it will get you going