nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

String from index position

NoahHuntington

Trying to calculate field using all the leftmost characters of [TEXTSTRING] up to the first occurrence of "out" in [TEXTSTRING] whose position has been calculated and placed in [POSITION] field. The following is vbscript but I'm sure there is an easy python solution to this. The script should help clarify...

[position] = first occurrence of "out" in [TEXTSTRING]

label:

Left( [TEXTSTRING], Len( [TEXTSTRING] ) [position] )

I hope this make sense?

タグ付けされた投稿をもっと見る

Accepted answers

All comments

NoahHuntington

That is an error with the expression format itself. Double check your field names and that you are using Python instead of VB.

If I ran yesterday according to the picture provided at 11:18 where do you suppose I went wrong? FYI: [postion] although misspelled is the actual field name...

MathewCoyle

ERROR 000539: SyntaxError: EOL while scanning string literal (<expression>, line 1)

That is an error with the expression format itself. Double check your field names and that you are using Python instead of VB.

NoahHuntington

Can you post the full error you are receiving so we can see what has been passed that causes the error? It should look something like this.

Executing: CalculateField blocks TEST_LABEL "!SOURCEID![:  !TEXT_INTS! ]" PYTHON_9.3 #
Start Time: Tue Mar 04 12:48:53 2014
ERROR 000539: Error running expression: u"FA07908426251"[:  u"2014" ] 
Traceback (most recent call last):
  File "<expression>", line 1, in <module>
TypeError: slice indices must be integers or None or have an __index__ method

Failed to execute (CalculateField).
Failed at Tue Mar 04 12:48:53 2014 (Elapsed Time: 0.04 seconds)

You can find it under the 'Results' tab

Messages
Executing: CalculateField OWNERSHIP_TEXT Label "!TEXTSTRING![:int (!postion!)]" PYTHON_9.3 #
Start Time: Tue Mar 04 16:55:32 2014
ERROR 000539: SyntaxError: EOL while scanning string literal (<expression>, line 1)
Failed to execute (CalculateField).
Failed at Tue Mar 04 16:55:32 2014 (Elapsed Time: 0.10 seconds)

MathewCoyle

Can you post the full error you are receiving so we can see what has been passed that causes the error? It should look something like this.

Executing: CalculateField blocks TEST_LABEL "!SOURCEID![:  !TEXT_INTS! ]" PYTHON_9.3 #
Start Time: Tue Mar 04 12:48:53 2014
ERROR 000539: Error running expression: u"FA07908426251"[:  u"2014" ] 
Traceback (most recent call last):
  File "<expression>", line 1, in <module>
TypeError: slice indices must be integers or None or have an __index__ method

Failed to execute (CalculateField).
Failed at Tue Mar 04 12:48:53 2014 (Elapsed Time: 0.04 seconds)

You can find it under the 'Results' tab

NoahHuntington

[ATTACH=CONFIG]31928[/ATTACH]

This is what I'm attempting?

2014-03-04_1317.jpg

MathewCoyle

Is that your entire expression? Can you take a screenshot of your field calculator window with the code you execute that returns that error? Also can you post the entire error message? And what version of ArcGIS are you using? Something isn't adding up here.

NoahHuntington

Matt,

position is a long, new label field and textstring are string fields...

using:
!TEXTSTRING![:int( !position!)]

received:
error 000539: exceptions.TypeError: cannot concatenate 'str' and 'int' objects.

MathewCoyle

If neither of the posted samples worked for you something odd is going on with your data or how you are executing the calculator. Are you sure you are enabling Python instead of VB? What errors or messages do you get?

NoahHuntington

Are you trying to calculate a field or create a label?

Ultimately label. In doing so was attempting to create new label field? Open to label expression too!

MathewCoyle

Are you trying to calculate a field or create a label?

NoahHuntington

Could you post a sample of your table you are trying to calculate and the applicable field types?

Hi Matt

See attached:

label using textstring only...

label does not all show in table fyi.

EXAMPLE.png

MathewCoyle

Could you post a sample of your table you are trying to calculate and the applicable field types?

NoahHuntington

If you are just looking to get everything before the word "out" in a text string, how about:
!TEXTSTRING!.split("out")[0].strip()

No luck here?

NoahHuntington

Do you mean splitting it up by white space and finding where the word 'out' is within a string? If so, you could get the position with something like this:
>>> a = 'this is out at pos 2'
>>> b = 'out at pos 0'
>>> c = 'pos 3 is out'
>>> def findIndex(string, word):
 return string.split().index(word)

>>> for test in [a, b, c]:
 print findIndex(test, 'out')

 
2
0
3
I don't know much VB so I'm not sure what you're doing once you have the index?

EDIT: Matt's answer is waaaay better than mine.

No problem. Yeah I'm not sure what your testing in this one? Thanks for chiming in Caleb!

Anonymous User

If you are just looking to get everything before the word "out" in a text string, how about:

!TEXTSTRING!.split("out")[0].strip()

NoahHuntington

If using field calculator try this.
!TEXTSTRING![:int(!position!)]
int() may or may not be required depending on field type of "position"

I have tried both of the following?

!TEXTSTRING![: !postion!]

!TEXTSTRING![: int(!postion!)]

Anonymous User

Do you mean splitting it up by white space and finding where the word 'out' is within a string? If so, you could get the position with something like this:

>>> a = 'this is out at pos 2'
>>> b = 'out at pos 0'
>>> c = 'pos 3 is out'
>>> def findIndex(string, word):
 return string.split().index(word)

>>> for test in [a, b, c]:
 print findIndex(test, 'out')

 
2
0
3

I don't know much VB so I'm not sure what you're doing once you have the index?

EDIT: Matt's answer is waaaay better than mine.

MathewCoyle

If using field calculator try this.

!TEXTSTRING![:int(!position!)]

int() may or may not be required depending on field type of "position"

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.