<HTML>
<HEAD>
<TITLE>Re: [EmData] Using characters within field as separator</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Emma,<BR>
<BR>
Hmm, I took my data example from his first email, where he did have two comma-delimited fields.<BR>
<BR>
But, I could be wrong!<BR>
<BR>
Stephen, could you lease clarify?<BR>
<BR>
<BR>
Regards,<BR>
<BR>
Joe Mathia<BR>
Em Software Support / <a href="support@emsoftware.com">support@emsoftware.com</a> / www.emsoftware.com<BR>
(+1) 740 284 1010, fax (+1) 740 284 1210<BR>
<BR>
<BR>
<BR>
<BR>
On 7/31/08 9:49 AM, "Emma Glaisher" <<a href="emma.glaisher@fourninety.com">emma.glaisher@fourninety.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT SIZE="1"><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:9pt'>No, Joe, I don’t think so.<BR>
<BR>
It looks as if Stephen is using the word ‘field’ where we would use ‘record’.<BR>
<BR>
Each record contains 5 ‘fields’, separated by the bullet character. Field 1 is Czech, field 2 is Slovak, field 3 is Polish, field 4 is Hungarian, field 5 is Turkish.<BR>
<BR>
Stephen wants the Czech words together – i.e. field 1 of each record, then the Slovak words – i.e. field 2 of each record.<BR>
<BR>
That is why I thought he would need to use an array. Depending on how many records there are, of course. From his original mail I think there are only 9, in which case why use XData at all?<BR>
<BR>
How about 5 different prototypes, just changing the field number each time?<BR>
<BR>
Emma<BR>
<BR>
<BR>
<BR>
on 31.07.2008 15:41, Joe Mathia - Em Support at <a href="support@emsoftware.com">support@emsoftware.com</a> wrote:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10.5pt'>Hi Stephen and Emma,<BR>
<BR>
>From what I understand, the data looks something like this (this is 3 records, each containing 2 fields):<BR>
<BR>
bavlna . bavlna . bawe<\#U0142>na . pamut . pamuk,nylon woven . nylon wav . nylon wen . nylon vew . naylon wev<BR>
bavlna1 . bavlna1 . bawe<\#U0142>na1 . pamut1 . pamuk1,nylon1woven . nylon1wav . nylon1 wen . nylon1 vew . naylon1 wev<BR>
bavlna2 . bavlna2 . bawe<\#U0142>na2 . pamut2 . pamuk2,nylon woven2 . nylon wav2 . nylon2 wen . nylon2 vew . naylon2 wev<BR>
<BR>
If this is the case, a simple prototype like this will do the trick:<BR>
<BR>
«fields field1,field2¶<BR>
«set itemdelimiter to “.”¶<BR>
«trim(item 1 of field1)» «trim(item 1 of field2)»¶<BR>
«trim(item 2 of field1)» «trim(item 2 of field2)»¶<BR>
«trim(item 3 of field1)» «trim(item 3 of field2)»¶<BR>
«trim(item 4 of field1)» «trim(item 4 of field2)»¶<BR>
«trim(item 5 of field1)» «trim(item 5 of field2)»¶<BR>
¶<BR>
<BR>
Have a look at the attached — do an import from pasteboard. Its a QX7 doc. Let me know if you need it in InDesign.<BR>
<BR>
Does this help?<BR>
<BR>
Regards,<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><SPAN STYLE='font-size:10.5pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"><BR>
- -<BR>
Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ<BR>
<BR>
Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company.<BR>
<BR>
Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.<BR>
<BR>
</FONT></SPAN></BLOCKQUOTE>
</BODY>
</HTML>