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

Remove special characters from lookup field

Jump to solution

Hey there,

I am trying to get the text value from a lookup field (this is looking up another SharePoint list) without the special characters in the value.

I used a calculated field to get the value from the Project Name field however I don't want the 1;# special characters in the value that I want to write to the SharePoint list.

Is there a way I can remove these values, preferably within the form, or within a workflow?

Below is the value I am dealing with.

Appreciate the assistance on this.

Lookup value.jpg

 

 

Labels: (1)
0 Kudos
Reply
4 Replies
Highlighted
jackgelo
Nintex Newbie

Re: Remove special characters from lookup field

Jump to solution

Hi,

 

yes, you can do that using parseLookup function..

 

with parseLookup(namedControl) you'll get the text value of the lookup while with parseLookup(namedControl,false) you'll get the ID of the selected item (that is shown before ;# in your screenshot)

 

Giacomo

Reply
XenoIcon
Nintex Newbie

Re: Remove special characters from lookup field

Jump to solution

Hey @jackgelo

thank you so much for the solution you provided. The solution was perfect with a slight change.

I think it was the way I wrote my initial request but I only wanted the text value, none of the special characters or ID, but what I did was use your solution but changed the value to true as displayed below.

  • Get text value only: parseLookup(namedControl,true) 

 

Again I appreciate the quick response and helping me learn a little more about Nintex! Smiley Happy

0 Kudos
Reply
jackgelo
Nintex Newbie

Re: Remove special characters from lookup field

Jump to solution

Hi,

 

usually it would work also without the true parameter, but effectively I can remember some cases where I have to put it, while when I need the output with false parameter then it's always required..

 

Glad to know you've solved your issue! Smiley Happy

0 Kudos
Reply
XenoIcon
Nintex Newbie

Re: Remove special characters from lookup field

Jump to solution

Thanks for pointing that out to me. I will keep an eye on it, so I’m not caught out.

Again thank you, the client is now completely happy with their solution.

0 Kudos
Reply