pulling info from Memo Fields

[JohnEck]

I need to pull some information out of a memo field. I need to take every thing after the string "Expired Info". Does anyone know how to find the position of a string in a memo field. I tried InStr and get 0.00 every time. Yes this is in CR 9.0 so it should be able to deal with Memo fields.

Thanks John

 

[synapsevampire]

I don't have 9 to text, but if you're using a SQL database, you might consider doing this in the SQL or using a SQL Expression.

In SQL Server you'd use:

substring(somememo, charindex('Expired Info',somememo)+12,1000)

Change the 1000 to whatever length you need.

-k

 

[JohnEck]

Thanks, I found the problem. The InStr formula in CR 9 must be case sensitive. When we used UPPER CASE letters like whats in the field it worked.