The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Parsing CSV or Excel File		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

urana1@uco.edu

USA
4 Posts
Posted - 12/21/2017 :  10:43:28 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2018
Operating System: Windwos 10[

Hello,

I would appreciate if anyone could point me in the right direction to parse the multiple excel or csv files using batch processing. Please see below:

File 1

Water (cc) 30
Mass (kg) 28
Height (cm) 180
Pressure 1015


File 2

Pressure 1040
Water (cc) 40
Mass (kg) 56
Height (cm) 190


What I want after batch processing of file 1 and file 2?
***********************
File 1 File 2
Water (cc) 30 40
Mass (kg) 28 56
Height (cm) 180 190
Pressure 1015 1040





img]http://www.originlab.com/ftp/forum_and_kbase/Images/File1.png[/img]
Edited by - urana1@uco.edu on 12/21/2017 10:48:16 PM

JacquelineHe

287 Posts
Posted - 12/22/2017 :  05:14:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi

You can try to import these file in the multiple workbook(or worksheet) and then sort these worksheet by first column.
You can add this script in the "Script after Each File Imported" edit box, then the imported datasets are sort by first column
wsort descending:=1;


Then Append the Worksheets into one Worksheet (set Recalulate to None), then delete the repeated columns.

Plesae refer to thess help page of import , Append Workbook, and reduce column.
https://www.originlab.com/doc/X-Function/ref/impCSV
https://www.originlab.com/doc/X-Function/ref/impMSExcel
https://www.originlab.com/doc/Origin-Help/append-worksheet
https://www.originlab.com/doc/Origin-Help/Reduce-Columns

Thanks
Jacqueline
OriginLab
Go to Top of Page

urana1@uco.edu

USA
4 Posts
Posted - 12/22/2017 :  3:28:22 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you for the reply.

The excel file actually contains a lot of parameters along with their values. What I wanted to try is:

Search for specific parameter (e.g., mass), and parse this specific parameter "mass" along with its value (e.g., 28). I would like this result to be in a different sheet or workbook. I do not want to extract other parameters that exist in the excel sheet.

Thanks.
Go to Top of Page

JacquelineHe

287 Posts
Posted - 01/03/2018 :  10:29:23 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

After you import your datasets in to Origin, you can try to use Worksheet Query tool to extract your dataset.
Choose menu Worksheet: Worksheet Query to open the dialog.

Please refer to this help page:
https://www.originlab.com/doc/Origin-Help/Wks-Query-QS

Sample:


Thanks
Jacqueline
OriginLab
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000