You are here: PSPad forum > English discussion forum > Replace the first occurence of the text

Replace the first occurence of the text

Goto Page: Previous1 2

#11 Re: 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.

Options: Reply | Quote | Up ^


Goto Page: Previous1 2





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