Re: [libreoffice-users] Re: Calc method to change whole column cell content

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 <villeroy@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+unsubscribe@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+unsubscribe@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