Topic Options
#58107 - 07/15/21 10:30 AM Check if text is present at a location in Design
downd Offline
OL Newbie

Registered: 08/17/11
Posts: 19
I need to create a condition to check if text is present at a location, row 79, column 29.

I had some notes from earlier and found this =trim(@(65,79,96))="

I believe that was check for text but I am not certain as it dosen't work when I tried =trim(@(79,29,29))="

I searched the forum and found a workflow solution but nothing for Designer.
Thanks


Edited by downd (07/15/21 10:31 AM)

Top
#58108 - 07/15/21 10:55 AM Re: Check if text is present at a location in Design [Re: downd]
MartinS Offline
OL Guru

Registered: 08/06/12
Posts: 129
Loc: Munich
try with =length(trim(@65,79,96))>0

Top
#58109 - 07/15/21 11:13 AM Re: Check if text is present at a location in Design [Re: downd]
downd Offline
OL Newbie

Registered: 08/17/11
Posts: 19
=length(trim(@(79,29,29)))>0

I needed an extra bracket after the @ before it would save.

It always returns the same condition with data present or not frown

I am looking at one column, I made it two to see if that made a difference, no luck =length(trim(@(79,29,30)))>0


Edited by downd (07/15/21 11:16 AM)

Top
#58110 - 07/15/21 11:51 AM Re: Check if text is present at a location in Design [Re: downd]
downd Offline
OL Newbie

Registered: 08/17/11
Posts: 19
It worked! Thank you for you help

I wrote down a 9 instead of a 0 it should have been!! lol

I also realized this command works =trim(@(70,29,30))=''

it is two apostrophes at the end, I was typing a single quote "


Edited by downd (07/15/21 12:18 PM)

Top