Removing blank space from index field value

Introduction

When setting up index fields you may find spaces in places you do not want them. 

Step-by-step guide

Let's say you have "MBJ- 560805" in an index field and you want to remove the space between the dash and 5. Here is how you would do that:

  1. Proceed to Index Data Fields (Step 6 of 10)
  2. Click on Advanced tab > Select Matching Word Only (Custom Format) under "Populate Index field with" dropdown list
  3. Click Add > Enter following Regex code: (?i)(?<g1>\w{3}-)\s*(?<g2>\d{6,7})
  4. In Custom Format field enter the name of your groups: example: {g1} {g2}
  5. Save

If you are still experiencing difficulties, please contact our Support team by: