<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'>Certainly. But can you just include a few records so we can see exactly where and when the fields start? For example, ‘nylon woven’ is not one 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>
</SPAN></FONT><BLOCKQUOTE><SPAN STYLE='font-size:12.0px'><FONT FACE="Arial">I am trying to use bullet point characters within a field which contains foreign language translations as a separator.<BR>
example below:<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">bavlna • bavlna • bawe<\#U0142>na • pamut • pamuk,nylon woven • nylon wav • nylon wen • nylon vew • naylon wev<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">Rather than laying out the fields as they appear above, I need to place the first, second, third, fourth and fifth word of each field next to 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, second, third and fourth bullet points as separators?<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT FACE="Arial">Regards,<BR>
Stephen Ball.<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
<BR>
This e-mail is private and may be confidential and is for the intended recipient only. If misdirected, please notify us by telephone and confirm that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it. <BR>
* * * * * * * * * * * * * * * * * * * * * * * * * * <BR>
We use reasonable endeavours to virus scan all E-mails leaving the firm but no warranty is given that this E-mail and any attachments are virus free. You should undertake your own virus checking. The right to 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 (Fourninety)<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></FONT></SPAN><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'>_______________________________________________<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>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'><BR>
</SPAN></FONT></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>