cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Edit string/ replace function

Jump to solution

Hello, I am only a trainee and am currently learning to use Nintex.

Apologies if this question is easy to answer:

Well my problem is:

I have a calculated value which is doing a look up to a SharePoint list. Thats fine, it works.

But I want to edit the string.

Currently the calculated value is showing me: "Name, FirstName" but I want to see only the First name. How i could configure it?

My approach:

replace(parseLookup(lookup("/|Kostenstellen/Kostenträger","ID",KST/KT ID,"Verantwortlicher")),"","")

But I don't know which syntax/ command I have to use in the area replacePattern, replacement to geht every letter after the comma.


Example: Look Up = Yelnats, Chris

Goal: Look Up - Replace function (show me everything after comma) = Chris

Sorry for the German words, but i hope it's enough.

Thanks in advance!

If my approach is wrong anybody knows if I could use reg expression in Nintex Forms 2013?

Labels: (1)
Reply
2 Replies
Workflow Hero

Re: Edit string/ replace function

Jump to solution

You can use 'Replace' function like below to replace everything before comma with a empty string.

replace('Yelnats, Chris','.+(, )','')

0 Kudos
Reply
Workflow Hero

Re: Edit string/ replace function

Jump to solution

I had a ticket asking to add a column to their 2013 Nintex form & SP list.  

I expected to get the display value but it adds the item’s id and  ;# to display name.

i just want to see the display name as Text1 – Text2 

 I can remove the ;#  using Replace().

How can I remove the  [ID] number?

Below 6 is id number

replace(Teamscode, ";#", "") 

  6;#Text1 – Text2      to       6Text1 – Text2

0 Kudos
Reply