Issue 32278 - Sed -- text stream editor
Summary: Sed -- text stream editor
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-29 10:40 UTC by dubiel
Modified: 2013-02-07 22:37 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
My file to compute our products.... (314.62 KB, application/vnd.sun.xml.calc)
2004-07-29 10:43 UTC, dubiel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".