Replace function with error coz of the data does not contain

Hi,

I would like to ask about how should I set up the workflow to replace a string in a column, say from 'TBDstudent1' to 'ABCstudent1' and 'TBDstudent2' to 'ABCstudent2' etc.

I am currently using the 'Replace' function, however, when a batch of data does not contain a certain string 'TBDstudent1', error occurs. How shall I design the formula or utilise the tool that the replace function only be performed when the column contains such specific target, so that I do not need to modify the workflow each time?

Thanks!

Cheers,

Accepted answers

grazitti_sapna

Hi @Jwwwson , you can use if else condition in the formula tool, as there is just one example for replacing TBD with ABC so it works if you have any other conditions to be specified you can modify the formula and use elseif. Please follow the screenshot for clarity.
Let me know if that helps.

Formula- if Contains([Field1],"TBD") then Replace([Field1], "TBD", "ABC") else [Field1] endif

All comments

grazitti_sapna

ChrisTX

The REPLACE function itself will not generate an error if the search string is not found. The error must me somewhere else in your workflow.

Which tool is generating the error? Can you post a copy of your workflow, including sample input data?

Chris

Jwwwson

Thanks @grazitti_sapna ! It works!

May I ask one more question, does IF function includes two criteria, one is A column(job name) include a specific wordings and the second criteria is column B Does not contain certain wordings, and if the criteria are fulfilled, the wording of another column (Booking Type_) will be changed, otherwise it will remain as original. The formula is shown below, however, the output is always null, would you please kindly advise if anything goes wrong? Thanks!

IF Contains([Job name], "BUSINESS DEVELOPMENT") AND !Contains([Manager], "Peter" OR "Amy") then Replace([Booking Type_], "Non A", "A") else [Booking type] endif

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703