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!     

[asifnoor]

Hi,

You can create a system property and can put the length there.

Go to system properties, create new and there give the unique name for your field and mention the value under value field. select type as integer.

Then in your script, you can fetch the value like this.

var max_length = gs.getProperty("your_property_name");

if(source.u_your_field.toString().length>max_length) {

ignore=true;

}

Mark the comment as helpful if it helps.

[Kieran Anson]

The script I provided does this for you. Rather than static code, it dynamically gets the source field value length

[SK41]

if i have to do this for other fields too each having different lengths, do i need to create new system property for each field length check?

[asifnoor]

Yes, If the lengths vary. 

[asifnoor]

or you can use a string field and separate each length by comma. Have them stored in 1 specific order.

Then in your script, you can fetch the values like this

var max_length = gs.getProperty("your_property_name").toString().split(",");

if(source.u_your_field.toString().length>max_length[0]) {

ignore=true;

}

NOTE: max_length[0] refers to 1st field length. Similalry if you wnat 4th field, then use max_length[3]

Mark the comments as helpful if it helps.