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
- 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
Edited by: Pavan Kumar Thiruveedula on Jan 4, 2012 12:42 PM