Hi All,
Can you please help me out in this.
I need to write a UDF
1. Check if any perficular field is balnk then return a hypen ( -)
or Check if any that fields contains any leading zeros then also return a hypen .
Ex:
Field = Name
Length = 40
If there is no data provided in the name fields then i will populate ( - )
if there is a single zeros i will return ( - )
If there are multiple zeros then also i need to return ( - ).
I will be glad for the help.
Thanks,
Jay