Edit string/ replace function

  • 24 November 2017
  • 3 replies
  • 122 views
C
Badge

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?

3 replies

L
Badge +9

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

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

210968_pastedImage_1.png

S
Badge +1

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

Jsilverman
Badge
Hi Shannis,
You can use .* in place of everything before the # to remove the [ID] value and the semicolon.
The formula should look like this - replace(Teamscode, ".*#", "")
- Jon

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings