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
 All Forums
 Origin Forum
 Origin Forum
 How to auto-remove " " symbols from wooksheet?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
hearme Posted - 11/22/2003 : 11:13:29 PM
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
4   L A T E S T    R E P L I E S    (Newest First)
Hideo Fujii Posted - 11/26/2003 : 11:27:53 AM
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.
Hideo Fujii Posted - 11/25/2003 : 09:58:14 AM
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
Mike Buess Posted - 11/23/2003 : 07:25:50 AM
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
rlewis Posted - 11/23/2003 : 02:49:22 AM
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);
}

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000