Replace Formula 2

[NateUNI]

If I have a string like the following:

http://www.google.com/Eds/articles.jsp?articleID=54&campaignID=26&edsArticleTitle=Data

Security - Better Safe Than Sorry

How would i write a replace statment that will replace anything before the article title to be replaced with a blank space.

IE. The above string would be replaced with "Data Security - Better Safe Than Sorry"

The number following articleID and campaignID can change. IE. right now it is 54 and 26, next time it could be 1 and 1000.

 

[Madawc]

Assuming that the http and Data are constant:
Replace ({yourstring}, "http*Data", "Data&quot

Madawc Williams
East Anglia
Great Britain

 

[dgillz]

Mid({String},n) will return the rest of the string starting at n.

Instr({String},"Substring&quot will return a numeric value for what charcter number the subtring starts at in the full string, the n that we need in your case.

So try this:

Mid({String},instr({String},"SubString&quot)

It should give you everything to the right of where the subtring starts.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[pastasalad]

NateUNI - try Mid({String},instr({String},"ArticleTitle=&quot + 13)

This finds the position at which the string "ArticelTitle=" starts (I am assuming that the string "ArticleTitle=" will always be present), then adds 13 to it to get past the ArticleTitle= string, and picks up whatever it finds from thereon.

Is this what you are after?

Regards

Marc

 

[NateUNI]

Thats exactly what I was looking for, Thanks alot guys.