Good morning,
I have opened my .csv file in PSPad and what I'm trying to do it add double
quotes around the items in the first column. The file has about 300,000 rows
and looks like this:
100000.00,,,100235,0,2345.98,CAD,November
ABDDGHEF.00,,10002533,,0,64529.53,CAD,December
As you can see the items in the first column are different lengths. I tried
using the Alt key to select a rectangular block (the first column including the
first comma), then using find(,) and replace (",) but it didn't work perfectly
due to the variable length of the first column. I know how to use Edit > Lines
Manipulation to add quotes at the beginning of each line but I don't know how to
accurately add another quote before the first comma of each line. Does anyone
have thoughts on how I can accomplish this? My goal is to have the lines look
like this:
"100000.00",,,100235,0,2345.98,CAD,November
"ABDDGHEF.00",,10002533,,0,64529.53,CAD,December
Thank you for reading my post. I appreciate any help you might be able to
offer!
--
<http://forum.pspad.com/read.php?2,63956,63956>
PSPad freeware editor http://www.pspad.com
