Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Finding a space in a string

I have quite a few different text fields that are of varying length - some examples are:

"F.S. 196 requires beneficial use of property by homestead recipient on January 1st of assessment roll for which it is claimed. Subject property is currently rented. No response from property owner to rental letter sent by property appraiser. "


"Unable to determine residency of applicant pursuant to F.S. 196.011."

I am trying to get this text to display on multiple lines, but the first line is shorter than the following ones; it only should fit about 45-50 characters (that number includes spaces). Therefore, the first example I gave should read

"F.S. 196 requires beneficial use of property by" on the first line, but the second would read

"Unable to determine residency of applicant".

I cannot just write a simple LEFT() formula and I don't want to write a ton of IF-THEN statements, and for the life of me I can't remember how to find a space in a string, especially if it's not just a two word string with a single space.

Former Member

Hi Holly,

If you don't want to use left() function and if statements then I think it is better to fix the Text objects size with some width and uncheck the option "Can Grow" by right clicking the object>Format Field>Common Tab-->Can Grow.

Do the same for the other text field also so that both the text fields are of same width and will show only the data that exist in that width.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question