Apache OpenOffice (AOO) Bugzilla – Issue 32278
Sed -- text stream editor
Last modified: 2013-02-07 22:37:42 UTC
OOo should not be "just" M$Office -- this sould be better in the same manner that Linux is better. I sugges to supply user with more advanced functions for text processing. For example function: Sed(<input>, <program>) which takes input text and applies to it given program. For example =Sed("alfa beta gamma"; "s/[ae]/[AE]/g") will put "AlfA bEtA gAmmA" in cell. Why do I need so sofisticated text operations --- see attachment. I have text files which contain product name and quantities. I have to cut each string into separate parts and then convert strings to numbers. This is simple and can be done. But I have had some tasks to do where texts were not aligned very well - I have had to use sed, while this should be done in Office without scripting.
Created attachment 16835 [details] My file to compute our products....
I suggest using source code from SuperSed -- http://sed.sourceforge.net/grabbag/ssed/
Hi Bettina, one for you. Frank
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".