Skip to main content
Solved

Is it possible to use a wildcard in an IIF statement


Forum|alt.badge.img
  • Freshman I
  • 42 replies

I have a generic inquiry that I am using an IIF statement in the Results Grid to add and populate a column in the GI results.. 

The statement is as follows:

=IIf( [SOInvoice.DocDesc] = 'ROLLER', '050116', ' ' )

What I am running into is there have been a few time where the SOInvoice.DocDesc containers more than just “ROLLER”, it might have ROLLER - xyz. 

When the GI is run this field is empty if the parameter of ‘ROLLER’ isn’t exact. Is there a wildcard available in Acumatica like the * in VB?

Thank you!

Best answer by darylbowman

Use the Substring() function to get the first six characters and then compare against that.

 

Something like 

=IIf(Substring([SOInvoice.DocDesc], 0, 6)='ROLLER', '050116', ' ')

 

View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13

Use the Substring() function to get the first six characters and then compare against that.

 

Something like 

=IIf(Substring([SOInvoice.DocDesc], 0, 6)='ROLLER', '050116', ' ')

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 42 replies
  • June 14, 2023

darylbowman

Thank you for the quick reply and will give this a try..

Have a nice day!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings