Hi All
I'm having trouble exporting a view via Lotus Script to Excel. The export agent loops through all the documents in a view, and uses the ColumnValues property of NotesDocument so that the exported table contains the same data as the view.
That was the theory, anyway.
In order to deal with overly descriptive titles, I use the following formula to truncate the documents' titles in the view:
breaks:=",":".":"/":"\\":"-":"_":";":":":"(":")":@Char(10);
Full:=RFCTitle + " ";
Trim:=@Left(Full; 75);
@If(@Length(Full) < 76;Trim;
@Do(
n:=76;
@While(
@IsNotMember(@Middle(Full; n-1; 1); breaks);
Trim:=Trim + @Middle(Full; n-1; 1);
n:=n+1
);
Trim
)
)
This works in the view - it truncates the value in the field RFCTitle to 75 characters or the shortest string that is more than 75 characters and ends in a complete word.
However, the output in Excel is showing longer strings than the view. For example:
Value in document - {To stop Rbook rebuilding past orders and downloading to Handheld. Customers which register with milk&more but do not place an order for some time are causing the RoundMaster hand-held to process deliveries for the customer from the registration date to the current date.
Step 1. Release to Wimbledon Sunday 13th Oct
.Step 2. and Step 3 will be raised as a seperate RFC
}
Value in view - {To stop Rbook rebuilding past orders and downloading to Handheld. Customers which}
Value in Excel - {To stop Rbook rebuilding past orders and downloading to Handheld. Customers which register with milk&more but do not place an order for some time are causing the RoundMaster hand}
I've rebuilt the views in the application, and I've restarted my Notes client. I'm at a loss - any ideas?
TIA!
 
Feedback number WEBB95JG4F created by ~Joseph Zekponelyoni on 03/06/2013
Status: Closed
Comments: Never mind - I wrote a function in the agent to duplicate the effect of the formula, and that seems to be doing the trick.
|
Return to top
Printer-friendly
