Field length check in Transform script

[SK41]

Hi,

I  have a requirement in transform map where  i  have to reject  the record or ignore that particular string field if the  value  in  that  string field exceeds the length  of the field. This data is  coming  through excel  into my  instance table.

Please help me in this regard asap.

Thanks in Advance!     

[Kieran Anson]

Hi,

You can do this in a transform script by getting the element descriptor.

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	
	var field = target.account_code.getED();
	var max_length = field.getLength();
	
	if(source.u_account_code > max_length){
		ignore = true;
	}
})(source, map, log, target);

[SK41]

Hi,

Thanks for your input.

I am new to this...can you please let me know what is element descriptor here.

Also,can i use this script in onBefore?

Regards.

[Kieran Anson]

Hi,

Yes this would go into an onBefore script. GlideElementDescriptor - This API allows you to access information about the field in question. The API shows the various information you can gather.

[Ankur Bawiskar]

Hi,

you can use onBefore transform script to handle this

Is this for incoming field value then use this in onBefore transform script

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    var value = source.u_field;
    var maxLength = 32;
    
    if(value.length > maxLength){
        ignore = true;
    }
    
})(source, map, log, target);

Regards
Ankur