Formula tool in analytic app tool. Parse error at char.

wonka1234

Hi,

I am getting error

Why am I getting this? I am trying to be able to alter:

1) the Column name from the formula tool dropdown

2) the column name in the formula tool

3) the special character to replace with ""

Ie it should go from String-sfs-asda-te to Stringsfsasdate

any help would be appreciated.

replace character error.yxwz

Custom Tools

Accepted answers

phottovy

Hi @wonka1234 ,

There error is caused by action tool 5. By selecting to replace the underscore in your formula, this action tool will also replace the underscore in "CCOA_String" causing the formula to have an error since it cannot locate the updated column name:

I plugged in "6" as my replacement character and now the formula looks like this:

All comments

phottovy

Hi @wonka1234 ,

I plugged in "6" as my replacement character and now the formula looks like this:

wonka1234

@phottovy ah thanks, not sure how i missed that... what would be the best to put in here instead of "_" ?

Dina

I guess you were trying to replace "-" with your test. Since the column name also has "_", when the workflow runs, it changed your formula to Replace([CCOA-String], "-", ""), which [CCOA-String] doesn't exist.

To resolve that issue, I updated your Action (5) to replace "_". When you run the app you need to input as "-"(with quotation mark around the character).

I also updated your Action (3), in case you want to apply to a different column.

replace character error - Updated.yxwz

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703