Column Selection Qusetion

I am using R5.
I have a subform that displays the history of changes made to the form that it is included in.  The various fields contain multiple values each seperated by a CR.  I would like a formula to use in a column in a view that will cause the last value in a field.  For example, the column will display the "Date last Modified" or "Last Changes Made".  I suppose I could write an hidden field which contains the last entry only, but I wondered if it was possible using a formula.
Thanks
Chris_mAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nBladeCommented:
you mean something like  @subset( YourFieldName; -1 )    ?
HemanthaKumarCommented:
You can do that using @Subset to get nth element in a list.

For eg: If the data is stored like this

Date Last Modified:  1/1/2002,2/2/2003
Last Changes Made: TEST1,TEST2

@Subset(@Text(DateLastModified);1) give Ist element in the list i.e. 1/1/2002

Similarly @Subset(@Text(DateLastModified);-1) give Ist element in the list i.e. 2/2/2003

You can use the last formula in the column to extract the last entity in the list. There is no need for any extra field to hold last entry

~Hemanth
qwaleteeCommented:
Woa!  Multiple values separatd by carriage returns?  I hope you really mean t to say "Multi-value field (via the field property Allow Multiple Values), with the display separator set to New Line."

If that's what you meant, then @SyubsetfieldName;-1) will work.

If that is not what you meant, then run-don't-walk to you designer client, and fix it.  then run an agent to update the existing values:
FIELD fieldName := @Explode(fieldName;@NewLine);
SELECT @all

Or, if you coded it differently:
FIELD fieldName := @Explode(fieldName;@Char(13) : @Char(10));
SELECT @all


You may also need to update your formulas for this field.

If you really don't want to fix it, then use @Word(fieldName; @NewLine; -1) or @Word(fieldName; @Char(13); -1) or @Word(fieldName; @Char(10); -1) depedning on how you created your CR's

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Chris_mAuthor Commented:
I have tried that but it doesn't display anything.
qwaleteeCommented:
Find one of the documents in the view.  Wtgout opening the document, open the document proeprties, go to the second tab (field list), select your history field.  Select all text in the right-side, press contrlol-c to copy, and paste here.
qwaleteeCommented:
So, what did you do?
Chris_mAuthor Commented:
I posted my comment "I have tried that..." without having read your Woa!"  I had it set to Rich Text and inserted the CRs myself. When I changed it to Text and "Multi-value field (via the field property Allow Multiple Values), with the display separator set to New Line." It worked (but I still had to insert the <CR> myself via the Lotus Script).
Regards
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.