Forum Discussion
Replace text
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
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.
2 Replies
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.
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..."))
