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?"

  • Dec 10, 2016 8:00 PM UTC
  • 1 reply
  • 11 views
  • Translate All

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
  • Dec 11, 2016 6:48 AM UTC

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!

Translate