I'm trying to reorganize a table. I have something like Month, Income, Expense.
I want to standardize the table to have Month, Account, Amount.
The idea is to import Month and Income into Month and Amount, then Find/Replace the blank account field with "Income".
Then import/add records and find/replace again.
But it's just not replacing. I see online in the find/replace dialog to put "=" to find blank. But that doesn't work in the scripted find/replace dialog. I tried "" but that didn't do it.
for the first one -
Replace Field Contents [targetTable::Field; Substitute(targetTable::Field; ""; "Income")]
I'm open to various options there.