Insight importer and data transformation

[Patrice Champet]

Hi There,

We are importing data to a Object Schema using Json Importer.

We have that field wich is a phone number, but not alway formated a standard way.

Is there any way to get, duing import, the last 8 digits of a string and add from instance a country code like +44, beg of the string.

The goal is to change something like 0123456789 or 123456789 to +44123456789.

Any advice ?