add dots between numbers in attribute field

Question

hello guys i need to add dots between numbers in attribute field data for example i have 1234567890 and in need something to meke it like this: 12.34.567.890 for example. vb scrypt or python

JimCousins · Answer

Yes, it should not be an issue.

NOTE: You should create a new field and calculate it based off of the original, so if there are any problems, you still have access to the original source field and values.

lbuava · Answer

thanks for your response, that is exactly what i need but i have big date over 20K, i need to do this for all of them. Will this function work for all of them?

JimCousins · Answer

Ibuava,

The result of this operation will be a string. Numeric values do not have "dots" in them. Within python, as a string, you can use a simple string slice and append function, such as:

oldNum = str(1234567890)
newNum = oldNum[:2] + "." + oldNum[2:4] + "." + oldNum[4:7] +"." + oldNum[7:]
newNum
'12.34.567.890'

This assumes the oldNum is 10 characters in each entry.

If it is not always10 characters, work from the end of the string value to the front, instead.

If you are trying to do something else, please provide more information so you can get a targeted response to your question.

Regards,

Jim