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é

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:

<SPAN class="keyword token">var</SPAN> tree <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Prunus virginiana"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sepValues <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>tree<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">// return sepValues[0]; // Genus - Result: Prunus</SPAN>
<SPAN class="keyword token">return</SPAN> sepValues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// Species - Result: virginiana</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

<SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>TREE<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">// Genus</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and

<SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>TREE<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">// Species</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

HTH,

Egge-Jan