Skip to Content
0
Former Member
Jun 07, 2007 at 11:40 AM

user defined functions with (field separator) to be passed

11 Views

Hi all,

following is my source file -->

UNH000000101ORDERS:D: 96A:UN:EAN008'

I am trying for a UDF which should identify the field separator (😊 as a variable

my requirement is i want to separate out fields from the input string on the basis of field separator (😊

ORDERS:D: 96A:UN:EAN008'

i want the output as 4 variables they are ORDERS , D, 96A, EAN008--> these outputs need to be passed to 4 diff fields in target structure.

can u help me in writting this functionality

rgds

chaithanya