REGEX help request - MAAT DROffline log import (closed thread solution not working (for me))

Mac
1

Hello Forum,

REGEX is completely new to me and I would greatly appreciate help.

I’m starting to organise my media library using Mp3tag on PC:

PC WORKFLOW

1. Export Mp3tag library data as a csv file.
2. Create MAAT measurements log as a tsv file.
3. Use the csv and tsv files to create a combined spreadsheet.

https://community.mp3tag.de/t/dynamic-range-import-from-maat-droffline-report/71726

Using this REGEX workflow would simplify things substantially, so I am testing:

MAC WORKFLOW

Action Group
DRO TEST

Import Text File
Formatstring: dro_log.txt
Field: dro_import

dro_log.txt (492 Bytes)

Import Tag Fields
Source Format:
$regexp($regex(%dro_import%,.+|\n$replace(%_filename%,'(','\(',')','\)')(.+?)\n.*|\n,$1),\s+\|\s+,==)
Formatstring:
==%dummy%==%dummy%==%dummy%==%dro_max_tpl%==%dro_lufsi%==%dro_dr_pmf%==

RESULT

Successfully imports dro_log.txt to dro_import but the tag fields are only created in the 2nd file.

NOTES

%_filename_ext%
CHANGED TO
%_filename%

(Did not work as log is filename only)

==%dummy%==%format%==%word_length%==%max_tpl%==%lufsi%==%dr_pmf%==
CHANGED TO
==%dummy%==%dummy%==%dummy%==%dro_max_tpl%==%dro_lufsi%==%dro_dr_pmf%==

(For clarity and post Mp3tag data analysis)

2

you would have to check the contents of the imported data in dro_import and then see whether the regular expression produces a single line of data for each file so that the Import tag fields action succeeds.

3

Thank you for the quick response.

This is the text format imported to dro_import from dry_log.txt:

SCR-20261004-mcfc
SCR-20261004-mcfc3104×2054 232 KB

Is there a REGEX missing from my MAC WORKFLOW to make this one line?

4

AFAI can see, the text file has a blank line following the first | and also leading spaces in front of the first filename in the text.
See, if it works after you deleted these extra pieces of information

Or if a modified expression like this helps:
$regexp($regex(%dro_import%,.+|\n\s*$replace(%_filename%,'(','\(',')','\)')(.+?)\n.*|\n,$1),\s+\|\s+,==)

5

Deleting the extra information you suggested worked - thank you so much.

Unfortunately, the modified expression did not but it gives me something I can try to learn from and adapt myself.