|
|
|
|
||||
|
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 |
10-20-2016, 11:08 AM
|
#1 |
|
Too lazy to set a custom title
Industry Role:
Join Date: Mar 2004
Posts: 16,116
|
Excel users - need help!
I have 3,000+ items in column A. This column has urls. Within the urls are numerical ID's which I need to extract and place into column B.
The ID's are like this - site.com/blah/2091/index.html. So, column B would only show 2091. I know there has to be an easy way to do this. Anyone? 
__________________
Your Paysite Partner Strength In Numbers! StickyDollars | RadicalCash | KennysPennies | HomegrownCash |
|
|
|
10-20-2016, 11:28 AM
|
#2 |
|
Too lazy to set a custom title
Industry Role:
Join Date: Mar 2004
Posts: 16,116
|
Ah, got it using text to columns.
__________________
Your Paysite Partner Strength In Numbers! StickyDollars | RadicalCash | KennysPennies | HomegrownCash |
|
|
|
|
10-20-2016, 11:32 AM
|
#3 |
|
🚨 PBBC International 🚨
Industry Role:
Join Date: Apr 2010
Location: /👁\
Posts: 9,932
|
if all the urls are in the same
site.com/blah/####/index.html format I would find for "site.com/blah/" and "/index.html" and replace them all with nothing in notepad or something. You'll be left with just the numbers. Then just copy and paste them into column 'B' |
|
|
|
|
10-20-2016, 11:42 AM
|
#4 |
|
It's 42
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
|
'/' is the delimiter like the , in a CSV ...
|
|
|
|
|
10-20-2016, 12:17 PM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Aug 2005
Location: YUROP
Posts: 8,592
|
I would just do that in notepad++ using regex
__________________
 Use coupon 'pauljohn' for a $1 discount at already super cheap NameSilo!Anal Webcams | Kinky Trans Cams Live | Hotwife XXX Tube | Get your Proxies here |
|
|
|
