global replace using a variable driving me nuts

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

gimla
Posts: 1
Joined: Fri Feb 20, 2009 7:09 pm

global replace using a variable driving me nuts

Postby gimla » Fri Feb 20, 2009 7:13 pm

###SYMBOL: aaa X
UPDATE etf e SET e.etf_1 = 'some data (always changes)' where e.etf_symbol = --- ;
UPDATE etf e SET e.etf_2 = 'some data (always changes)' where e.etf_symbol = --- ;
UPDATE etf e SET e.etf_3 = 'some data (always changes)' where e.etf_symbol = --- ;
UPDATE etf e SET e.etf_4 = 'some data (always changes)' where e.etf_symbol = --- ;


the above tex can vary in order and content


I am trying to replace --- with aaa

If you ask me to use the capture aaa into a global variable , can you point me to somewhere where it is explained how step by step
as I could not find any tutorial on how to do this, I did read the help and I am a programmer (although feel a bit dumb asking this stupid question)

User avatar
DataMystic Support
Site Admin
Posts: 2162
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: global replace using a variable driving me nuts

Postby DataMystic Support » Mon Feb 23, 2009 12:04 pm

See report extraction/copy first field down.fll,

|
|--Restrict to each line in turn
| |
| |--Restrict columns:Column 1 .. column 15
| | |
| | |--Restrict to lines NOT matching [ {15}]
| | | | [ ] Include line numbers
| | | | [ ] Include filename
| | | | [ ] Match case
| | | | [ ] Count matches
| | | | Pattern type: 0
| | | | Context before: 0
| | | | Context after: 0
| | | |
| | | +--Capture to variable @mydata
| | | Reset: 1
| | |
| | +--Remove all
| |
| +--Add left margin [@mydata]
|
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest