Replace ~The with The and moved to the start of a line

Question

I'm redoing an existing web site in ColdFusion and mysql that was originally created in php and mysql, so the database already exists. There is a table of titles which show in the database as "Church: The Figure of the Flock~The", though on the page are displayed as "The Church: The Figure of the Flock" this is so the title is ordered by Church and not The. So I need to strip out ~The and insert The at the start. I would appreciate it, if someone could point me in the right direction how to achieve this. The same applies to ~A. Thanks

JR__Bob__Dobbs · Accepted Answer

You could use CF's list functions to split the string up treating the tilde character as the list's delimiter.

Here is a quick sample.

You might wrap this into a user defined function that checks for the existence of the tilde character in the title string.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded