Field Calculator: Syntax of text manipulation expressions

1583
1
09-09-2013 11:40 PM
ThomasPaschke1
Esri Contributor
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>
...[/INDENT]


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!

Tom
Reply
0 Kudos
1 Reply
VladislavPlechnoy
New Contributor III
Tom,

FieldCalculator processor doesn't support text manipulation functions that can help you to resolve your issue at the moment.
You may try to apply FieldCalculator RegEx processor. Try to come up with RegEx pattern syntax (you will need to come up with 4 different ones that match each piece of information you are looking for) that will serve your needs.

Should you have further questions please feel free to ask.

Thanks,
Vlad Plechnoy.
Reply
0 Kudos