I've noticed when pulling album catalogue numbers from discogs, and displaying them in a custom field, sometimes they have more than one. e;g: TICK001CD, TICK001CD, TICK001CD, TICK001CD How can I create a reg expression to grab that first catalogue number where commas separate multiples? Currentl…

You could adapt [image] RegExp to extract text before first comma General Discussion This is not quite true if you use $regexp(%composer%,'^(.+?),.*',$1) instead The potential section following the comma does not necessarily need the parenthesis if you do not want to u…

You want to reduce multiple appearances of the same content in CATALOGNUMBER to one entry? Or do you want the first entry only, ignoring what other contents follow?

In that pictured example, they are all the same, but in others, they may be different - all I want is the first listed.

BTW: The term "trimming" as used in your title question is not exactly what you want to do. "Trimming" in the scripting world means "to cut away leading or trailing whitespaces": [image]

Apologies for using the wrong term. I'm very much a novice at this.

Trimming an extended information field

Support

LyricsLover June 13, 2024, 4:18pm 4

You could adapt

and use

$regexp(%CATALOGNUMBER%,'^(.+?),.*',$1)