MySQL Specialist Required Urgent Open 7 days left

Thank you for taking time to read this post We are using a desktop software application to import products into our site via a csv file - the software uses mysql expressions to manipulate the csv files columns for example replace urls - we need a expression created to 1. check column inside csv file and if its blank/empty - either skip or make it NULL however if a url for example [login to view URL] is there THEN REPLACE with [login to view URL] 2. similarly for column with url links to pdf files on a server if the column in csv has a pdf then remove the url part only and keep the file name so if its like this [login to view URL] end result should be [login to view URL] again if there is an empty cell in the csv file i.e. no pdf url is there for the that item then treat at NULL or skip please check this site for more details on the software to get better idea [login to view URL] please only apply if you can work on this immediately, you can access the software via teamviewer to check and test your expressions. thank you