Tag Archives: Nintex Workflow 2007

Remove Line Breaks in Text Using a Regular Expression in Nintex Workflow

You can remove line breaks in a text string using the Regular Expression action in Nintex Workflow.

Here are the steps to follow:

  1. Insert a Regular Expression action into your Nintex Workflow.
  2. Configure it with the following settings:
    1. Pattern = [\r\n]
    2. Replacement text = Keep this empty (or use a replacement character)
    3. Input text = Insert your text string (you can insert a reference to data in a list column or workflow variable)
    4. Store result in = Text workflow variable
  3. You can then use the workflow variable as you need it.

RegExRemoveLineBreaks

Regular Expression to Get All Characters After a Specific Character in Nintex Workflow

You can get all the characters after a specific character in a string using Nintex Workflow.

Here are the steps to follow:

  1. Insert a Regular Expression action into your Nintex Workflow.
  2. Configure it with the following settings:
    1. Pattern = (^.*?(?=-)-)  where the “-” is the character (replace both “-” with your desired character)
    2. Replacement text = Keep this empty
    3. Input text = Insert your text string (you can insert a reference to data in a list column or workflow variable)
    4. Store result in = Text workflow variable
  3. You can then use the workflow variable as you need it.

Here are some examples from using this Regular Expression:

String Regular Expresssion Result
abc123-xyz456 (^.*?(?=-)-) xyz456
abc123;xyz456 (^.*?(?=;);) xyz456
abc123?xyz456 (^.*?(?=[?])[?]) xyz456

Remove a Forward Slash at the End of a URL String in Nintex Workflow

I recently had a need to remove a forward slash (“/”) from the end of a URL text string using Nintex Workflow.  Here are the steps to follow:

  1. Insert a Regular Expression action into your Nintex Workflow.
  2. Configure it with the following settings:
    1. Pattern = /[^/]*$
    2. Replacement text = Keep this empty
    3. Input text = Insert your URL text string
    4. Store result in = Text workflow variable
  3. You can then use the workflow variable as you need it.

Completed Nintex Workflow Pro Certificate and Nintex Workflow Admin Certificate

I recently completed both the Nintex Workflow Pro Certificate and the Nintex Workflow Admin Certificate.

The Workflow Pro Certificate is for skilled Nintex platform users and covers designing, creating, and debugging Nintex workflows and forms.

The Nintex Workflow Admin Certificate is for skilled Nintex platform administrators and covers various abilities and knowledge including the installation and maintenance of the Nintex Platform.

Remove Spaces from Text Strings with Nintex Workflow

You can easily remove all spaces in text strings in Nintex Workflows. Follow these steps:

  1. Insert a Regular Expression action into the workflow.
  2. Configure it with the following settings:
    1. Pattern = \s
    2. Replacement text = Keep this empty
    3. Input text = Insert your text string
    4. Store result in = Text workflow variable
  3. You can then use the workflow variable as you need it.

Nintex Workflow Tips and Tricks eBook

I can officially now say that I’m published! Be sure to download the “Nintex Workflow Tips and Tricks” eBook that I authored. Lots of great hints and best practices for Nintex Workflow.

Get the Nintex Workflow Tips and Tricks eBook

Remove Spaces from Text Strings with Nintex Workflow

You can easily remove all spaces in text strings in Nintex Workflows.  Follow these steps:

  1. Insert a Regular Expression action into the workflow.
  2. Configure it with the following settings:
    1. Pattern = \s
    2. Replacement text = Keep this empty
    3. Input test = Insert your text string
    4. Store result in = Text workflow variable
  3. You can then use the workflow variable as you need it.

Updating a SharePoint Hyperink Field with Nintex Workflow

To update a SharePoint hyperlink list field, use the following format:

http://www.url.com, Description

Make sure you have a space between the two entries.

You can enter the value directly into the Nintex “Set field value” or “Update item” actions to update a SharePoint hyperlink field. You could also store the value in a workflow variable and then use it update the field.

Number Rounding Using Nintex Workflow (Part 2)

In my previous post titled “Number Rounding Using Nintex Workflow (Part 1)“, I discussed how to round a number using Nintex Workflow.

Well, it turns out that this approach only works for numbers less than 1,000. When you run the previous workflow I mentioned on a number greater than or equal to 1,000, you get the following error message in the “Convert value” step:

Error parsing value. Value ‘fn-Round(12,345.6789)’ is not compatible with the selected output variable type Number (double).

The issue seems to revolve around the commas in the number.

Resolution:
In order to remedy this issue, I had to modify the workflow to include these steps:

  1. Add a “Set a condition” action to check if the number is greater than or equal to 1,000.
    • If the number is less than 1,000, you can go to Step 2 below.
    • If the number is greater than or equal to 1,000, then follow Steps 3-6 below.
  2. Configure the “Build string” action to use the fn-Round Inline Function and store the result in a text workflow variable (i.e. wfvRoundedNumberText). Go to Step 7 next.
  3. Create a new text workflow variable to store the rounded number with commas (i.e. wfvConvertNumber).
  4. Configure the “Build string” action to use the fn-Round Inline Function and store the result in wfvConvertNumber. Go to Step 5 next.
  5. Use a “Regular expression” action to remove the commas in the text workflow variable from Step 2. Configure the action with these settings (then go to Step 6):
    • Pattern = ,
    • Operation = “Replace text”
    • Leave “Replacement text” empty
    • Input text = wfvConvertNumber
    • Store result in = wfvConvertNumber
  6. Use the “Set variable” action to set wfvRoundedNumberText = wfvConvertNumber.
  7. Configure a “Convert value” action to convert the wfvRoundedNumberText variable back to a number store in the Number workflow variable.

You can then use the Number workflow variable in the remainder of your workflow.

Here’s what the workflow should look like:
Nintex Workfow Number Rounding

Number Rounding Using Nintex Workflow (Part 1)

Rounding a number via Nintex Workflow is a two-step process. Start by creating a “Single line of text” and a “Number” workflow variable.

Step 1 – Round the Number

Use the “Build string” action and configure it to use the fn-Round Inline Function. Set the action fields to:

Text = fn-Round({ItemProperty:Number})

Store result in = Text workflow variable

The {ItemProperty:Number} field can be an inserted reference of a value, item property or workflow variable.

Step 2 – Convert the Number

Use the “Convert value” action to convert the text value in Step 1 back to a number. Configure the action with:

Input = Text workflow variable

Store result in = Number workflow variable

You can then use the Number workflow variable within the rest of your workflow.

Update: There seems to be an issue with numbers greater than or equal to 1,000. I address this issue in my Number Rounding Using Nintex Workflow (Part 2) post.