Issue 32278

Summary: Sed -- text stream editor
Product: Calc Reporter: dubiel <leszek>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
My file to compute our products.... none

Description dubiel 2004-07-29 10:40:47 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.
Comment 1 dubiel 2004-07-29 10:43:11 UTC
Created attachment 16835 [details]
My file to compute our products....
Comment 2 dubiel 2004-07-29 10:47:36 UTC
I suggest using source code from SuperSed --
http://sed.sourceforge.net/grabbag/ssed/

Comment 3 frank 2004-07-29 11:34:15 UTC
Hi Bettina,

one for you.

Frank
Comment 4 bettina.haberer 2010-05-21 15:17:37 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".