Transform Script to assign a replaced string

[Mrman]

Hi All,

We are having the below field map to map   HOSTNAME from source table to Name in Target table. Now we want only for class "cmdb_ci_db_instance" in Source table the hostname which has   like (ORACLE:CNSZIDC04) , we need to replace : with @   and set to name field in Target like(ORACLE@CNSZIDC04)   . We have the below script , please guide.

Does it conflict with the existing Field Map.

I tried the below script it is not setting the Name by replacing : with @ .In logs I am getting correctly as Replaced String: ORACLE@CNSZIDC04

Still getting as

Code:

=====

CODE:

=======

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

  var sdb = source.u_cmdb_class_name;

  if(sdb == "cmdb_ci_db_instance"){

  var hnmd = source.u_hostname;

  var resd = hnmd.replace(":", "@");

  gs.log("Replaced String: "+resd);

  target.name = resd;

  }

})(source, map, log, target);

[Mrman]

Hi ,

Please let me know if I need to write a new OnBefore transform script for this? I have already written Source script in Field map as below. Please suggest

answer = (function transformEntry(source) {

  var sdb = source.u_cmdb_class_name;

  if(sdb == "cmdb_ci_db_instance"){

  var hnmd = source.u_hostname;

  var resd = hnmd.replace(":", "@");

  gs.log("Replaced String: "+resd);

  //target.name = resd;

      return resd;

  }

else{

  return   source.u_hostname; // return the value to be put into the target field

}

})(source);

[Justin Abbott]

Yes, you could put that code in an onBefore script.

[Mrman]

Hi Justin,

Could you please respond.