Field Calculator: Syntax of text manipulation expressions

Discussion created by t.paschkeesri-de-esridist Employee on Sep 9, 2013
Latest reply on Sep 11, 2013 by vplechnoy-esristaff
Hi All,

I got a RSS feed of earthquakes sending date, time, coordinates and depth in one string (description) as seen below:

[INDENT]<title>M 4.2, Northern Chile</title>
<description>2013-09-10 04:31:29 -23.20 -68.02 155 km A</description>

Since I did not manage to  seperate the long and lat coordinates with an RegEx Expression, cause they have got the same pattern, my question is if there is a possibility to split a string like this by using the field calculator? Furthermore, is there a documentation of all available text manipulation syntax?

I tried description.split('   '), split(description,'   ') but it did not work.

Thanks for any help!