extracting a string 1

[izachar]

I have a log file in a db. One of the columns is a target field that has the URL in it. I need to extract the extention xml from the url so I can count it and get my page views. I tried InStr {InternetLog.target}, ".xml&quot but it does not take only the xml lines. What do you recommend?

 

[malk]

If you know the position in the string you can control it using the mid function.

mid (fieldname,starting position,length)

example: the string1 "abc123"

mid (sting1,3,2) will return "c1"

Good luck

 

[izachar]

No I don't know the location. Every time it could be different since it is an xml file with different parameters after it. I can do this with an sql statement in the db using a filter based on a "like" condition but sql in crystal is a little funky.

 

[kenhamady]

Do you need:

determine its position in the string or
determine its existance in the string?

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[izachar]

I need a count on the xml so it is filtering out the lines that have xml in them.

 

[kenhamady]

Are you trying to count the number of records that have 'xml' somewhere in the {InternetLog.target} field? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[izachar]

that is correct

 

[kenhamady]

Write a formula that says:

if 'xml' in {InternetLog.target}
then 1
else 0

Put this field on the detail band.
Create subtotals and grand totals of this field as needed. A sum of this field will tell you how many records have xml in that field.
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal