Each Record's Fields placed on a new line in exported file

[joseppic]

Hi,

I have to export record data for another DB.

However, the other DB requires one field per line, e.g.

If I have 2 records with 3 fields:

Rec1: Tree1 Stump1 Branch1

Rec2: Tree2 Stump2 Branch2

I need them to end up in the export file as:

Tree1

Stump1

Branch1

Tree2

Stump2

Branch2

All the fields are calculations so I can add in what I want but a carriage return (¶) does not force a new line in the exported file.

Any ideas?

Thanks.

Edited August 26, 2005 by Guest

[joseppic]

I really must read my own writing before submitting.

The Topic should read:

Each Record's Fields placed on a new line in the exported data file.

Edited August 26, 2005 by Guest

[Lee Smith]

Although we frown on someone changing a Subject Line, when you are submitting one, you can go back and edit it if you want. However, once someone has responded, just leave it as it is, we do not rely entirely on the subject anyway, as some member think it is original to say "Need Help" or "I'm New", or other things that have nothing to do with the problem or question involved.

At least you are trying.

As for your question...

If I'm understanding you now, you want to export your fields using a paragraph "¶" (a.k.a. PILCROW) instead of tab or comma.

You can do in a couple of ways.

Create a Tab file and run it through a text editor and replace the Tab or Comma with a Return, or Create an export field and use a calculation to gather the data as you wish.

Concatenate the fields using a calculation something like

Field 1 & "¶" & Field 2 & "¶" & Field 3

and then export the one field.

HTH

Lee

:cool:

[joseppic]

Hi,

I had done this and all I got when I pulled the export into an editor is a square character in notepad and ^K in Vi rather than a carriage return.

All I need is this export character to be considered a carriage return in notepad etc.

Do I need to export in a format other than Dos?

I tried this to no avail also.

Thanks for your help,

J

[comment]

Check this and this.

[Lee Smith]

Oops, I should have tested that my first suggestion.

The second suggestion about replacing the tabs with a return in a Text Editor would have worked though.

Lee