The CreatorCon Call for Content is officially open! Get started here.

how to get a text from between of string

ST9
Tera Contributor

Hi All,

I wanted to extract a Order Number(123456789) and save that text to a particular custom field.

Example this- 

Order Number: 123456789
Candidate Name: Albert Test
Profile link: check

Hello

First Advantage is conducting a background check..

 

I have written a BR and getting a order number properly but the issue is if the order number is empty, the result is giving me a "Candida"

var des= current.description;
var index = des.indexOf("Order Number:");
var orderNum = des.substring(index+14, index+23);
	current.u_order_number= orderNum;

Please help

7 REPLIES 7

ST9
Tera Contributor

@Karan Chhabra6 , can you please help

Namrata Ghorpad
Mega Sage

Hello,

Please refer the below script.

 

var desc=current.description;
var test=desc.split('Order Number:')[1];
var orderNum=test.split(' ')[1];
current.u_order_number=orderNum;
gs.log(orderNum);

 

 

Please mark my answer as helpful/correct if it helps you.

Regards,

Namrata

Hi Namrata, I am getting this result in Background script- 

var gr= new GlideRecord('sn_hr_core_case');
gr.addQuery('sys_id','4976d51d97b66510857c9904a253af41');
gr.query();
if (gr.next()) {
var desc = gr.description;
var test=desc.split('Order Number:')[1];
var orderNum=test.split(' ')[1];
gs.info(orderNum);
}

O/p-
 11111
Candidate