Question: I have some code but I just found out it works on like 90% of the computers. Here is the distinguishedName:
*CN=2016-10-05T12:19:16-05:00{393DA5A5-4EEF-4394-90F7-CBD0D2F20CC9},CN=**Computer01-T2**,OU=Product,OU=Workstations,OU=KDUYA,DC=time,DC=local*

What I am trying to do is parse out just the ComputerName. 3 of the 27 OU we have use 3 letter Names instead of the 5 which all the other sites use. Ive been banging my head against the wall and reaching out for some help and or guidance. Watching some videos on regex understand the basics but still working on more complicated things like this.

Here is what I have. Any advice or help would be greatly appreciated.

```
let str = "CN=2016-10-05T12:19:16-05:00{393DA5A5-4EEF-4394-90F7-CBD0D2F20CC9},CN=Computer01-T2,OU=Product,OU=Workstations,OU=KDUYA,DC=time,DC=local";
str = str.substring(70, str.length -53);
console.log(str);+

```

Answer: 
I don't think they have support for geometry buffers at this stage. ST\_AREA isn't going to help you. Last I heard they are working on improving their geospatial support.

That said, can you buffer your data somewhere else in your workflow? Such as using shapely buffer in python, or turf circle/buffer in javascript?
As said above you can find all geospatial functions here: <https://docs.snowflake.com/en/sql-reference/functions-geospatial.html>

Regarding ST\_BUFFER I think the function ST\_AREA sounds good: <https://docs.snowflake.com/en/sql-reference/functions/st_area.html>