You are here: PSPad forum > English discussion forum > Replace the first occurence of the text
Posted by: Andreas | Date: 2014-12-15 21:21 | IP: IP Logged
zales33:...I have opened my .csv file...100000.00,,,100235,0,2345.98,CAD,November
ABDDGHEF.00,,10002533,,0,64529.53,CAD,December...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
In this case maybe it's a better idea to open your csv with OOo calc and save in another format. When using save as you can choose the field delimiter as well as the text delimiter.
I don't know what you wanna do with your csv and why some values have to be encapsulated by quotes, but if you plan to continue working on your csv with PHP or JS, you don't need to modify it with PSPad. You then can use split() (JS), explode() (PHP) or simular functions to seperate your values.
Editor PSPad - freeware editor, © 2001 - 2024 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR