Parse imported mailing address into separate fields

What extension are you importing the data into and what do you need to separate it out for? The answer can different a bit depending on where it's being imported into and if you're simply trying to export that data to an spreadsheet or if you want to then parse it into mutliple other fields within the extension so that it can be displayed out.

Let us know, and we'll see how we can help. There's a few different options including parsing after the import or changing how the import is done in the first place.

Thanks,
Alex

Greg,
JLinked concatenates and tries to merge some fields together to make it easier to import. For instance, "Current Position" grabs the fields "Job Title" and "Company Name" and makes "Peon at Big MegaCorp, Inc" for import into CB or other extensions. When you first asked, I thought that maybe we were making one of those big fields out of street address, city, etc. Unfortunately, that's not the case. LinkedIn simply has a field called "main-address" which we pull and display. The problem with that is that there's no guaranteed formatting on it. In your LinkedIn profile, you can enter that data however you want. So, it could be returned as:
Alex Andreae
Big Corp
123 Easy Street
Anywhere, USA
12345
========
Big Corp
123 Easy Street
Anywhere, USA12345
========
123 Easy Street
Anywhere, USA, 12345
========
Or any other variation. It's basically however the user wants to enter it.. with their name, with their company name, no street address, multiple lines for address and PO box, etc.

Since those aren't discreet fields, we'd need to parse out the field that LinkedIn hands back. As you can see, that may not really be possible. I can gladly help you if you have ideas on "First line always goes to CB field (a), 2nd line to field (b)", but again, that likely won't line up very much.

If it was discreet fields that we were putting together, it'd be much easier as LinkedIn would have already parsed (or asked the user to input) them separately. With the way it is, I just don't see a method to pull the data apart.

Let me know if that helps or gives you any more thoughts/ideas.

Thanks,
Alex