I have a situation where a supplement order order number is created where it appends a character at the end of the order, say ordernumA. The new order is 9 char long and I need to trim off the last character so that it can fit in a 8 char field. I looked at using Trim, but that just handles spaces. What can do/use to trim this last char off?
I am saving the new order value in the datatable and then retrieving it by using the following:
orderVal = DataTable.Value("Order", dtGlobalSheet)
this is on QTP v 9.0, if that makes any difference.