Skip to Content
0
Former Member
Jan 04, 2012 at 11:39 AM

Need UDF for For Length Condition

654 Views

Hi Experts,

I need a UDF for this below business case we have vendor name which having length 45. that need to mapped with Name1 & name 2. in the Target.

for the name1 the condition is like if vendor name having length up to 35 that will comes in Name1 filed.

for the Name2 . the condition is like if the vendor name is having more vthan 35 i.e means 35 to 45 those charactes will be filled in Name 2

let me give one exampl

vendorname-pavankumar- will goes to name1 bcz it's length is below35

vendorname- pavankumar pavankumarpavankumarpavankumar

pavankumar

- kumar will comes in Name2 filed bcz its more than length 35

I Need UDF For NAME2 Condition

please help me out. bcz this is my first UDF . i have never done UDF before

Thanks in Advance

Pavan

Edited by: Pavan Kumar Thiruveedula on Jan 4, 2012 12:42 PM