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
 Convert Text & numeric into numeric
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

cgr

Germany
5 Posts

Posted - 11/24/2015 :  09:38:52 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2015G (64-bit) Sr2
Operating System: win7

Dear all,

My problem might be "pretty Standard", but I simply can't find a solution for it:

I have imported data by hand and ended up with columns that contain voltages and "V AC".

How could I convert this into voltages only?

"230,00 V AC" --> "230,00"

Thank you very much!
cgr


p.s. Might be possible to solve this by the importing ASCII function, but in my case it would mean a lot of extrawork to import the data again.

Edited by - cgr on 11/24/2015 09:41:32 AM

snowli

USA
1391 Posts

Posted - 11/24/2015 :  10:11:05 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Just choose Edit: Replace.

In Find and Replace dialog,
On Replace tab, check Data Type: String
Find what "v ac" ---- no need to have quote
Leave Replace with blank.

Click Replace to check if this works.

Thanks, Snow Li
OriginLab Corp.

Edited by - snowli on 11/24/2015 10:12:57 AM
Go to Top of Page

cgr

Germany
5 Posts

Posted - 11/24/2015 :  11:04:22 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Snow Li,

it worked perfectly, thank you very much!

Best,
Christoph
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