Job aborts - Alpha function

[wfis]

Hi All,


I have used the Alpha function and handled NULL but it yet does not work and gives warning

If Trim(Lnk_Read_ds.NAME_LINE)='' Or IsNull(Lnk_Read_ds.NAME_LINE) Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0

Error is "Null String Argument"

Any help

Thanks

[ameyvaidya]

I think the problem is to do with:

Code: Select all

Trim(Lnk_Read_ds.NAME_LINE)=''

Trim will not take kindly to a null value as input

try this:

Code: Select all

If Trim(NullToEmpty(Lnk_Read_ds.NAME_LINE))='' Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0 

[wfis]

Thanks its working now.