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

substring(Form.VARIABLENAME,0,2) This gives complete text instead of Substring text

Jump to solution

I have a form with tthree field "First Name" , "Last Name" and "Date". I want to generate a case number using these fields. So, I created a Variable Named "CaseNumber" and the value equals -

"CASE"+"-"+substring(toUpper([Form].[First Name]),0,2)+"-"+substring(toUpper([Form].[Last Name]),0,2)+"-"+formatDate([Form].[Date],"DDMMYYYY")

When I try getting the first two letters of First Name or Last Name it Provides the Full text of the respective fields. What could have gone wrong ?

Nintex-Error1.jpgIn this I have substring First Name with 1,2 and Last Name with 0,2. I was Expecting Output as

"CASE-ON-ST-04092019"

Labels: (2)
0 Kudos
Reply
1 Reply
Nintex Employee
Nintex Employee

Re: substring(Form.VARIABLENAME,0,2) This gives complete text instead of Substring text

Jump to solution

Hi,
Nintex is aware of the issue when using the 0 index in a substring function.

The fix will be released in the near future.

Reply