How to validate a column having website url value
Posted: Tue Feb 19, 2013 7:38 am
Hi,
In my source file, I have one column named as website_url. Before loading into target, I have to validate if it's value is proper website url or not.
For eg: It should start with www, http:// or https://. Also it should have valid domain. For eg: It should have formate like http://xxxx.xx.xx or other possible value. I am not able to cover all possible scenario and need help of you all expert. I am only 5 month old in Datastage. Your help will be much appreciated.
Thanks.
In my source file, I have one column named as website_url. Before loading into target, I have to validate if it's value is proper website url or not.
For eg: It should start with www, http:// or https://. Also it should have valid domain. For eg: It should have formate like http://xxxx.xx.xx or other possible value. I am not able to cover all possible scenario and need help of you all expert. I am only 5 month old in Datastage. Your help will be much appreciated.
Thanks.