how to get a text from between of string
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2023 01:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-14-2023 11:28 PM
@Karan Chhabra6 , can you please help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 12:04 AM - edited 05-15-2023 12:09 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 01:05 AM
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