I have a field that I am taking from a CSV file and storing it into a field. The data is a url to a pdf
the problem is that the data source is sending us some incomplete URLS that lead to a forbidden link and it has the same structure as the fully qualified URL's that are correct:
example 1:
Partial URL > http://subdomain.domain.com/en/ds/
example 2:
Full url > http://subdomain.domain.com/en/ds/REF01-REF02.pdf
I want to strip out the data coming in that does not have a PDF with it. (e.g if it just has > http://subdomain.domain.com/en/ds/).
Is this possible and if it is, can someone please help me with an idea on how to go about this