How to split string after first word

[LiorHershkovitz]

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

[Egge-Jan_Pollé · Accepted solution]

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

[LiorHershkovitz]

Thanks!

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

You are the man!