Start a new topic

RegEx to concatenate/combine two fields

Is there a way to combine/concatenate two fields to import in to one RE field? We have two data fields eg appeal code and cs code and we want to combine these to import to one constituent attribute 'appeal code-cs code'. We can do this in excel but ideally would like IOM to handle this during import. I’ve been advised this isn’t an available as part of the ‘out of the box’ IOM but suggestions that someone maybe able to offer help on how to achieve this in RegEx using dictionary. Can you advise if this is possible either through the profile it self or using Reg Ex in a dictionary. Many thanks.

2 people have this question
1 Comment

Hi Andrea,

Sorry for the late reply, I think I was on vacation when you posted this.  Dictionaries can only manipulate data from one field at a time so they can't read the data from two different fields and combine them together.

If you have access to the IOM API this is a very easy customization to write.

Let's say you want to combine first and last name into one field.  In the before or after dictionaries section you could do something like

Import.Fields.GetByExcelName("B").Value = Import.Fields.GetByExcelName("B").Value & " " & Import.Fields.GetByExcelName("C").Value



1 person likes this
Login or Signup to post a comment