Replace Blank Cell With Substitute DAT o Python

Beginners
,
1

Hello TD-Forum,

unfortunately I can not find the answer to my problem.Maybe you know how to replace an empty cell with the substitute dat or python. I bet its easy, but cant wrap my head around…

Thanks in advance
Ezka

blank_me
blank_me1160×535 66 KB

dont_be_blank.toe (4.1 KB)

2

Do you just want to replace blank entries with some default text?
If so, append an Evaluate DAT.
Set the Expression parameter to: me.inputCell.val or ‘some_default_text’
for example.

Cheers.

3

Hello Rob,
I want to replace the blank cells with a specific text.

4

Yes. I meant for you to actually include the full text:

me.inputCell.val or ‘some_default_text’

Python will include the cell value (or if that is blank) the quoted portion above.
Cheers

5

blank_me_to
blank_me_to1672×651 78.8 KB

What am I missing?

Thanks in advance

6

Hehe. Sometimes the syntax can be a bit ambiguous.
The ‘or’ is part of the python expression:

me.inputCell.val or ‘some_default_text’

Type in the whole thing! :slight_smile:

7

Ambiguous or i’ve been up way too long. Thanks again rob. That was the last problem to solve for the Project

1 Like