Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Compare two fields
Hi,
I have two fields, field1 contains AA111 and field2 contains bb222, how can compare to say they are both in the same format i.e. Letter, Letter, #, #, #.
If field 2 contained c1234 then it would return false
i.e. case when {field1} = {field2} then T else F end
obviously that is the wrong formula but that is what i'd like to do
Thanks in advance!
0