Remove unwanted characters from column

[matt.s.marotta at gmail.com]

On Monday, 27 January 2014 08:54:20 UTC-5, Steven D'Aprano  wrote:
> On Mon, 27 Jan 2014 05:32:08 -0800, matt.s.marotta wrote:
> 
> 
> 
> > The code that I used is the proper way that we were supposed to complete
> 
> > the assignment.  All I need now is an 'if...then' statement to get rid
> 
> > of the unwanted FarmID at the end of the addresses.  I just don't know
> 
> > what will come after the 'if' part.
> 
> 
> 
> Show us what you do know. If you don't know the "if", what about the 
> 
> "then"?
> 
> 
> 
> 
> 
> if .... :
> 
>     do what?
> 
> 
> 
> 
> 
> What do you intend to do inside the if? Under what circumstances would 
> 
> you do it?
> 
> 
> 
> If you can answer those questions in English, then we can help you write 
> 
> code to do it.
> 
> 
> 
> 
> 
> -- 
> 
> Steven

If the farmID < 10:
remove one character from the address column
Elif farmID > 10:
remove two characters from the address column