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
 How to auto-remove " " symbols from wooksheet?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

hearme

China
11 Posts
Posted - 11/22/2003 :  11:13:29 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
When I tried to input my experimental data into origin worksheet, I found data in one column are all in this style,
"23.444"
"24.444"
"26.444"
"29.444"
"35.444"
I want to remove the symbols "".It is difficult for me to do that manually because there to many data. I wonder if origin can do that automatically.

Thanks for any helps.
Hearme


Edited by - hearme on 11/22/2003 11:14:50 PM

rlewis

Canada
253 Posts
Posted - 11/23/2003 :  02:49:22 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
If you are using Origin 7.0 or later the following OriginC function will do the job ...


bool wks_col_remove_char(string strWksName, int ColumnNumber, char Character)
{
	Worksheet Wks;
	if (Wks.Attach(strWksName))
	{
		Column WksCol;
		if(WksCol.Attach(Wks,ColumnNumber))
		{
			int NumRows=Wks.GetNumRows();
			string strCellValue;
			for(int i=0;i<NumRows;i++)
			{
				Wks.GetCell(i,ColumnNumber,strCellValue);
				strCellValue.Remove(Character);
				Wks.SetCell(i,ColumnNumber,strCellValue);
			}
			return (true);
		}
	}
	return (false);
}
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 11/23/2003 :  07:25:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Or you can use this LabTalk script after selecting the column...

get %C -e npt;
loop (i,1,npt) {
%A=%C[i]$;
%C[i]=%A;
};

Mike Buess
Origin WebRing Member
Go to Top of Page

Hideo Fujii

USA
1582 Posts
Posted - 11/25/2003 :  09:58:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Did you try to set the Delimited:Delimiter option to Other and <"> ?
in the Import Options before you start importing?
I tried a simple dataset (with other columns wityh no <">),
and it removed the special character.



Edited by - Hideo Fujii on 11/25/2003 09:59:14 AM
Go to Top of Page

Hideo Fujii

USA
1582 Posts
Posted - 11/26/2003 :  11:27:53 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:

Did you try to set the Delimited:Delimiter option to Other and <"> ?
in the Import Options before you start importing?
I tried a simple dataset (with other columns wityh no <">),
and it removed the special character.


Also, if you have your data already in the worksheet, and if your Origin is version 7.5, copy your column to the clipboard, then you can "import" the data into another column with the above option.
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