THE BORE
General => The Superdeep Borehole => Topic started by: demi on June 18, 2012, 03:42:54 PM
-
:nsfw
-
Still makes more sense than a Martin Raperman thread
-
Oh I know.
-
I have a string
src="/v/pdf/Hussmann/image/GSVM4060/GSVM40601.png"
I need to extract the bold and plop them in their own columns (for future use)
The bolded are variable length for different values
I tried to read about the text functions but its way over my head... or rather theres no good instructions on how to understand this
Any ideas? Is there a quick n easy formula that says "grab whatever is between X and Y" ?
-
I know nothing about excel but
http://www.techrepublic.com/article/the-fastest-way-to-parse-text-in-excel/1033359
and use "/" as your delimiter.
-
That would work if it was just that one line.... but its pretty much a chunk of HTML in each cell
-
try this
http://stackoverflow.com/questions/1031305/simulate-string-split-function-in-excel-formula
-
I haven't the slightest what any of that means.
-
Can you use text to columns and use / as the divider? Just make sure you have an extra column next to your original column or it'll write over whatever is in the next column.
I'd copy and paste the original column in a new column and try that, and then mark the unneeded info as "Do not convert" or whatever the hell it says.
-
Maybe this will work - it doesn't matter how long the strings are, it relies on the text "pdf/" and "image/" appearing directly before the data you want. First screenshot is the forumlas, the second screenshot is the results:
(http://i45.tinypic.com/r7kn6g.jpg)
(I made a mistake in cell B4, is should say A5, not A2). If 20 letters is not long enough to cover the longest names or whatever, increase it. You don't need column B at all, I just put it in to make is clearer how the formula in column C works.
-
Wow thats a lot of work Bildi, I appreciate it. I'll try it when I go in tomorrow. You have the right idea though. There will be different names for both bolded items, so I need something that can basically say "grab between X and Y"
If I have to clean some letters, that is easy enough to do manually.