Joined: 20 Nov 2007
Online Status: Offline
Posts: 33
Topic: selective suppression Posted: 27 Feb 2008 at 12:20pm
I need to suppress everything after the asterisks in a job description when this report is run. The amount of asterisks is not always the same (humans), can this be done?
(You may not need the "+ 1"....I always have problems remembering when to use it when working with parts of strings.) The "InStrRev" looks for the first asterisk from the right in the string and returns its position
Use this formula on your report instead of the field.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
