Import matches text that is not identical

[MariaAux]

I have a FM DB of several thousand links of specific text on web pages created using a chrome extension (super simple highlighter).

The links look like attached image - The initial part is identical but after the   #:~:text=   it has a distinct link pointing to a different highlighted text.

I export the links to a little program that checks if they are still there on the web and returns an error if they have changed. My little program gives me a .csv of all the URL's that had errors.

I then import that list of erroneous URL's back into my DB and this is where I run into problems.

If only one of the links in the attached image returned an error, when importing it matches with all the records that are same prior to the #:~:text= , meaning I actually have more records imported than there are in the .csv

I've tried 'Always Validate' with 'Unique Value', but that hasn't worked.

I'd happily separate the .csv file text to show just the text after the #:~:text=  and import to a calculation field showing the same... but I can't match to a calculated field. It needs to stay a calculation field because the URL is often updated.

I really thought FM imported matching identical data, what am I doing wrong?

Thanks so much in advance 

 

 

 

[comment]

1 hour ago, MariaAux said:

when importing it matches with all the records that are same prior to the #:~:text= ,

That's an interesting observation, I wasn't aware of that. Apparently, the 'update matching records` option when importing relies on the index - and the index stores only the first ~100 characters of the indexed value.

 

1 hour ago, MariaAux said:

I'd happily separate the .csv file text to show just the text after the #:~:text=  and import to a calculation field showing the same... but I can't match to a calculated field.

Try making it a Text field with auto-entered calculated value (replacing existing value).