Combining multiple fields into one for import :

Start a new topic

Combining multiple fields into one for import

Gregg Wade

started a topic almost 10 years ago

Hi there -

I'm importing a .csv file that has split out phone numbers into three separate fields: area code, phone number, extension. (Eg. "416","4824444","8806") I'd like to combine them into one and import into a phone field. Previously I've been doing this using the concatenate function in excel and overwriting one of the fields, but would prefer to skip this step.

Is there a regex for combining separate field values, or another method?

Thanks,

Gregg

3 Comments

Amanda Allen

said almost 10 years ago

Hi Gregg,

Unfortunately a RegEx wouldn't be able to concatenate these fields for you. Doing this step in excel is the way to go.

Please let me know if you have any other questions.

Thank you,
Amanda
Omatic Support

Gregg Wade

said almost 10 years ago

Hi Amanda -

Thanks for letting me know.

Gregg

Amanda Allen

said almost 10 years ago

You're welcome Gregg.

I also wanted to mention that this is something that could be accomplished by the IOM API. If you have a resource that can program in Visual Basic (VB/VBA) then they would be able to write this customization for you. You can have that person check out the API documentation to get started:
http://www.omaticsoftware.com/Forum...fault.aspx

If you do not have such a resource, we can provide this customization as a service.

Many thanks,
Amanda
Omatic Support

How can we help you today?