Hello,
I have SQL dumps that must be "cleaned". Below is a sample of the text.
Original text before edit:
I want it like below after edit:
There are many sensitive characters in the file like ',; etc. because this is an SQL dump.
So does anybody here know how to do that? I try find and replace one by one every character, but there are too many different word in file.
Or if interested I am offering this job to UltraEdit developer or other members here who are experts on using UltraEdit.
I have a lot of SQL dumps that must be "cleaned". So if this job is NOT FREE, I will pay for it.
Regards,
Ringo
I have SQL dumps that must be "cleaned". Below is a sample of the text.
Original text before edit:
Code: Select all
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(9, 'Bim Bousman', 'Hello', '2003-04-18 12:27:00', '<table border=0 cellpadding=2 cellspacing="0"><tr><td>
<pre>Hello All,
Just want said hello to everyone.
Bim Bousman
Honolulu
************************
From: <<a href=forum/postID=ewrjw_-O7iw4x2sTK0kw8a1-OvSC8_P9qOb9_i80z0HJ4hjYAhmPsSusItNqv7EPSk9b0Sh-PLjtXhEVLViUO8qZnPpALg"></a>>
To: <<a href="forum/postID=ewrjw_-O7iw4x2sTK0kw8a1-OvSC8_P9qOb9_i80z0HJ4hjYAhmPsSusItNqv7EPSk9b0Sh-PLjtXhEVLViUO8qZnPpALg"></a>>
Sent: Thursday, April 17, 2003 9:50 PM
Subject: Hello
>
>
>
> Your advertisement here.Click here for more information.
>
>
><br></pre>
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(10, 'Ferromundo', 'Hello','2003-04-20 20:11:00', '<table border=0 cellpadding=2 cellspacing="0"><tr><td>
<table bgColor="#ffffff"><tr><td>
<div><font face="Arial" size="2">Welcome and enjoy your time.
Thanks
Ferromundo
*********
Avertisement
here
Click mor
e details.
*********
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(11, 'Stanley', 'Hello','2003-04-21 16:22:00', '<table border=0 cellpadding=2 cellspacing="0"><tr><td>
<pre>Hi Ferromundo,
We miss you.When
you can
do war again.Call me after
work hours.
regards
Stanley
=========
Advertisement here
Click more
details.
=========
Code: Select all
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(9, 'Bim Bousman', 'Hello', '2003-04-18 12:27:00', '
Hello All,
Just want said hello to everyone.
Bim Bousman
Honolulu
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(10, 'Ferromundo', 'Hello','2003-04-20 20:11:00', '
Welcome and enjoy your time.
Thanks
Ferromundo
', 0, -1, 0, 0);
INSERT INTO `thread_id` VALUES(11, 'Stanley', 'Hello','2003-04-21 16:22:00', '
Hi Ferromundo,
We miss you.When you can do war again.Call me after work hours.
regards
Stanley
So does anybody here know how to do that? I try find and replace one by one every character, but there are too many different word in file.
Or if interested I am offering this job to UltraEdit developer or other members here who are experts on using UltraEdit.
I have a lot of SQL dumps that must be "cleaned". So if this job is NOT FREE, I will pay for it.
Regards,
Ringo