|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
09-01-2007, 10:33 AM
|
#1 |
|
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] |
|
|
|
09-01-2007, 10:47 AM
|
#2 |
|
Confirmed User
Join Date: Jan 2005
Posts: 2,640
|
Import the list into Excel or another spreadsheet program and choose | as the delimiter... then just delete the columns you don't want.
__________________
 viki [at] realsexcash [dot] com 228 263 454 |
|
|
|
|
09-01-2007, 11:03 AM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Posts: 8,062
|
ok now i got another problem. the list looks like this:
33996344|33996351|United Kingdom| 50331648|68257567|United States| 68257568|68257599|Canada| 68257600|68259583|United States| 68259584|68259599|Canada| 68259600|68296775|United States| 68296776|68296783|Mexico| 68296784|68298887|United States| 68298888|68298895|Canada| 68298896|68305407|United States| but i need to add the | in the beinning of each line like this: |33996344|33996351|United Kingdom| |50331648|68257567|United States| |68257568|68257599|Canada| Any ideas?
__________________
Programs that owe me money ---- Epassporte.com ~ $2700 | Protraffic.com ~ $2600 | XonDemand.com ~ $3000 Email: [email protected] |
|
|
|
|
09-01-2007, 11:04 AM
|
#4 |
|
赤い靴 call me 202-456-1111
Industry Role:
Join Date: Feb 2001
Location: The Valley
Posts: 14,831
|
open it back up in excel and add a new column to the left of your data? Would that work?
__________________
SPECIALTY COSTUMES • PROPS • FX Superheroes • Monsters • Robots PM for details For any manufacturing needs. Adult or otherwise. aka BonsHigh on Insta Bonsai weed plants |
|
|
|
|
09-01-2007, 11:07 AM
|
#5 | |
|
Too lazy to set a custom title
Industry Role:
Join Date: Jun 2005
Location: 127.0.0.1
Posts: 27,047
|
Quote:
__________________
Make Money
|
|
|
|
|
|
09-01-2007, 11:07 AM
|
#6 |
|
赤い靴 call me 202-456-1111
Industry Role:
Join Date: Feb 2001
Location: The Valley
Posts: 14,831
|
if that WON'T work, then maybe open in excel, add a column and add a character that you know you can mass replace something like:
zzzz|33996344|33996351|United Kingdom| zzzz|50331648|68257567|United States| zzzz|68257568|68257599|Canada| Then just do a mass search and replace for "zzzz" it will remove the "zzzz" and leave a pipe. yes? no? maybe so?
__________________
SPECIALTY COSTUMES • PROPS • FX Superheroes • Monsters • Robots PM for details For any manufacturing needs. Adult or otherwise. aka BonsHigh on Insta Bonsai weed plants |
|
|
|
|
09-01-2007, 11:13 AM
|
#7 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Posts: 8,062
|
ok thanks every1 it worked!
__________________
Programs that owe me money ---- Epassporte.com ~ $2700 | Protraffic.com ~ $2600 | XonDemand.com ~ $3000 Email: [email protected] |
|
|
|
|
09-01-2007, 11:15 AM
|
#8 |
|
Confirmed User
Join Date: Jan 2005
Posts: 2,640
|
Or open it up in a text file, find
"| " (that would be the pipe at the end of one line and an enter key and then replace with "| |" There are tons of ways to do this - find, replace, cut, copy, and paste are all your friends.
__________________
viki [at] realsexcash [dot] com 228 263 454 |
|
|
|
