cancel
Showing results for 
Search instead for 
Did you mean: 
gdgonzal
Nintex Newbie

Length() from Numeric Field

Jump to solution

Hello All:

I have a purchase requisition field within a Nintex Form and I need to set a rule that would allow either 8 or 9 digit length numbers.  I thought I would just set a form variable to make this determination at runtime using:

length(MyPurchaseRequisitionField)

However, after testing this using a calculated fielded on the form, I noticed it would return "#value!‌ " if I entered into this field "123" or any fully numeric string.  If, on the other hand, I entered "123a" then I would get a correct length of 4.

Obviously length() seems only capable of working with either an alpha or alpha-numeric string and not a fully numeric string.

Originally I had planned on using this variable within a validation rule and the "||" or logic to enable this but without being able to determine the length of a fully numeric string I am stuck.

Does anyone know a way around this or perhaps has another idea of how to accomplish this type of validation?

Reply
8 Replies
Automation Master
Automation Master

Re: Length() from Numeric Field

Jump to solution

Try this instead:

length(subString(Name,0,length(Name)))

123 equates to 3 for me

Reply
mlauer
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

Why not using range validation?

Reply
gdgonzal
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

Worked perfectly!  Thanks!

Reply
Automation Master
Automation Master

Re: Length() from Numeric Field

Jump to solution

OK just be careful I looked at another post earlier, similar issue, where substring ignores any leading zeros.  it happens on above solution too.  so if you are likely to have leading zeros you will need something else (though I can't work out what yet)!

Reply
gdgonzal
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

Thanks for the heads-up; however, I'm good as I've no leading zeros to contend with. 

Reply
Highlighted
gdgonzal
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

Thanks for the advise, I appreciate it.

Reply
kdelcastillo
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

This seemed to work until I got to 23 numbers. For example, the string "012345678901234567890123" returns 22 as the length. Numbers beyond that continued to report 22. If I add a character to it, it returns the correct value. If I remove the character, it goes back to 22.

0 Kudos
Reply
vinopalj
Nintex Newbie

Re: Length() from Numeric Field

Jump to solution

I am so glad you pointed this out, as I came across this for a project I'm working on and do have leading 0's. Thank you!

 

For my use case, I only care about how many characters are in the number that I am storing in a text control, not what the numbers are, so I was able to use the replace function to change the 0's to 1's, then use the length function on that. So I ended up with with this formula in my calculated value control:

 

length(replace(Name,"0","1"))

 

I was then able to create a rule to hide my panel so that they can't fill out the rest of the form until they put the right amount of characters in the control. I was using a regular expression as another comment suggests, but I wanted to catch them sooner than when they submit for this particular form.

0 Kudos
Reply