Adding Characters to a Column with Python

Question

I am looking for a way to add three 0's to the end of all entries in one column of data using an update cursor in python. For instance, if all the entries in the column of data have a value of 123456. I need to add python code that will return 123456000.

I was able to subtract out the the last three digits to process the information originally using this:

    while row:
        value = row.GetValue("LD_MCPI")[:-3].strip()
        row.SetValue("LD_MCPI", value)
        rows.updateRow(row)
        row = rows.Next()

How can I modify the [:-3] section of the second line to yield the results I need?

Thanks for your time.

Are the values integers? Can you just multiply them all by 1000? — aganders3
– aganders3, Commented Jan 25, 2012 at 17:29

Andrew Clark · Accepted Answer · 2012-01-25 17:44:15Z

2

If I am understanding your problem correctly, row.GetValue("LD_MCPI") will return a string, like "123456", and you want to set value to the string "123456000". You can do this by simply adding the string "000" to row.GetValue("LD_MCPI"):

value = row.GetValue("LD_MCPI") + "000"

If this is not what you are looking for, please clarify your question.

I am pretty confident that you are dealing with strings based on the slicing you use in your example, but if row.GetValue("LD_MCPI") returns an int you can multiply it by 1000 to add the three zeros.

value = row.GetValue("LD_MCPI") * 1000

edited Jan 25, 2012 at 17:44

answered Jan 25, 2012 at 17:31

Andrew Clark

210k36 gold badges286 silver badges310 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stephen2020 Over a year ago

Thanks for the help! That was the answer I needed.

Collectives™ on Stack Overflow

Adding Characters to a Column with Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related