What is the use of Field function

chennu.rajesh · Post by **chennu.rajesh** » Fri Mar 03, 2006 7:09 am

Hello everybody, can any one please let me know
what is the use of FIELD function in data stage. Thanks in advance.

kduke · Post by **kduke** » Fri Mar 03, 2006 7:35 am

Field will parse a string.

Var='12345~flkflkf~789=234'
F1=field(Var,'~',1)
F2=field(Var,'~',2)
F3=field(Var,'~',3)
F2_3=field(Var,'~',2,2)
X2=field(Var,'=',2)

Would mean:

F1 = '12345'
F2 = 'flkflkf'
F3 = '789'
F2_3 = 'flkflkf~789'
X2 = '234'

kcbland · Post by **kcbland** » Fri Mar 03, 2006 7:52 am

For other future requirements, your DS BASIC manual is available under your Start button in the Ascential folder. It's 1000 pages of documentation.

sjhouse · Post by **sjhouse** » Fri Mar 03, 2006 8:03 am

The on-line documentation is is very helpful for how to use the various functions and possible alternatives to do similar tasks.

It is one of the first pieces I show newbies when they are learning how to use the tool.

Stephen