Jump to content

Field calculation for text pattern


This topic is 2941 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Forum,

 

Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation:

IF(Order_Number = "PT00*", 1, 0)

Thank you for assisting,

Miss-Amen!

Link to comment
Share on other sites

Your test will only return 1 when the contents of the Order_Number field contains pt00*, PT00*, Pt00*, or pT00*.

Why did you put an asterisk in there?

Maybe this will get you a little closer to what you want.

If ( Left ( Order_Number ; 4 ) = "PT00" ; 1 ; 0 )

Edited by Kris M
  • Like 1
Link to comment
Share on other sites

This topic is 2941 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.