topic How to split string after first word in ArcGIS Pro Questions

How to split string after first word

LiorHershkovitz — Mon, 03 Aug 2020 11:28:24 GMT

Hi,

I have a filed of trees botanical name, now I have to separate it to Genus field and Species field.

Which means I have to extract the first word (Genus) and the second one (Species).

Something like text to column in Excel

Using arcgis pro or online

Thanks!

Lior

Re: How to split string after first word

Egge-Jan_Pollé — Sun, 12 Dec 2021 00:08:40 GMT

Hi Lior Hershkovitz,

I guess you are going to use the ArcGIS Arcade expression language to get this done.

You can test this simple script in the ArcGIS Arcade Playground:

var tree = "Prunus virginiana";
var sepValues = Split(tree, ' ');
// return sepValues[0]; // Genus - Result: Prunus
return sepValues[1]; // Species - Result: virginiana‍‍‍‍

Let's suppose your column with tree names is called TREE. To apply this split on the whole column at once, you can use:

Split($feature.TREE, ' ')[0] // Genus‍

and

Split($feature.TREE, ' ')[1] // Species‍

HTH,

Egge-Jan

Re: How to split string after first word

LiorHershkovitz — Mon, 03 Aug 2020 18:36:55 GMT

Thanks!

in online, I made calculate field with the expression you wrote.

You are the man!