Removing certain lines with containing a specific data

  • Thread starter Thread starter ivers
  • Start date Start date
I

ivers

I got this problem, I'm trying to remove lines that contain certain
data.

I got 9000 articles in my webshop, but the company that deliveres us
the price list has changed all their methods and won't give me the way
to convert the text file into a readable excel database.

For each of the articles its 3 lines.
Line 1 Column A contains "4100"
Line 2 Column A contains "4300"
Line 3 Column A contains "4850"

I want to remove Line 2 and 3.

Here's an image of it:

[image: http://www.forretninger.no/w00t.jpg]

There is 27000 lines in the file.. I need to remove line 2 and 3 of
each article, to shrink the database to 9000 lines.. Its a lot of work
removing em manually.

I can't figure out this thingo... used a lot of time experimenting, and
googling, resulting me to ask here.. Thanks in advance :rolleyes:
 
To remove lines 2 and 3 of each article :
(make a backup copy of the data file before you delete the records)

1. Insert a column to the right of column A.
2. Type an x in cell B2, and in cell B3
3. Select cells B1:B3
4. Double-click the fill handle (the small black square at the
bottom right of the selection
5. Select cell B2, and choose Data>Filter>AutoFilter
6. From the dropdown list in cell B1, select the x
7. Select the visible rows in the table
8. Choose Edit>Delete
9. CHoose Data>Filter>AutoFilter to remove the filter
10. Delete column B

I got this problem, I'm trying to remove lines that contain certain
data.

I got 9000 articles in my webshop, but the company that deliveres us
the price list has changed all their methods and won't give me the way
to convert the text file into a readable excel database.

For each of the articles its 3 lines.
Line 1 Column A contains "4100"
Line 2 Column A contains "4300"
Line 3 Column A contains "4850"

I want to remove Line 2 and 3.

Here's an image of it:

[image: http://www.forretninger.no/w00t.jpg]

There is 27000 lines in the file.. I need to remove line 2 and 3 of
each article, to shrink the database to 9000 lines.. Its a lot of work
removing em manually.

I can't figure out this thingo... used a lot of time experimenting, and
googling, resulting me to ask here.. Thanks in advance :rolleyes:
Click to expand...
 
Back
Top