hi...
trying to create a script that will read a portion of the sales order item description and pull that data into another field. I can pull the entire description in another field with the script, but my problem is I need to parse part of the description separated by pipe delimiter (|). The description may look like this: model number = 1234|width=50|hinge side= left active|
I am trying to pull only the part where it starts hinge side. Here is what I have so far. It is not working at all, so the syntax must be wrong
slsord = ""
desc = ""
pid6 = ""
item = ""
retVal = oBusObj.GetValue ("SalesOrderNo$", slsord)
retVal = oBusObj.GetValue ("ItemCodeDesc$", desc)
retVal = oBusObj.GetValue ("ItemCode$", item)
If InStr(ItemCodeDesc$,desc},'HINGE SIDE') > 0
Then "HINGE SIDE= " + ExtractString({SO_SalesOrderDetail.desc},"HINGE SIDE=","|")
Else ""
retVal = oBusObj.SetValue("UDF_PID06$", desc)
End if
Thanks for any help...Really appreciate it...
B