Need help removing 'Dr' prefix from a list of names without causing an infinite loop.

·

have a list of names which proceed with 'dr' which I am trying to remove with a formula {{Name}}?.replace("Dr", "") but Clay is saying this is causing an infinite loop. Please advise. https://app.clay.com/workspaces/206158/tables/t_Ab6Ub4Be5k3Q/views/gv_1lqG6XXCbQxD

Clay Team
APP
·
·
Hi Henry, thanks for getting in touch! please check this:
eab31250-153a-4d4f-8b78-6e860792ce15.png(78 kB)
Henry S.
·
·
Still having the same issue saying it will cause an infinite loop so it can't be applied
Clay Team
APP
·
·
no, please check the last column and the formula I created
Henry S.
·
·
sorry, I see a new column has to be made