On 2015-10-09 06:35, Andreas Säger wrote:
OK, this is what I can achieve with a simple text editor:
Replace all "Rp" with "Rp|"
Replace all " % " with "%"
Replace all %) with )%
Copy all and paste into a spreadsheet with English(UK) as import locale.
Both, space and | as column delimiters with "Merge" option and "special
numbers" option.
This imports all dates, percents and currencies as correct numeric values.


That is simple. Also minimal processing with a script, in fact a few simple lines with sed.
Steve


--
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

Reply via email to