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.

[phottovy · Accepted solution]

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:

[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.