AnsweredAssumed Answered

find replace for table realign

Question asked by jtorpy on Feb 26, 2018
Latest reply on Feb 28, 2018 by beverly

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.