Thread: ALINES
View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dorian C. Chalom Dorian C. Chalom is offline
external usenet poster
 
Posts: 15
Default ALINES

VFP 6.0 and I do not know what the End of Line character is I am working on
determining that.

But I did discover if I do nlines = ALINES(laData, STRTRAN(cStrng, "|",
CHR(10)+CHR(13))) instead of nlines = ALINES(laData, STRTRAN(cStrng, "|",
CHR(13)))
it does take care of the "||" issue. Howeve now I am running into a "|"
{end of line} issue...and it goes on.

Thank you.

"Peter Jamieson" wrote in message
...
FoxPro? Which version?

Is it possible to specify the end-of-line character explicitly in an
additional parameter, and if so, does that make a difference?

Peter Jamieson

http://tips.pjmsn.me.uk

On 01/05/2010 21:48, Dorian C. Chalom wrote:
What if the data line looks like:
200|823757|MATTHEW H|BUTLER|9852 DUBLIN DRIVE||MANASSAS |VA|20109|99

it is not reading the Null field (||). How can I get it to create the
null
field?

Thank you...

nlines = ALINES(laData, STRTRAN(cStrng, "|", CHR(13)))
DO CASE
CASE laData(1) = "200"
m.MemNum = laData(2)
m.FName = laData(3)
m.LName = laData(4)
m.MailAddr1 = laData(5)
m.MailAddr2 = ""
m.MailCity = laData(6)
m.MailState = laData(7)
m.MailZip = laData(8)
m.MailCode = laData(9)