<HTML>
<HEAD>
<TITLE>Re: [EmData] Using characters within field as separator</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>OK, now I understand! So each 'line' is a single field, but in that field the languages are separated by bullets. <BR>
<BR>
Try this: go into XData Preferences, Data, Field Delimiter. Select 'Custom' from the drop down menu and type in the bullet character used. <BR>
<BR>
That way you can treat the Czech as the first field, Slovakian as the 2nd etc.<BR>
<BR>
You would still have problems as you want to use data from each record, then go back to the beginning....<BR>
<BR>
This can be done by reading records into an array, but I haven’t time right now to describe the process.<BR>
<BR>
Joe??? I think lateral thinking is called for and I need to get back to work!<BR>
<BR>
Sorry!<BR>
<BR>
<BR>
<BR>
<BR>
on 31.07.2008 11:13, stephen_ball at stephen_ball@eu.shr2shr.com wrote:<BR>
<BR>
<FONT COLOR="#000098">> Emma,<BR>
> <BR>
> example of actual fields below named FM1 and FM2<BR>
> <BR>
> FM1<BR>
> bavlna . bavlna . bawe<\#U0142>na . pamut . pamuk<BR>
> <BR>
> FM2<BR>
> nylon woven . nylon wav . nylon wen . nylon vew . naylon wev<BR>
> <BR>
> Up to first bullet point of each field is Czech, up to second bullet<BR>
> point of each field is Slovakian and so on...<BR>
> <BR>
> I need to extract data from each field<BR>
> (Czech/Slovakian/Polish/Hungarian/Turkish) so they are positioned next<BR>
> to each other.<BR>
> Using fields above, this would be layed out as:<BR>
> bavlna nylon woven *word(s) up to first bullet point of FM1 and FM2*<BR>
> bavlna nylon wav *word(s) up to second bullet point of FM1 and FM2*<BR>
> bawe<\#U0142>na nylon wen *word(s) up to third bullet point of FM1 and<BR>
> FM2*<BR>
> pamut nylon vew *word(s) up to fourth bullet point of FM1 and FM2*<BR>
> pamuk naylon wev *word(s) after fourth point of FM1 and FM2*<BR>
> <BR>
> Stephen.<BR>
> <BR>
> <BR>
> -----Original Message-----<BR>
> From: Emma Glaisher [<a href="mailto:emma.glaisher@fourninety.com]">mailto:emma.glaisher@fourninety.com]</a> <BR>
> Sent: 31 July 2008 10:32<BR>
> To: stephen_ball@eu.shr2shr.com; data-users@emsoftware.com<BR>
> Subject: Re: [EmData] Using characters within field as separator<BR>
> <BR>
> <BR>
> OK, I'm being dense. Does one record contain:<BR>
> <BR>
> Czech(1st), Czech(2nd).... Czech(9th), Slovakian(1st)........ Turk(9th)<BR>
> ?<BR>
> <BR>
> i.e. each record, or line, contains 45 fields, 9 each of 5 languages?<BR>
> <BR>
> So what you want to extract is:<BR>
> Field 1 . Field 2 . Field 3 ....... Field 9 [return]<BR>
> Field 10 . Field 11....<BR>
> ....<BR>
> Field 37 . Field 38...... Field 45<BR>
> <BR>
> This should be simple, so I think I'm missing the point somewhere!<BR>
> Please describe an actual record.<BR>
> <BR>
> Emma<BR>
> <BR>
> <BR>
> on 31.07.2008 10:31, stephen_ball at stephen_ball@eu.shr2shr.com wrote:<BR>
> <BR>
> <BR>
> Hi Emma,<BR>
> <BR>
> note there can be more than one word required for each field required<BR>
> for layout, such as "nylon woven".<BR>
> The fields (there can be up to 9 populated with data) currently contain<BR>
> data layed out as:<BR>
> Czech, Slovakian, Polish, Hungarian, Turkish<BR>
> <BR>
> I need to take the word(s) from each field if populated (separated by<BR>
> bullet points) to lay them out as:<BR>
> Czech(1st field), Czech(2nd field), Czech(3rd field), Czech(4th field),<BR>
> Czech(5th field), Czech(6th field), Czech(7th field), Czech(8th field),<BR>
> Czech(9th field)<BR>
> Slovakian(1st field), Slovakian(2nd field), Slovakian(3rd field),<BR>
> Slovakian(4th field), Slovakian(5th field), Slovakian(6th field),<BR>
> Slovakian(7th field), Slovakian(8th field), Czech(9th field)<BR>
> Polish(1st field), Polish(2nd field), Polish(3rd field), Polish(4th<BR>
> field), Polish(5th field), Polish(6th field), Polish(7th field),<BR>
> Polish(from 8th field), Polish(9th field)<BR>
> Hung(1st field), Hung(2nd field), Hung(3rd field), Hung(4th field),<BR>
> Hung(5th field), Hung(6th field), Hung(7th field), Hung(8th field),<BR>
> Hung(9th field)<BR>
> Turk(1st field), Turk(from 2nd field), Turk(from 3rd field), Turk(from<BR>
> 4th field), Turk(from 5th field), Turk(from 6th field), Turk(from 7th<BR>
> field), Turk(from 8th field), Turk(from 9th field)<BR>
> <BR>
> Regards.<BR>
> <BR>
> -----Original Message-----<BR>
> From: Emma Glaisher [<a href="mailto:emma.glaisher@fourninety.com]">mailto:emma.glaisher@fourninety.com]</a> <BR>
> Sent: 31 July 2008 10:13<BR>
> To: stephen_ball@eu.shr2shr.com; data-users@emsoftware.com<BR>
> Subject: Re: [EmData] Using characters within field as separator<BR>
> <BR>
> Certainly. But can you just include a few records so we can see exactly<BR>
> where and when the fields start? For example, 'nylon woven' is not one<BR>
> word but 2. So I just need to be clear how your data is structured.<BR>
> <BR>
> <BR>
> on 31.07.2008 10:15, stephen_ball at stephen_ball@eu.shr2shr.com wrote:<BR>
> <BR>
> <BR>
> I am trying to use bullet point characters within a field which<BR>
> contains foreign language translations as a separator.<BR>
> example below:<BR>
> <BR>
> bavlna . bavlna . bawe<\#U0142>na . pamut . pamuk,nylon woven .<BR>
> nylon wav . nylon wen . nylon vew . naylon wev<BR>
> <BR>
> Rather than laying out the fields as they appear above, I need to place<BR>
> the first, second, third, fourth and fifth word of each field next to<BR>
> each other:<BR>
> e.g.<BR>
> bavlna nylon woven<BR>
> bavlna nylon wav<BR>
> Is there any statement which can be used to incorporate the first,<BR>
> second, third and fourth bullet points as separators?<BR>
> <BR>
> Regards,<BR>
> Stephen Ball.<BR>
> <BR>
> <BR>
> This e-mail is private and may be confidential and is for the intended<BR>
> recipient only. If misdirected, please notify us by telephone and<BR>
> confirm that it has been deleted from your system and any copies<BR>
> destroyed. If you are not the intended recipient you are strictly<BR>
> prohibited from using, printing, copying, distributing or disseminating<BR>
> this e-mail or any information contained in it. <BR>
> * * * * * * * * * * * * * * * * * * * * * * * * * * <BR>
> We use reasonable endeavours to virus scan all E-mails leaving the firm<BR>
> but no warranty is given that this E-mail and any attachments are virus<BR>
> free. You should undertake your own virus checking. The right to<BR>
> monitor E-mail communications through our networks is reserved by us. <BR>
> <BR>
> <BR>
> Shore To Shore<BR>
> <BR>
> Your Global Source for Tags, Labels and Brand Packaging Solutions.<BR>
> <BR>
> www.shr2shr.com <BR>
> - -<BR>
> Inbound email: This email has been scanned for viruses by MessageLabs<BR>
> (Fourninety)<BR>
> <BR>
> <BR>
> <BR>
> <BR>
> _______________________________________________<BR>
> Data-users mailing list<BR>
> Data-users@emsoftware.com<BR>
> <a href="http://mail.emsoftware.com/mailman/listinfo/data-users">http://mail.emsoftware.com/mailman/listinfo/data-users</a><BR>
> <BR>
> <BR>
> <BR>
> - -<BR>
> Fourninety Limited, a member company of the Media Square plc group.<BR>
> Registered in England No. 3737606. Registered address Clarence Mill,<BR>
> Clarence Road, Bollington, Cheshire. SK10 5JZ<BR>
> <BR>
> Confidentiality Notice: The information in this document and any<BR>
> attachments are confidential. It is intended only for the use of the<BR>
> named recipient. If you are not the intended recipient please notify us<BR>
> immediately and delete this document. The contents on this document must<BR>
> not be disclosed to any other person nor may any copies be taken. The<BR>
> 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<BR>
> Internet e-mail is not a 100% secure communications medium. All<BR>
> liability for any claims arising as a result of using this medium to<BR>
> transmit information by us or to us is excluded to the extent permitted<BR>
> by law.<BR>
> <BR>
> This e-mail is private and may be confidential and is for the intended<BR>
> recipient only. If misdirected, please notify us by telephone and<BR>
> confirm that it has been deleted from your system and any copies<BR>
> destroyed. If you are not the intended recipient you are strictly<BR>
> prohibited from using, printing, copying, distributing or disseminating<BR>
> this e-mail or any information contained in it. <BR>
> * * * * * * * * * * * * * * * * * * * * * * * * * * <BR>
> We use reasonable endeavours to virus scan all E-mails leaving the firm<BR>
> but no warranty is given that this E-mail and any attachments are virus<BR>
> free. You should undertake your own virus checking. The right to monitor<BR>
> E-mail communications through our networks is reserved by us. <BR>
> <BR>
> <BR>
> Shore To Shore<BR>
> <BR>
> Your Global Source for Tags, Labels and Brand Packaging Solutions.<BR>
> <BR>
> www.shr2shr.com <BR>
> - -<BR>
> Inbound email: This email has been scanned for viruses by MessageLabs<BR>
> (Fourninety)<BR>
> <BR>
> <BR>
> <BR>
> <BR>
> - -<BR>
> Fourninety Limited, a member company of the Media Square plc group.<BR>
> Registered in England No. 3737606. Registered address Clarence Mill,<BR>
> Clarence Road, Bollington, Cheshire. SK10 5JZ<BR>
> <BR>
> Confidentiality Notice: The information in this document and any<BR>
> attachments are confidential. It is intended only for the use of the<BR>
> named recipient. If you are not the intended recipient please notify us<BR>
> immediately and delete this document. The contents on this document must<BR>
> not be disclosed to any other person nor may any copies be taken. The<BR>
> 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<BR>
> Internet e-mail is not a 100% secure communications medium. All<BR>
> liability for any claims arising as a result of using this medium to<BR>
> transmit information by us or to us is excluded to the extent permitted<BR>
> by law.<BR>
> <BR>
> <BR>
> This e-mail is private and may be confidential and is for the intended <BR>
> recipient only. If misdirected, please notify us by telephone and confirm that <BR>
> it has been deleted from your system and any copies destroyed. If you are not <BR>
> the intended recipient you are strictly prohibited from using, printing, <BR>
> copying, distributing or disseminating this e-mail or any information <BR>
> contained in it. <BR>
> * * * * * * * * * * * * * * * * * * * * * * * * * * <BR>
> We use reasonable endeavours to virus scan all E-mails leaving the firm but no <BR>
> warranty is given that this E-mail and any attachments are virus free. You <BR>
> should undertake your own virus checking. The right to monitor E-mail <BR>
> communications through our networks is reserved by us. <BR>
> <BR>
> <BR>
> Shore To Shore<BR>
> <BR>
> Your Global Source for Tags, Labels and Brand Packaging Solutions.<BR>
> <BR>
> www.shr2shr.com<BR>
> <BR>
> <BR>
> - -<BR>
> Inbound email: This email has been scanned for viruses by MessageLabs <BR>
> (Fourninety)<BR>
</FONT></SPAN></FONT>
<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>
</BODY>
</HTML>