field derived from other field

[Former Member]

Hi all,

I have ORG UNIT TEXT which has values of length 7. and i need to populate another field COLLEGE using ORG UNIT TEXT. but the requirement is the college field should only display first 2 letters of org unit text in the report.

please suggest me !

Thanks is advance,

Harshita

[Former Member · Accepted solution]

Hi

Welcome to SDN

You can create a variable with replacement and write a code to fetch only the first 2 letters of the other kf

Assign points if useful

Thanks

N Ganesh

[Former Member]

If you're doing this in the update rules, you can use a formula and not have to write any code.

A possible formula in the update rule for COLLEGE would be:

SUBSTRING(ORG UNIT TEXT,0,2)

[Former Member]

Hi Ganesh,

Could u please send me the sample code.

thanks in advance

Harshita