Masking and selctive cells

Support
1

is there a way to mask the data?

example

suppose I have the year as a four digit number 1974

but i want to use the last two digits in the new file name

example

LYNYRD SKYNYRD - SWEET HOME ALABAMA (74)

i did this one manually,

is there a way to only use only a specific part of a cell for each song?

>

>next case

is there a way to extract part of a cell and move/copy it to another one

example

FORTUNATE SON (LIVE)

is there a way to move the (LIVE) to another cell and delete it from the title cell?

>

>next case

can you add a TRIM option to remove leading or trailing spaces

example

in the previous case - there would be a trailing space when i move the (LIVE)

or

FORTUNATE SON (LIVE), sometimes the titles have leading spaces

2

Convert Tag -> Filename:
%artist% - %title% ($right(%year%,2))

image
image502×224 5.06 KB

One way could be:
Search for space bracket LIVE bracket
Replace it with "nothing"
$replace(%title%,' (LIVE)',)

image
image497×421 7.35 KB

Then do the opposite:
Add a fixed text (LIVE) to whatever field you want.

$trim already exists - from the documentation:
$trim(x,c) trims all leading and trailing whitespace from the string x. The optional second parameter c specifies the character to trim.

3

THANK YOU

that is most helpful :slight_smile:

4

the last 2 on the year, does not work, only copies (right(%origyear%,2)) in ““

note: im using tag to tag

NEVER MIND

I forgot the $

my fault

5

Yes, each character is crucial.
This includes the ones you can't see, such as leading and trailing spaces.