displaying the last line of a field 2

[sccice]

In one of my databases i have a feild that shows the document update data this includes user who updated it and the date and time all concatenated into one line. when someone updates the document a new line is written. in a view i wish to show the last line written but do not know how to do this could you help please.

 

[ashusaxena]

If you are having a multivalue field, you can try some text functions to take out the last value from the field.
For e.g., if your field is set in such a way that, multiple values are stored with a comma between them,
If Fieldvalue is "asb 10:20PM ; asdwqe 11:20AM" etc etc,
you can rrite a functionin the View Column formula as:
@RightBack(FieldValue ; ";&quot.
This function gives the rightmost characters from the variable seperated by the delimiter which in this case is semicolon.
So the result of the above function wil be "asdwqe 11:20AM"

 

[marthag]

@Subset( fieldname; -1 ) will return the last value in a list. Or, if the most recent value were at the beginning of the list, you would use @Subset( fieldname; 1 )