Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Mans]

Great day to all,

As I'm moving my pictures to MC aswell, I'm trying to figure out some things.
I could use some help on the following:

I've set up a view using "years" as top level, this works.
But when drilling down the next level isn't as labeled as i want.
It uses [date created] as [album] title instead of the existing foldername:

This is how the file path actually is:
.../2019/Mei/IMG_4011.JPG

So what I'm trying to achieve is:
-Setting auto-importing so the [album] tag is filled via an custom expression in order to carry the 'Mei' value of the file path.

The picture itself does carry the correct [name]: IMG_4011

I've tried playing with the RemoveRight and Delimit function, but as the filename (IMG_xxx or IMG_xxxx) isn't always the same length, the outcome isn't the one I'm wanting.

Thanks for your help !

[Moe]

Assuming that the filepath before 2019 is simply the drive letter, I will use C as my example, try this bit of regex

Code: [Select]

regex([filename (path)], /#C:\\(.+)\\(.+)\\#/, -1)[R2]


[Mans]

Great day Moe,

Thanks for your help sir,

In fact the complete filepath is longer:
\\NAS1\photo\2019\Mei\IMG_3991.JPG

Where I'll only like to extract the part just in front of the filename.
photo is the dedicated share on my nas.
The year is the toplevel of the share and varies. This is why i tried to start from the end of the filepath by excluding the file name first and then some sort of delimiter in order to 'grab' the data.
Does it make sense ?

Another thanks Moe !

[Moe]

Try this

Code: [Select]

regex([filename (path)], /#.+\\photo\\(.+)\\(.+)\\#/, -1)[R2]


[Mans]

Great ! Works like a charm !
Thanks Moe.

[blgentry]

It will come as no surprise to most here that I really dig Regex.  I use it for a lot of tasks.

But in this particular case, MC has a function that's designed to do the exact task the OP wants.

https://wiki.jriver.com/index.php/File_Path_and_Identifier_Functions#FileFolder

I'll leave it as an exercise for the reader (hi Moe!) to incorporate this into an expression the OP can use.

Brian.

[Mans]

Many thanks to both of you, always surprised how rich MC features are :-)

=filefolder([filename,0], 0)
Does the job perfectly, easy :-)

Cheers !

[MikeO]

New Years resolution Learn Rebecca , I have put it off for years 

[Moe]

Cool, TIL that the FileFolder(…) expression exists

[MikeO]

Of course I meant RegEx not sure who Rebecca is 🤫

[Moe]

MikeO, if you're serious about learning Regex, I highly recommend this site https://regex101.com/

While it won't "teach" you regex, it provides very valuable insight into the workings of regex.  I use it all the time.

As an example, using the above data, take a look at this https://regex101.com/r/pfdWM4/2

[blgentry]

MikeO:

You might take a look at my little tutorial in Regex for MC:

https://yabb.jriver.com/interact/index.php?topic=97996.0

Brian.