Skip to main content
Nintex Community Menu Bar

Lookup result: 83;#Lastname, Firstname. How do I get rid of the \83;#\" at the beginning of the returned value?"

  • December 10, 2016
  • 1 reply
  • 6 views

Forum|alt.badge.img+3

Hello! I have a Caculated Value field that retrieves a value, from another list, with this formula: lookup(“ContOB”, “RefID”, RefID, “Manager”) .It does get the correct Manager name but in this format: 83;#Lastname, Firstname. How do I get rid of the "83;#" at the beginning of the returned value?

1 reply

Forum|alt.badge.img+3
  • Author
  • December 11, 2016

I did find the answer: parseLookup(lookup(“ContOB”, “RefID”, RefID, “Manager”),true)

https://ootbtutorials.com/2016/05/02/runtime-function-examples-for-nintex-forms/

Thank you, Nick Hurst!