Is there an expression that I could use in my auto-import that would allow me to tag the an individual 'field' by looking at that 'fields' 'list of values' to see if one of the values is located within the file name.
For example:
File Name = Beatles - Hey Jude
Within my library, the lists of artists are Amy Winehouse; Beatles; Coldplay; etc.
I'd like to have the auto-import to do a sub-string search of the file name against the list of artists in my library and tag the [Artist] field based on the match.
I tried... =Ifelse(isequal([Name], ListBuild(1, ;,[Artist]), 8 ) , [Result]
but don't know what to put in place of [Result] and I think the ListBuild is only generating a list from that specific files [Artist] field, which in this case is blank.
I'm aware of the 'Fill Properties From File Name' tool, but in this case, the naming conventions for the files are random, and I'd prefer to tag from import.