Jump to content

Problem exporting to XL


This topic is 7630 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm trying to export FMP 5 records to XL. There are 6 cal fields (text) containing return characters. I export the fields in dbf but it also works using sylk and wks formats. The problem is that when I open the file in XL, I lose the return characters. They are replace by a funny character or by a blank space.

Is there a solution around this?

------------------

Luc Therrien, MN, RN

[email protected]

me.com

[email protected]

Link to comment
Share on other sites

quote:

Originally posted by Manticore:

I'm trying to export FMP 5 records to XL. There are 6 cal fields (text) containing return characters. I export the fields in dbf but it also works using sylk and wks formats. The problem is that when I open the file in XL, I lose the return characters. They are replace by a funny character or by a blank space.

Is there a solution around this?


ALL, let me repeat that ALL, text based files treat the return character as a record delimiter. You would need to export the data and create some kind of custom parsing macro in Excel in order to do this properly.

My question would be why are you exporting the return character to Excel?

I might suggest changing the Return character to some other odd character, exporting the file, importing it into Excel and then replacing the odd character with the return chracter.

You might also look and see if Excel has some options to deal with this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

This topic is 7630 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.