IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Page 2 of 2 < 1 2
Topic Options
#49872 - 10/24/14 04:50 PM Re: Line Condition - Look a 2 different pieces of Data [Re: Levi]
Levi Offline
OL Newbie

Registered: 05/13/14
Posts: 26
Loc: Austin, Texas
Ok, one final revelation (that I just found, using notepad++) is that there is nothing in the line past column 74, when this situation occurs. Based on what I am seeing in Notepad++, there is a CR and LF immediately after the last character. In the sample data properties box, I deselected the "show selected cells" box, and sure enough, the box after the last line of text (when this situation occurs), is grey (not white).

Maybe I'm wrong, or maybe I'm interpreting it differently, but it doesn't seem to be working with the code provided.

Here is the code I entered:
Code:
=(((@(&current.line,1,2))='  ') AND ((@(&current.line,75,80))='      '))



I almost said, "Not sure where to go from here" ...and then I thought about it.
The first part makes sure to check for the double space (which it does). The means, if there isn't anything in in 75,80 (because it doesn't exist), then that should be my rule!

Where is what I ended up using, which seems to have worked perfectly:
Code:
=(((@(&current.line,1,2))='  ') AND ((@(&current.line,75,80))=''))



Thanks so much for your help, Jeff... you've really been a great help.

Cheers,
Levi

Top
#49881 - 10/27/14 06:54 AM Re: Line Condition - Look a 2 different pieces of Data [Re: ]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1984
Loc: Objectif Lune, Montreal, Qc
So you want your condition to be true when BOTH selections are empty. Just concatenate your selections and trim the result. That trimmed result can only be empty if both selections are empty:

=(trim( @(&current.line,1,2)+@(&current.line,75,80) )='')
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top
Page 2 of 2 < 1 2