To Get Length of a particular field which is delimited space

guptae · Posted: Mon Mar 24, 2008 5:36 pm

Hi All,

I just wanted to get length of a varchar fields in which its delimited by space & starting position is known

Eg:

Empno Emp name dept
11 Nataraj.Ganesh IDC
12 Priyank.bhatt MDC
13 GUPTAE IDC

Here I want the length of emp name which is variable in nature & it should be preceeded empname & should be in two byte binary.

Please let me know if I am not clear enough

Frank Yaeger · Posted: Mon Mar 24, 2008 8:31 pm

What is the starting position of the emp name field? What is the maximum length of the emp name field?

Do you want the output to look like this:

guptae · Posted: Mon Mar 24, 2008 10:08 pm

Hi Frank,

Apologiesfor not clear in my prev post.

Length of Empname is 20 bytes & its starting from 3 rd byte.
12345678901234567890123456789012345678901234567890
i/p :11nataraj.ganesh IDC
o/p:11.#nataraj.ganesh IDC

here i assume .& as the length of empname in 2 byte binary
Total record legth is 80 bytes.

Hope I am clear enough.

Frank Yaeger · Posted: Mon Mar 24, 2008 11:22 pm

Here's a DFSORT job that will do what you asked for (we could probably do a trick with converting the input to VB, getting the length from the RDW and converting back to FB, but using multiple IFTHENs is easier).