LessThanDot

by **chrissie1** on Fri Jul 11, 2008 8:47 am

This puzzle is not very complicated :-)

Let's say you have the following 4 items:

C:\data\old\one.jpg
C:\data\old\one.two.jpg
C:\data\new\newer\three.wav
C:\Documents and Settings\My Music\Amazon MP3\The Doors\Gloria.mp3

You have to split this data and also show how many folders are in the path.

The output has to be like this (including the names):

Extension	NameOfFile	TotalPath	NumberOfFolders
jpg	one	C:\data\old\	2
jpg	one	C:\data\old\	2
wav	three	C:\data\new\newer\	3
mp3	Gloria	C:\Documents and Settings\My Music\Amazon MP3\The Doors\	4

Take a look at the 2nd item (C:\data\old\one.two.jpg), in this case one is still the filename and jpg is the extension (this really has 2 extensions but we only want to see jpg).

Write the shortest code possible, creating the array or table does not count towards the total characters of the code.
So if you do this first:

tsqlLine number Off | Hide | Select all

DECLARE @bla TABLE (tmp VARCHAR(500))
INSERT @bla VALUES( 'C:\data\old\one.jpg')
INSERT @bla VALUES( 'C:\data\old\one.two.jpg')
INSERT @bla VALUES( 'C:\data\new\newer\three.wav')
INSERT @bla VALUES( 'C:\Documents and Settings\My Music\Amazon MP3\The Doors\Gloria.mp3')

Or create and fill in an array (Java, VB, C#, Ruby etc etc), do not count that part.

Good luck !

by **ca8msm** on Fri Jul 11, 2008 9:39 am

Here's a VB.NET version. Just create a form and drop a DataGridView on it to see the results.

vbnetLine number Off | Show | Select all

Code is hidden, SHOW

Output:

FilePathSplit.JPG

by **Remou** on Fri Jul 11, 2008 9:59 am

A jam and sardine sandwich, with VBA topping.

textLine number Off | Show | Select all

Code is hidden, SHOW

Oops.

Puzzle.PNG

by **spoulson** on Fri Jul 11, 2008 1:18 pm

Don't forget to use hidecode tags!

by **chrissie1** on Fri Jul 11, 2008 1:46 pm

Don't forget to use hidecode tags!

done

by **SQLDenis** on Fri Jul 11, 2008 1:46 pm

SQL Server version

tsqlLine number Off | Show | Select all

Code is hidden, SHOW

by **spoulson** on Fri Jul 11, 2008 1:50 pm

Since this is a golf competition, I naturally solved this in Perl as a one-liner. Hopefully, it's not too cryptic. I commented it to explain what is going on.

Note, I disagree that "one.two.jpg" has two extensions. Multiple periods in a filename delimit more than just extensions. For example, in the unix world I often see files and folders with dot-delimited versions, datetime stamps, etc. So, I coded with the assumption that "one.two" is the filename portion.

perlLine number Off | Show | Select all

Code is hidden, SHOW

textLine number Off | Hide | Select all

C:\>perl p6.pl
NameOfFile Extension Folders TotalPath
one jpg 2 C:\data\old\one.jpg
one.two jpg 2 C:\data\old\one.two.jpg
three wmv 3 C:\data\new\newer\three.wmv
Gloria mp3 4 C:\Documents and Settings\My Music\Amazon MP3\T
he Doors\Gloria.mp3

by **SQLDenis** on Fri Jul 11, 2008 1:53 pm

poulson one of your extensions is wrong :-)

I did that on purpose of course to make it a little harder

by **ca8msm** on Fri Jul 11, 2008 2:00 pm

Denis,

In that case mine is wrong too. However, I'm with spoulson; if the path is "C:\data\old\one.two.jpg" then the filename is "one.two" not "one".

by **SQLDenis** on Fri Jul 11, 2008 2:09 pm

You have never gotten a .vbs file in the email?

virus.txt.vbs

by **Remou** on Fri Jul 11, 2008 2:19 pm

chrissie1 wrote:
Don't forget to use hidecode tags!

done

Oops and thanks.

by **ca8msm** on Fri Jul 11, 2008 2:25 pm

Yes, and I still think the same. In the case of the .vbs file, it is just a file named "virus.txt" with a .vbs extension.

by **Remou** on Fri Jul 11, 2008 2:36 pm

I would also consider one.two to be the file name, but it did make it a little more difficult as Denis said.

by **AlexCuse** on Fri Jul 11, 2008 2:37 pm

I too think the last extension is the only extension.

Otherwise I'd probably die when I see a filename like this: II.II407.DVDAFUL.FLAT.G0139V00

by **SQLDenis** on Fri Jul 11, 2008 2:59 pm

I depends if you have hide extensions or not :-)

either way the output has to match the requirements of the puzzle

by **AlexCuse** on Fri Jul 11, 2008 4:48 pm

this ought to be close enough (for the console). I tried to do it with only string manipulation functions, none of the luxuries (well, except for Linq and anonymous types

)

csharpLine number Off | Show | Select all

Code is hidden, SHOW

by **Emtucifor** on Sat Jul 12, 2008 1:07 am

textLine number Off | Show | Select all

Code is hidden, SHOW

Note: because the bbcode parser is messing up my code, I had to replace [ with {. Reverse this to get running code.

Sample output:

Extension	NameOfFile	TotalPath	NumberOfFolders
jpg	one	C:\data\old\	2
jpg	one.two	C:\data\old\	2
wav	three	C:\data\new\newer\	3
mp3	Gloria	C:\Documents and Settings\My Music\Amazon MP3\The Doors\	4

And as others have said, there is a mistake in the name of the file in the second row in the original post. Not only is this a puzzle but it relates to things in the real world. Ask MS Windows what the file name is of "one.two.jpg" and it will tell you "one.two".

To see this in action, open a command window and run the following command:

batchLine number Off | Hide | Select all

echo.>one.two.jpg&for %e in (one.two.jpg) do @echo filename portion of one.two.jpg is "%~ne"&del one.two.jpg<nul

by **Emtucifor** on Sat Jul 12, 2008 1:09 am

I would like to vote that output which isn't aligned with labels at the top doesn't meet the conditions of the challenge.

If it does, then I would like to submit a new version.

by **SQLDenis** on Sat Jul 12, 2008 1:26 am

Erik, I did that with the file name so that it is a little (just) harder

by **Remou** on Sat Jul 12, 2008 1:36 am

Harumph.
http://www.ucalgary.ca/counselling/acad ... equestion/
:hide:

by **cbetancourt** on Sat Jul 12, 2008 1:43 am

A JavaScript solution is here: http://claude.betancourt.us/split-filepath.html.

by **AlexCuse** on Sat Jul 12, 2008 1:59 am

For Erik, in the page load of a .aspx page (have to add System.Collections.Generic + the list declaration from above):

csharpLine number Off | Show | Select all

Code is hidden, SHOW

I like that one Claude

by **SQLDenis** on Sat Jul 12, 2008 2:30 am

I would have expected Claude to use ExtJS or ColdFusion <vbg>

by **Emtucifor** on Sat Jul 12, 2008 3:03 am

SQLDenis wrote:Erik, I did that with the file name so that it is a little (just) harder

But you called it the file name which makes me constitutionally incapable of obeying. So call it something else! :-p

by **ilitirit** on Wed Jul 16, 2008 3:36 pm

Using built-in methods

csharpLine number Off | Show | Select all

Code is hidden, SHOW

LessThanDot

Forum Search

Highly Rated Users

Forum Statistics

Other

Google Ads

LTD Puzzle 6: split a filepath

LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

Re: LTD Puzzle 6: split a filepath

LessThanDot

LTD Social Sitings

Forum Search

Highly Rated Users

Forum Statistics

Other

Google Ads