messy text string clean

[BosKev]

Hi,

any way to clean up the string samples below into an ideal output? as you can see there are many names, punctuations that I do not want to see. My goal is to clean up this field and bee able to put the clean up text into various category. Thanks.

sample text

FEE FOR PROFESSIONAL SERVICES RENDERED IN RESPECT OF AN APPLICATION FOR SHORT STAY WORK VISA . FEE APPROVED BY xxxxx ON -OCT-. AUD$. +GST CONVERTED TO USD - OUT OF SCOPE

GOVERNMENT FEES PAID ON YOUR BEHALF. AUD .

FOR PROFESSIONAL SERVICES RENDERED WITH RESPECT TO THE COORDINATION OF IMMIGRATION REQUIREMENTS - WORK PERMIT CANCELLATION - USD

FOR PROFESSIONAL SERVICES RENDERED WITH RESPECT TO THE ASSESSMENT FOR WORK PERMIT   USD,

GOVERNMENT FEES PAID ON YOUR BEHALF - RESIDENCE PERMIT . CNY

ideal output

FEE FOR PROFESSIONAL SERVICES RENDERED IN RESPECT OF AN APPLICATION FOR SHORT STAY WORK VISA

GOVERNMENT FEES PAID ON YOUR BEHALF or GOVERNMENT FEES PAID

FOR PROFESSIONAL SERVICES RENDERED WITH RESPECT TO THE COORDINATION OF IMMIGRATION REQUIREMENTS

FOR PROFESSIONAL SERVICES RENDERED WITH RESPECT TO THE ASSESSMENT FOR WORK PERMIT

GOVERNMENT FEES PAID ON YOUR BEHALF - RESIDENCE PERMIT

[cplewis90 · Accepted solution]

Hey @BosKev,

I was able to get pretty close to what you are looking for. It may be easier to do some sort of find replace with this, but I wrote a formula that gets most of the cleanup done for you. Obviously if there are any new rules introduced you would need to adjust this formula. I have attached the workflow for you to see.

[BosKev]

Thanks, this works ...was going the Regex route then but it would only clean one thing at a time.