Gizmos Freeware Reviews  

Go Back   Gizmo's Freeware Forum > Freeware Forum > General Computer Support

Reply
 
Thread Tools Display Modes
Old 12. Aug 2009, 03:53 AM   #1 (permalink)
Junior Member
 
Join Date: Aug 2009
Posts: 4
Default How do I remove certain text in bulk?

I have a list like the following [bold] line of text that are numbered from #1 to #713. The #, domain names, Day, Date and Time change for each line. I want to remove every thing except the domain names i.e. xxx.com. Every thing I read regarding how to perform this type of procedure confuses me. Could some one please tell me a simple way to do this?

#1 xxx.com Tue, 11 Aug 2009 16:18:04 +0000

Thank you.

Charlie
caktus is offline   Reply With Quote
Old 12. Aug 2009, 04:36 AM   #2 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,829
Default CSVed

Try to run CSVed, mentioned in Free Utility Makes Working With CSV Files Easy and follow these steps:

1. Install and run CSVed
2. At Modify tab, choose Other, enter one blank space in the box.
3. Open your text file containing the list and CSVed will show up your data in 8 columns.
4. At "Delete Columns" box under the same tab, select all columns except column 2 (which is xxx.com), press Delete Columns button.
5. Save the file and done.

Hope this helps.
Jojo Yee is offline   Reply With Quote
Old 12. Aug 2009, 06:04 AM   #3 (permalink)
Junior Member
 
Join Date: Aug 2009
Posts: 4
Default

Thank you, Jojoyee. I will give this a shot.

Charlie
caktus is offline   Reply With Quote
Old 12. Aug 2009, 03:47 PM   #4 (permalink)
Junior Member
 
Join Date: Aug 2009
Posts: 4
Default

Good morning, Jojoyee.

Regarding Step#2 I assume you mean the first of the four Modify Tabs.

Regarding Step #3 "CSVed will show up your data in 8 columns." Only one column appeared with the entire text. Could this mean that the Original text was not fromated in columns?

Thank you,

Charlie

EDIT: I just tried it again but the text file did not appear in the Columns box and niether did any colums. I even uninstalled and reinstalled CSVed and tried again but the same problem occured.

Last edited by caktus; 12. Aug 2009 at 04:05 PM. Reason: new/additional problem.
caktus is offline   Reply With Quote
Old 13. Aug 2009, 03:29 AM   #5 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,829
Default

Quote:
Regarding Step#2 I assume you mean the first of the four Modify Tabs.
Yes, you're right.

Quote:
Only one column appeared with the entire text. Could this mean that the Original text was not fromated in columns?
I'd assume that your data appears as follows, in a text form:

#1 xxx.com Tue, 11 Aug 2009 16:18:04 +0000
#2 xxx.com Tue, 11 Aug 2009 16:18:04 +0000
#3 xxx.com Tue, 11 Aug 2009 16:18:04 +0000
...

There're seven spaces in each row of the text above.

Before opening the text file, make sure you've selected "Other" (in "Set Separator" under the Modify tab) and entered one blank space in the box given (click inside the box and press space bar once).

Having done that, when opening the text file, CSVed will use the blank space as a separator and divide the above text rows into eight columns (by the seven spaces). It works when I used the above text as a sample.
Jojo Yee is offline   Reply With Quote
Old 13. Aug 2009, 04:17 AM   #6 (permalink)
Junior Member
 
Join Date: Aug 2009
Posts: 4
Default

Thank you, Jojoyee.

The files we're in the format as you posted.

It turns out the content of the text file I wanted to edit has disapeared, nothing left but an empty notepad.txt. I guess I did some thing really wrong. And it seems it cannot be restored. When or if I manage to recover it I will make an extra copy or two and try it again.

Charlie
caktus is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +1. The time now is 05:22 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.