Skip to Content
0
Former Member
Mar 03, 2009 at 01:34 PM

Java Code Required

23 Views

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