Processing rich text value

HCL Domino Domino Forum
1

This is for a web application.To save on data entry time I use an editable text field called “LineItem” where user pastes copied text. This field allows for multiple values using a comma to separate three values. A sample entry that a user would paste would be:

“1131-13-1033, 3H, QUARRY HAUL ROADS PLAN SHT 1”

Three computed fields (“DrawingNo”, “Version”, “DrawingTitle”) extract their values from this. Formulas are:

DrawingNo field formula: @Subset(LineItem;1)

(results in “1131-13-1033”)

Version field: @Subset(@Subset(LineItem;2);-1)

(results in “3H”)

DrawingTitle field: @Subset(@Subset(LineItem;3);-1)

(results in “QUARRY HAUL ROADS PLAN SHT 1”)

This works well, no problem, but only when pasting single line of text.

Now I want to use a RichText field instead (to allow pasting multi lines). I call this new rtf field “LineItem_rtf”. I then change the text field “LineItem” to computed, using the formula:

@Abstract([TextOnly];300;“”;“LineItem_rtf”).

The resulting value of the LineItem field looks the same (comma separated) but the the three computed fields now will not work.

I would really appreciate some suggestions. Thanks.

2

Subject: Abstract

First, you have 4 “chained” computed fields (each one is computed based on the value of the previous).Assuming that you placed them one below the other, I’m still not sure they will compute correctly.

Secondly, the Abstract result may not be a list, thus you’d better use @Explode(myfield;", ") to get sure of it before using @Subset.

Thierry Cayla

http://dominoeffects.serveblog.net

3

Subject: Abstract

Yes. that worked! Thank you!