could someone help me here?
i am try to update a field in the database. the field looks something like this
basically i want remove the po part. I know i have to the substr and updates commands, but i dont know how to impliment the two together. so the field should look like this
thanks in advance.