I have a test site up locally and it points to:

http://localhost/dotnetnuke_2/Home/tabid/36/ctl/Edit/mid/373/Default.aspx

which is fine for testing however when I make a link in one of the contentPanes the link src="/DotNetNuke_2/Portals/....." when this site is live there will be no /DotNetNuke_2/ so how do i get rid of that in my links?

Buying a 3rd party software to fix a problem in my mind is not a solution. The issue of it being part of the HTML editor means that there needs to be a redesign of how it works.

the solution of searching through the content looking for a string to delete seems like something that the current system needs. I'll just make a stored procedure to search through the content and fix it.

-------- Incase someone wants it.........

CREATE PROCEDURE dbo.SPROC_FixContent
@TestFoldername varchar(500)

AS
BEGIN

    SET NOCOUNT ON;

Update dnn_HtmlText
set DesktopHtml = REPLACE(cast(DesktopHtml as nvarchar(MAX)),@TestFoldername,'')