I'm just wondering if it's possible to _divide_ values from a xml / csv import field and put different parts (strings) to different fields in Joomla!.
My goal is to import contact categories and contacts to these categories.
Here's the xml file (contact item):
<LSRMitarb>
<LSR_ID>69339902</LSR_ID>
<LSR_AMTSTITEL>Title</LSR_AMTSTITEL>
<LSR_TITEL>Title2</LSR_TITEL>
<LSR_NAME>Lastname</LSR_NAME>
<LSR_NGTITEL>Title 3</LSR_NGTITEL>
<LSR_DEF_ORG>organisation</LSR_DEF_ORG>
<LSR_VORNAME>firstname</LSR_VORNAME>
<LSR_EMAIL>firstname@organisation.tdl</LSR_EMAIL>
<LSR_TEL1>7011</LSR_TEL1>
<LSR_TEL2>7011</LSR_TEL2>
<LSR_FAX>faxnr</LSR_FAX>
<LSR_ABT>division (details of the division)</LSR_ABT>
<LSR_ZIMMER>room</LSR_ZIMMER>
</LSRMitarb>
I need the LSR_ABT field to be the category of the contact. But it would be really helpful if only the first part (until "("

Is this possible? Is there any documentation?
Thanks a lot!
Chris