computek353
Technical User
I need formula that will pull only the first line of a notes field. The line are seperated by a single returns in the DB.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
First Line of Field only
- Thread starter computek353
- Start date
- Status
- Thread starter
- #3
computek353
Technical User
Sorry should have mention that in the first place. It is a memo field.
normally you could use the split() function to split the firld and make a stringvar array, then address the first element of the array. However you cannot use memo fields in formulas so I am at a loss on how to do this. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
714-348-0964
dgilsdorf@mchsi.com
- Thread starter
- #5
computek353
Technical User
Do you think it would cause any problems to just remove the can grow option on the field and size it so only the first line is displayed? I should only have about 30 - 40 records on this report.
- Thread starter
- #6
computek353
Technical User
Do you think it would cause any problems to just remove the can grow option on the field and size it so that only the first line is displayed? I should only have about 30 - 40 records on this report.
- Thread starter
- #8
computek353
Technical User
Yea I just did and it seems to work ok. I think it would really slow the report down if I had more records but as it is I think it will work great.
Thanks for the suggestions.
Thanks for the suggestions.
- Status
Similar threads
- Question
- Locked
- Question
- Question