GoFuckYourself.com - Adult Webmaster Forum - View Single Post

zentz · 09-01-2007, 10:33 AM

I have a long list like this:

collumn1|collumn2|collumn3|collumn4|collumn5|collu mn6|
2.6.190.56|2.6.190.63|33996344|33996351|GB|United Kingdom|
3.0.0.0|4.17.135.31|50331648|68257567|US|United States|
4.17.135.32|4.17.135.63|68257568|68257599|CA|Canad a|
4.17.135.64|4.17.142.255|68257600|68259583|US|Unit ed States|
4.17.143.0|4.17.143.15|68259584|68259599|CA|Canada |
4.17.143.16|4.18.32.71|68259600|68296775|US|United States|
4.18.32.72|4.18.32.79|68296776|68296783|MX|Mexico|
4.18.32.80|4.18.40.135|68296784|68298887|US|United States|
4.18.40.136|4.18.40.143|68298888|68298895|CA|Canad a|
4.18.40.144|4.18.65.255|68298896|68305407|US|Unite d States|
4.18.66.0|4.18.67.255|68305408|68305919|MX|Mexico|
4.18.68.0|4.18.100.31|68305920|68314143|US|United States|

Now i want to remove the collumn1, collumn2 and collumn5 so i get this format:

|collumn3|collumn4|collumn6|
|33996344|33996351|United Kingdom|
|50331648|68257567|United States|
|68257568|68257599|Canada|

What is the easiest way to do this? Are there any tools for stuff like this?

Thank you!

09-01-2007, 10:33 AM
zentz Confirmed User Industry Role: Join Date: Nov 2003 Posts: 8,062	need help with some text formating I have a long list like this: collumn1\|collumn2\|collumn3\|collumn4\|collumn5\|collu mn6\| 2.6.190.56\|2.6.190.63\|33996344\|33996351\|GB\|United Kingdom\| 3.0.0.0\|4.17.135.31\|50331648\|68257567\|US\|United States\| 4.17.135.32\|4.17.135.63\|68257568\|68257599\|CA\|Canad a\| 4.17.135.64\|4.17.142.255\|68257600\|68259583\|US\|Unit ed States\| 4.17.143.0\|4.17.143.15\|68259584\|68259599\|CA\|Canada \| 4.17.143.16\|4.18.32.71\|68259600\|68296775\|US\|United States\| 4.18.32.72\|4.18.32.79\|68296776\|68296783\|MX\|Mexico\| 4.18.32.80\|4.18.40.135\|68296784\|68298887\|US\|United States\| 4.18.40.136\|4.18.40.143\|68298888\|68298895\|CA\|Canad a\| 4.18.40.144\|4.18.65.255\|68298896\|68305407\|US\|Unite d States\| 4.18.66.0\|4.18.67.255\|68305408\|68305919\|MX\|Mexico\| 4.18.68.0\|4.18.100.31\|68305920\|68314143\|US\|United States\| Now i want to remove the collumn1, collumn2 and collumn5 so i get this format: \|collumn3\|collumn4\|collumn6\| \|33996344\|33996351\|United Kingdom\| \|50331648\|68257567\|United States\| \|68257568\|68257599\|Canada\| What is the easiest way to do this? Are there any tools for stuff like this? Thank you! __________________ Programs that owe me money ---- Epassporte.com ~ $2700 \| Protraffic.com ~ $2600 \| XonDemand.com ~ $3000 Email: [email protected]