question Regex to get the value from brackets in Developer forum

Regex to get the value from brackets

Nagesh5 — Wed, 17 Aug 2022 13:57:30 GMT

Hello Team,

We have different values in one of the reference fields in particular table like below

12345(Aukland)

098765(namibia)

We need help to filter the values in the brackets only with the help of regex like below by removing all the values other than values in brackets

Aukland

Namibia

Post that we need to verify above values will be avialable in particuler table or not

Can anyone help on this

thanks,

nagesh

Re: Regex to get the value from brackets

Community Alums — Wed, 17 Aug 2022 14:02:47 GMT

Hello,

Try below code -

var reg = "12345(Aukland)";
var value = reg.match(/\(([^)]+)\)/)[1];

Regards,

Akshay

Re: Regex to get the value from brackets

Nagesh5 — Wed, 17 Aug 2022 15:52:28 GMT

Thanks for the feedback and it's not working in the below example.Can you help me with the below senarios as well becuase some times we have more than 2 names in glide list.

12345(Aukland),098765(namibia).

Re: Regex to get the value from brackets

Muhammad Khan — Thu, 18 Aug 2022 03:49:40 GMT

Hi Nagesh,

Try the following script in the background script.

var str = '12345(Aukland),098765(namibia)';

var arr = str.split(',');

for(var i=0; i<arr.length; i++){
  gs.print(arr[i].match(/\((.*?)\)/)[1]);
}

Hopefully, this will help you to resolve your query.

Re: Regex to get the value from brackets

Aman Kumar S — Thu, 18 Aug 2022 03:52:40 GMT

Hi @Nagesh

You can follow below simple javascript functions, which you can also understand and adjust according to your requirements:

var txt = "12345(Aukland),098765(namibia)";
var txtArr = txt.split(',');

for(var i in txtArr){
var str = txtArr[i];
gs.info(str.substring(str.indexOf('(') + 1, str.lastIndexOf(')')));
}

Re: Regex to get the value from brackets

Nagesh5 — Thu, 18 Aug 2022 06:52:58 GMT

excellent How to copy these values in glide list with comma seperated.

Re: Regex to get the value from brackets

Aman Kumar S — Thu, 18 Aug 2022 14:31:18 GMT

var arrResult = [];

for(var i in txtArr){
var str = txtArr[i];
arrResult.push(str.substring(str.indexOf('(') + 1, str.lastIndexOf(')')));
}

g_form.setValue("list_field",arrResult.toString());// client side

current.setvalue("list_field",arrResult.toString());// server side

I just have one doubt, if it is glidelist and you are fetching locations, then you will need to glide the cmn_location table, and get the list and use above function to populate.

Re: Regex to get the value from brackets

_ChrisHelming — Fri, 26 Aug 2022 18:50:46 GMT

this is slightly more succinct than the other answers.

var input ='12345(Aukland),098765(namibia),098765(botswana),098765(quebec),098765(new york),098765(toronto),098765(kiev),098765(tokyo),098765(mumbai).'

input.match(/\(([^)]+)\)/g).map(function(m){return m.replace(/[()]/g,'')});

/*
[
  "Aukland",
  "namibia",
  "botswana",
  "quebec",
  "new york",
  "toronto",
  "kiev",
  "tokyo",
  "mumbai"
]
*/

Re: Regex to get the value from brackets

Aman Kumar S — Mon, 29 Aug 2022 22:23:51 GMT

Hi @Nagesh

Is your issue resolved?

Feel free to mark correct, if your issue has been resolved, so it ends up in solved queue.

Will be helpful for others looking for the similar query.