My table.field is called {AC_ECONOMIC.KEYWORD}. Below is showing my KEYWORD results, CHR_FLAG formula and next to it is what I would like my end result to look like incorporating the CHR_FLAG formula. I am not attached to the CHR_FLAG formula so if there is a simpler or more efficient formula to use I am open to suggestions. Basically, I need a formula to replace the quote character with the previous KEYWORD. I first made a formula called CHR_FLAG
CHR_FLAG = IF {AC_ECONOMIC.KEYWORD} = CHR(34) THEN TRUE ELSE FALSE.
KEYWORD CHR_FLAG END RESULT
RECORD 1: GAS/OIL FALSE GAS/OIL
RECORD 2: " TRUE GAS/OIL
RECORD 3: " TRUE GAS/OIL
RECORD 4: " TRUE GAS/OIL
RECORD 5: OIL FALSE OIL
RECORD 6: " TRUE OIL
RECORD 7: GAS FALSE GAS
RECORD 8: WTR/OIL FALSE WTR/OIL
ECT...
I then made a formula attempting to use Previous function and it did not work fully. Any help would be greatly appreciated!
Thanks,
Micdavis
