exporting fields with carriage return

[iuanee]

hi, i am having a problem with the carriage returns in a field. after i export it to excel, the carriage returns are shown as a block.
the items in a field is placed together as one large field with the blocks in between.
but what i expected was that each item in a field is placed in excel as a different field.

can anyone please give me some ideas of how to solve this problem?

 

[Schlogg]

Are your carriage returns on the field or are you exporting two separate fields?
When you say "export to Excel" just what do you mean? You cannot export directly to Excel. You need to export your data as comma-separated (.CSV) or tab-delimited (.TAB) and then open the exported file with Excel.


Cheers,
Paul J.

 

[iuanee]

i used tab-delimited for export. let's say there are 3 items(3 lines) in a repeated field. after exporting, it appears as one single field with 2 blocks separating each item...

 

[Schlogg]

I presume you are the same Dan Lee who emailed me. Here is my reply (for the benfit of others)
Your request for help left out the most significant part of your problem - Repeating fields! These are a real bugger. They are not supported at all well and have very limited use. Generally, you are better off using a related child file or just using separate fields.
To answer your question - yes, use 3 separate fields for each repeating field. Define calculation fields
Repetition1 = GetRepetition(RepeatingField, 1)
Repetition2 = GetRepetition(RepeatingField, 2)
and so on.
These will export quite happily.

Cheers,
Paul J.

 

[iuanee]

yes, thank you very much
=)