Transform map script

[Kshitij Chakarv]

Hi All, 

I am creating a script to extract some specific value followed after a keyword. 

answer = (function transformEntry(source) {

var GR = source.u_description.toString();
var index = GR.indexOf("Fault Offset:");
var offset = GR.substring(index, index + 9);
return "source.u_short_description + '' + offset";

})(source);

Intension is to get the value after 'fault offset:' from source description is set to a custom field. 

I see no result using this script. Please advise on this.

[AnubhavRitolia · Accepted solution]

Hi @Kshitij Chakarv 

Which type of transform script are you writing?

[Slava Savitsky]

Also keep in mind that indexOf() method is case-sensitive. For a case-insensitive lookup, use search() method instead.

[AnubhavRitolia]

Hi @Kshitij Chakarv 

Please find updated transform map script below:

(function runTransformScript(source, map, log, target ) {

var desc = source.u_description.toString();
var index = GR.indexOf("Fault Offset:");
if(index!=-1)
{
var offset = GR.substring(13+index);
target.u_custom_field = source.u_short_description + ' ' + offset;
}
else
{
target.u_custom_field = source.u_short_description.toString() + ' ' + source.u_description.toString();
}
target.update();

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

[AnubhavRitolia]

Hi @Kshitij Chakarv 

Please try below code:

var desc = source.u_description.toString();
var index = GR.indexOf("Fault Offset:");
if(index!=-1)
{
var offset = GR.substring(13+index);
return source.u_short_description + ' ' + offset;
} else
{
return source.u_short_description.toString() + ' ' + source.u_description.toString();
}
return '';

[Kshitij Chakarv]

Thanks Anubhav, will try this. Please stand by 🙂

[AnubhavRitolia]

@Kshitij Chakarv  

Did you got a change to try my solution?