Re: Hi - I can't start a thread in the programming forum

[Smitty7]

Smitty,

Are you trying to upload any links or attachments?

Originally there were urls in the post, but I figured that may be the problem so I replaced them with "URL1", literally like that. The urls were not to link to anywhere, but part of my problem. I'm trying to clean up data from a database and it involves urls. I'll try again in a few minutes.

Thanks!

---------- Post added at 08:53 AM ---------- Previous post was at 08:47 AM ----------

I just tried posting again in the programming and misc. sections and it did't work.

If a mod could move this to the programming section it would be much appreciated!

I have a large list of data in a .txt file (LIST 1) that contains over 100,000 entries of website urls surrounded by a database reference number and special shortcodes like: (I removed actual url format due to not being able to post)

18967[abs]URL1[abs]wp[abs]0[abs]active
18968[abs]URL2[abs]wp[abs]0[abs]active
18969[abs]URL3[abs]wp[abs]0[abs]active

I will have to split it up into at least 2 worksheets due to the large number of entries.

I have a small list of urls (LIST 2) without the special code or database numbers in a column of another worksheet such as:

URL1
URL3

I want to delete all rows from my LIST 1 that contain urls from LIST 2.

Thanks!

[Cutter]

Hi Smitty7

As you can see I've moved your post like you asked. The system is not allowing title change amendment right now so please try at various times to do so. Thanks.

[Smitty7]

Hi Smitty7

As you can see I've moved your post like you asked. Please amend the title so that it complies with the forum rules. Thanks.

Hi Cutter. Thank you for moving the post. I tried to amend the title, but I got the same result - white screen. I was trying to change the title to "Delete Rows from Worksheet Based on Data from Another Worksheet".

Do you have any idea why this is happening? I'm using FF 13.0.1 and I've tried IE 8. I hope this post works!

[Cutter]

There is an obvious glitch in the system today. I just tried to change the title for you but got "Access to the web page denied" error (in Chrome).

I'll edit the request for title change (hopefully).