Splitting up Data

[ajb_1976]

i have a linked table from which i run an append query to produce a list of customer addresses. However the address appears in one field i.e addressline1 addressline2 etc and when displayed on a report it looks poor! is there any way that i can split this data out into 3 or 4 fields so they are displayed better on a report? Thanks

 

[KenHigg]

Can you post some sample data?

Ken

 

[ajb_1976]

re: splitting up data

sample data attached. thanks again

 

[KenHigg]

You may be able to do some kind of routine that splits the pcs out based on where the paragraph chars are...

I would investigate a fix on the app that collects the data...

Ken