If/Then trouble

Question

Source

PCCBM3CBM7NON CBM8NON CBM3NON CBM7NON CBM8CBM3CBM7CBM8CBM

Desired Output

PCCBM33CBM7NON CBM8NON CBM3NON CBM7NON CBM33CBM33CBM33CBM33CBM

I am trying to use the formula tool to change the PC, where CBM = CBM, when CBM= NON CBM, I want it to stay the same

any tips?

Sebastiaandb · Accepted Answer

@nihou

Here you go:

This should work out for you! Just let me know if this is what you're looking for! Greetings Seb

dbmurray · Accepted Answer

Here's an alternate flow that does _exactly_ what you're asking and simply replaces PC with 33 if CBM is in the CBM column.