The Origin Forum - Importing data with a semicolon delimitor

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Importing data with a semicolon delimitor

New Topic

Reply to Topic

Printer Friendly

Author

Topic

alaudo

Germany
Posts

Posted - 07/30/2005 : 08:05:24 AM

Origin Version (Select Help-->About Origin): 6.5 (English)
Operating System: Win XP

I have about 100 CSV files, where the values are separated with a semicolon. Origin does not recognize this delimitor and imports the data as text values (all numbers are preceeded with a semicolon).

It is possible to import the data manually by opening "Import Option" and selecting "Other" delimitor and entering semicolon. But this option is not saved, doesn't matter if I press "Update Option" or not. As soon as I want to import next worksheet, I have to go back to "Import Options" panel and set the delimitor once more. Therefore it is also not possible to import the worksheets massively, because the respective dialog doesn't have any options for entering importing parameters.
What would you recommend?

Alexander.

Mike Buess

USA
3037 Posts

Posted - 07/30/2005 : 09:00:15 AM

Hi Alexander,

After you Update Options you must save the worksheet template. (You get a message to that effect when you click Update Options.) Click the Save Template button (next to Save Project) on the standard toolbar.

Mike Buess
Origin WebRing Member

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000