I regularly use UltraEdit (UE) and you can edit files beyond 4GB with millions of lines and it uses regular expressions. This would be a quite easy conversion in UE. It has a column mode editing ability so you can edit only in selected columns as well.
*Henry* On 13 April 2016 at 19:27, Andreas Säger <ville...@t-online.de> wrote: > Am 13.04.2016 um 12:32 schrieb Tom Davies: > > Hi :) > > CSV format can be easily edited in normal text-editors before opening in > > Calc. Sometimes its easier to use a simpler tool to do a part of the job > > rather than use a complicated route in a heavier tool such as Calc. > > Regards from > > Tom :) > > Really? And how do you convert (£1,234.98) into -1234.98 in columns 3, > 17 and 23 across thousands of rows using a text editor? Are YOU able to > do this actually? > Don't you think that checking "English(UK)" and "Interprete Special > Numbers" is by far easier? > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted