Transform Field map script call via script include

sanjeet1245
Tera Guru

So, firstly we create a custom table have 4 field :-
1. Article No- Type String.
2. Short Description - Type String.
3. Space Key - Type String.
4. Kbbody - Type Html.

Actually we have an excel file, in which we have a field name Kbbody in the following field we have an https link.

Task- Actually we have to create the script include and call the script into transform map. While working on the task we can not able to generate any link in the Kbbody field.

After some hardwork we are able to see some number in the field. By the field map script following script was:-


var sc = new global.scriptinclude_name();
var op = sc.function_name(source.u_kbbody);
source.u_kbbody = op;
gs.info('Transformed KBBody: ' + op);
return op;

By that we need a small requirement.
The following pattern are in regex:-


function_name: function(inputText) {
var regexPattern1 = /<a href="https:\/\/123@mail.com\/wiki\/spaces\/LinkTest\/pages\/(\d+)">([^<]+)<\/a> inline/g;
//The specific pattern we are doing to replace with :-
var outputText = inputText
.replace(regexPattern1, '<p>Linking Page 1 here <a href="123@gmail.com">Page Link</a>')
return outputText;

We need to convert the href link into amslink:12347556(our links coverted into random number

Can anyone suggest me how to achieve this requirement.

Every instruction will be helpful.

Thanks and Regards,

Sanjeet Kumar.

1 ACCEPTED SOLUTION

Make sure you don't use capitol letters so just amslink instead of Amslink


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

10 REPLIES 10

Please stop with giving these AI Generated answers, which do not cover the question at all.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.