[EmData] Using characters within field as separator

[stephen_ball]

Hi Emma,
 
note there can be more than one word required for each field required
for layout, such as "nylon woven".
The fields (there can be up to 9 populated with data) currently contain
data layed out as:
Czech, Slovakian, Polish, Hungarian, Turkish
 
I need to take the word(s) from each field if populated (separated by
bullet points) to lay them out as:
Czech(1st field), Czech(2nd field), Czech(3rd field), Czech(4th field),
Czech(5th field), Czech(6th field), Czech(7th field), Czech(8th field),
Czech(9th field)
Slovakian(1st field), Slovakian(2nd field), Slovakian(3rd field),
Slovakian(4th field), Slovakian(5th field), Slovakian(6th field),
Slovakian(7th field), Slovakian(8th field), Czech(9th field)
Polish(1st field), Polish(2nd field), Polish(3rd field), Polish(4th
field), Polish(5th field), Polish(6th field), Polish(7th field),
Polish(from 8th field), Polish(9th field)
Hung(1st field), Hung(2nd field), Hung(3rd field), Hung(4th field),
Hung(5th field), Hung(6th field), Hung(7th field), Hung(8th field),
Hung(9th field)
Turk(1st field), Turk(from 2nd field), Turk(from 3rd field), Turk(from
4th field), Turk(from 5th field), Turk(from 6th field), Turk(from 7th
field), Turk(from 8th field), Turk(from 9th field)
 
Regards.
 
-----Original Message-----
From: Emma Glaisher [mailto:emma.glaisher at fourninety.com] 
Sent: 31 July 2008 10:13
To: stephen_ball at eu.shr2shr.com; data-users at emsoftware.com
Subject: Re: [EmData] Using characters within field as separator


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.


on 31.07.2008 10:15, stephen_ball at stephen_ball at eu.shr2shr.com wrote:



I am trying to use bullet point characters within a field which contains
foreign language translations as a separator.
example below:

bavlna . bavlna . bawe<\#U0142>na . pamut . pamuk,nylon woven . nylon
wav . nylon wen . nylon vew . naylon wev

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:
e.g.
bavlna  nylon woven
bavlna  nylon wav
Is there any statement which can be used to incorporate the first,
second, third and fourth bullet points as separators?

Regards,
Stephen Ball.


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. 
* * * * * * * * * * * * * * * * * * * * * * * * * * 
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. 
 

Shore To Shore

Your Global Source for Tags, Labels and Brand Packaging Solutions.

www.shr2shr.com 
- -
Inbound email: This email has been scanned for viruses by MessageLabs
(Fourninety)


  _____  

_______________________________________________
Data-users mailing list
Data-users at emsoftware.com
http://mail.emsoftware.com/mailman/listinfo/data-users




- -
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

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.

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.



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. 
* * * * * * * * * * * * * * * * * * * * * * * * * * 
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. 
 

Shore To Shore

Your Global Source for Tags, Labels and Brand Packaging Solutions.

www.shr2shr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://emsoftware.com/pipermail/data-users/attachments/20080731/b2942bc3/attachment-0001.html