Selecting partial data in a string... Please Help!! 2

[malk]

I have a string "xxx12345", and I want the Conditional Select Statement to pick up just the 4'th character thru the 5'th character for a comparison. In other words i am looking to Select based on the "12" in my string. Can this be done in the Selct Expert in CR 8? If yes, How?

 

[BonnieSue]

You can use the "Mid" function starting with the 4th character and for a length of 2-basically this is just substringing the string or you can use the "Like Pattern" (under the "Operators", "Pattern&quot "???12???". Hope this helps!

 

[kenhamady]

My preference is to use the subscripting operator which would look like this:


{fieldname} [ 4 to 5 ]


You tell it where to start and where to stop in the string. It assumes that the characters are in the same numeric position in every record. Ken Hamady

http://www.kenhamady.com/

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