Thanks Rahul.
RP, the formula I gave you was based under the impression that all of the "date rows" had the word 'Process' in them. It was looking for that word and trimming from that. Since this is not the case it was not working.
Rahul's suggestion is doing the same process but keying off the first time the ':' character appears reading right to left.
To avoid further confusion there are two things that must be in place for this to work for you.
1. When the row starts with a date there is never a : field to the right of the seconds indicator in the string we are trimming. You will have to scan your data to figure that out.
2. The first part of the formula is working which is looking a the first 10 characters and seeing if it is a date. You can create a formula field to check this. isdate(left({probsummarym1.brief.description},10))
If you put this in your report it should say TRUE for any date rows and FALSE for anything else.
IF both of these are OK then use Rahuls formula as:
if isdate(left({probsummarym1.brief.description},10))=true then
right({probsummarym1.brief.description},len({probsummarym1.brief.description})-instrrev({probsummarym1.brief.description},":")-2)
else {probsummarym1.brief.description}
Hope this clears it up for you.
IP Logged
