Remove only part of a artist

Support
1

HELP!!

I am looking for help with a field issue.

I have the %ARTIST% field. Within the field some have ft. (other random artist)

How do I just find the tracks with the ft. (other random artist) and remove the ft. (other random artist) and have it placed into the %title% field

example

TITLE---------------------------------ARTIST
Toes----------------------------------Zac Brown Band ft. Jimmy Buffet

I want

Toes ft. Jimmy Buffet------------------Zac Brown Band

2

Have a look at this thread:
how to move (feat.) from title to artist - HELP

3

Thanks but didnt work
I didnt mean to start a new tread but this is what i am at now

Help moving Ft. from artist to title