AnsweredAssumed Answered

Nagging Problem in Calculated Field Produces extra space in result

Question asked by bokenrosie on Jan 16, 2015
Latest reply on Jan 21, 2015 by philmodjunk

Title

Nagging Problem in Calculated Field Produces extra space in result

Post

I have a calculated expression that returns some text that is then pasted into another application.  It works well but I have one niggle that I cannot figure out.  In my test for the value of "PreliminaryAmount" I end up with extra carriage returns in the result.  I'll post the code and then the results generated.  Thanks.

CODE BEGIN:

"SALE TIME: "&SaleTimeSpelledOut&¶ & ¶ & 

"Refer to Notice of Sale for further bidding instructions" & ¶ & ¶ & 
If(PreliminaryAmount="yes";
"*Preliminary, subject to change" ;
If(PreliminaryAmount="no";
"";
0))

CODE END:

Result if "Preliminary Amount = yes:

[Begin]SALE TIME: Until 11:00 AM EST

Refer to Notice of Sale for further bidding instructions

*Preliminary, subject to change[End]

Result if "Preliminary Amount = no:

[Begin]SALE TIME: Until 11:00 AM EST

Refer to Notice of Sale for further bidding instructions

[End]

In the result above this one I need [End] to appear after the word instructions.

Thanks for any and all suggestions.

Outcomes