90 Minds Community

I need help with this formula that I'm trying to create that would only display a certain section of the text. I'm not sure if this is even possible??

I have a memo text in the attachment and I only want to display everything after the 27th space. Hopefully this makes sense.

------------------------------
Shannon Stanley
Sage 100 Consultant
Ardent Consulting LLC
704-839-6697
------------------------------

String functions in Crystal have a limit of 65534 characters. The size of the memo field is 7168 characters. The string function Right(string variable,Len(string variable)-27) would be a start.

Probably should first test the length of string and see if it is greater than 27 characters.

If Len(string variable) > 27 then
  formula = Right(string variable,Len(string variable)-27)
Else
   formula = ""
End If

------------------------------
Myron Stevenson
Consultant
Clearis Consulting, Inc
Duluth, MN
218-525-6720
------------------------------

Right ({IM_ItemMemo.MemoText},len({IM_ItemMemo.MemoText})-27 )

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------