Search on Different Font/Format of Text within UDF

Question

I am attempting to search for certain phrases and maybe date formats within an UDF on the SO Header in order to populate separate UDF's. I've had trouble before with the scripts not picking up the phrase if it is all capitalized and vise versa. Is there a way to account for this or do you have to script for each possible variation. 
 Example: I want to search for "New Hire" in the UDF_SHIPPINGMESSAGE and if found check off my UDF_NEWHIRE check box. If a user types "NEW HIRE" then the script doesn't recognize the phrase. 
 Part two of the question: Date formats, is there a way to get the date from the UDF_SHIPPINGMESSAGE to populate a UDF Date field and account for all the different ways a user can enter a date format? 
 
 The data populating the UDF"s I am searching in is coming from an eCommerce free text field, that is why I can't standardize it.

jland47 · Accepted Answer

Update- script is working now, with the triggers of "table-pre-totals" and "column-post-validate" on the UDF_SHIPPINGMESSAGE. I don't think I tried both events together.

David Speck · Answer

You'll want to use UCase() on both the string being searched and the string you are searching for. Any time you are doing a comparison like this where you want it to be case insensitive then you should force BOTH, not just one or the other, to either lower case or upper case. 
 For the dates, that will be tricky, as Elliot said, you will have to come up with code to attempt to parse and search for dates in all of the know variations that you anticipate will occur if you can't standardize it. As Elliot said, if you can add a note requesting the user enter dates in a specific format, then that would help.

David Speck · Answer

I would use the following. 
 rVal = 0
sNewHire = ""
searchString = "NEW HIRE"

rVal = oBusObj.GetValue("UDF_SHIPPINGMESSAGE$", sNewHire)

If InStr(UCase(sNewHire), UCase(searchString)) > 0 then	
	rVal = oHeaderObj.SetValue("UDF_NEWHIRE$", "Y")
End If 
 And double check your spelling of the UDF names.

jepritch · Answer

jland47 what event do you have this attached too? Are both the UDF_NewHire and UDF_ShippingMessage in the same table? 
 I just noticed you are using oBusObj.GetValue() to retrieve the value of UDF_ShippingMessage, but using oHeaderObj.SetValue() to update the UDF_NewHire. This would indicate to me that this is attached to a SO Lines event (Pre-Write?) or something? And the header has the UDF_NewHire. Is that correct? 
 
 E

jepritch · Answer

If both fields are in the header table then the SetValue should use oBusObj. and not oHeaderObj.

Sage 100

Search on Different Font/Format of Text within UDF

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING