EDI 850 flat file from Crystal Reports

[jpro]

I am trying to create a flat file to import as an 850INB EDI file.

I have extracted all of the data needed through Crystal and have been able to create a character seperated flat file, however I am having a problem seperating out the header,detail, and release sections.

I have tried to insert a carriage return field using chr(13), but it fails on import. I have narrowed it down to this being the problem because I was able to copy in the character from a good file into mine and it went through Ok.

Does anyone know what the correct character I should be using here?

 

[synapsevampire]

You might need a chr(13)+chr(10) as many systems expect a carriage return and line feed, or it may be that you only need the chr(10).

It's unclear what you need as the first paragraph states thatyt you're trying to import, when I believe that you're trying to build an export file in Crystal.

And "I have narrowed it down to this being the problem because I was able to copy in the character from a good file into mine and it went through Ok." says that you are copying things from a good file into mine, please state specifics, does this mean that you're copying from another text file into the Crystal generated export file, and then it works?

If so, please paste into this post what you're using if the above doesn't resolve.

Another trick is to paste it into CR in a formula and use asc("<your pasted character>") to see what the ascii equivalence is, or you can just use it in your formula in this fashion to append the proper character.

-k

 

[jpro]

Apologies for my descriptions, but you are correct I am creating an export file in CR to use for the EDI import.

I have tried the chr(10) alone and also tried the chr(10)+chr(13) with no luck.

The file that I have created from CR works when I copy that character in from an existing file that works.

When I tried to copy the character from the good file into the formula in CR, I simply get a blank character in the formula.

Attached is the working file and the file created from CR that I have tried using a chr(13).

Working File:

hdr|||||||||||Eastman Kodak Company||False|||0|LIBERTYCAR||38733|20050609|20050609|040554|||||Replenish|20050609||20050609|||||||||||||||||||||
det|||||||||Eastman Kodak Company|||||34-8507-8232-6B||0||LIBERTYCAR||38733|0101|||||||||||0|||Replenish|34-8507-8232-6B|M||||||||||||M||0||20050609|T|N|
rel|||0|LIBERTYCAR||38733|0101|20050609|||Replenish|20050609||20050609|00|||N

CR Generated File:

hdr|||||||||||Century Mold|585-352-8600|False|||0|CENTURYMOL||38733|20050708|20050620|102532|||||Replenish|20050620||20050708|||||||||||||||||||||
|det|||||||||Century Mold|585-352-8600||||PKG 1000||0||CENTURYMOL||38733|0101|||||||||||1750|||Replenish|PKG 1000|M||||||||||||M||0||20050708|T|N|
|rel|||0|CENTURYMOL||38733|0101|20050708|||Replenish|20050708||20050708|0|1750||N

Not sure if this will help or not? I can't seem to insert the files I am using.