Need to remove extra characters from calculated value

Thanks Garret, that worked! Actually both ways work but sometimes the first digit (the 6 in my example) is not always a 6 and sometimes it’s a 2 or 3 digit number so how would I remove that?

Thanks for your help!

Hi @dpstear 

Use the REPLACE function which supports Regular Expression or REGEX

Text Source → lookup("siteURL|Workflow Configuration List", "Title", "Advansys Manager", "Person")
Expression → "\\d{1,3};#"
Replacement → “” 

replace( lookup("siteURL|Workflow Configuration List", "Title", "Advansys Manager", "Person"), "\\d{1,3};#", “”)

The Expression will search for → between 1 to 3 digits

;#Garrett → ;#Garrett     //No match
3;#Garrett → Garrett
23;#Garrett → Garrett
123;#Garrett → Garrett
0123;#Garrett → 0Garrett 

Hope that helps

Thanks so much Garrett, that works perfectly!

Hi,

You can also use the function ‘ParseLookup’

https://help.nintex.com/en-US/office365/Designer/Functions/parseLookup.htm

This function is here o remove this special extra characters ;)

For exemple : 

parselookup(lookup('MyList','ID',3,'Author'))