Dear all,
I have tried everything I can think of - but nothing works :-)
The Comment field contains the following:
nnnn/yyyyyyyy...
or
nnnna/yyyyyyyy...
I want to split this Comment field into:
Artist = nnnn or nnnna
and
UPC Code=yyyyyyyyy...
The following works in Rule Based Manipulation:
IF Comment=[anyvalue]
SET Artist=[GRAB]1,5,[tag]Comment[][]
IF Artist=[anyvalue]
SET Artist=CD02-[tag]Artist[]
With this code I get an Artist of:
CD02-nnnn_ or CD02-nnnna
but I want an Artist of:
CD02-nnnn or CD02-nnnna
As nnnna can be 4 or 5 characters long, I want to do something like this:
IF Comment=[anyvalue]
SET Artist=[SPLIT]/,[tag]Comment[],1[]
IF Artist=[anyvalue]
SET Artist=CD02-[tag]Artist[]
But whatever I try, it does not work. How do I use [SPLIT] to split a Comment into 2 strings. I do not care if the separator is _ or / or , or whatever
Many thanks!
Mike
I have tried everything I can think of - but nothing works :-)
The Comment field contains the following:
nnnn/yyyyyyyy...
or
nnnna/yyyyyyyy...
I want to split this Comment field into:
Artist = nnnn or nnnna
and
UPC Code=yyyyyyyyy...
The following works in Rule Based Manipulation:
IF Comment=[anyvalue]
SET Artist=[GRAB]1,5,[tag]Comment[][]
IF Artist=[anyvalue]
SET Artist=CD02-[tag]Artist[]
With this code I get an Artist of:
CD02-nnnn_ or CD02-nnnna
but I want an Artist of:
CD02-nnnn or CD02-nnnna
As nnnna can be 4 or 5 characters long, I want to do something like this:
IF Comment=[anyvalue]
SET Artist=[SPLIT]/,[tag]Comment[],1[]
IF Artist=[anyvalue]
SET Artist=CD02-[tag]Artist[]
But whatever I try, it does not work. How do I use [SPLIT] to split a Comment into 2 strings. I do not care if the separator is _ or / or , or whatever
Many thanks!
Mike