Replace text

[Chapin4u]

Hi, please help me with the following question. I need to replace the text highlighted in yellow for only that cell marked in red. If I do a replace text it will also change the other exact words which I don't want to happen. Is it possible? Thanks

[Anonymous · Accepted solution]

Hi,

In your Query Editor, add an index column and a custom column that looks for both the value you want to change and the ID that identifies the row.

Sub Category 2 = if ( [index] = 62 and [Sub Category] = "Mercadeo y Publicidad" ) then "Salario e Incentivos" else [Sub Category]

Remove Sub Category and rename Sub Category 2 to Sub Category.

Regards.

[waltheed]

What data identifies that cell marked in red? 

Is it the account AGUINALDO? Are there any other fields?

You could do something like:

Column = IF([Accounts] = "AGUINALDO" , SUBSTITUTE([Sub Category], "Salario...", "Mercadeo..."))