| Author |
 Topic  |
|
|
dwheeler
USA
3 Posts |
 Posted - 08/27/2013 : 12:35:59 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): Origin 9.0.0 SR2
Operating System: Windows XP SP3
I have a worksheet filled with the contents of a batch processing. The first column of the summary sheet is the filename. I'd like to insert a "B" column that contains a numeric value extracted from the filename in column A.
I've gotten as far as this:
In the "Set values" dialog box, I insert the following:
col(b)=
Substitute(Mid(Col("Dataset"),11,6)$,".","_")
The results in col(b) being filled with the correct information, but it's formatted as a string, and so I can't do a subsequent calculation on that data Is there a way to convert this string to a double using the "Set values" dialog? Or is this a quick thing I can throw into the script window? |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 08/27/2013 : 3:01:45 PM
|
Hi dwheeler,
Maybe you can try this way:
Say, your numeric strings are stored in col(B), you can run the Set Column Values tool
with the following formula:[In the "Before Formula Scripts" box]:
dataset loose1;
copy col(B) loose1;
[In the main "Col(C)=" formula box]:
loose1 Here, loose1 is a name of a loose dataset, which has the numeric dataset type, and the strings are converted to numeric values.
Does it work?
--Hideo Fujii
OriginLab |
 |
|
|
snowli
USA
1386 Posts |
Posted - 08/27/2013 : 4:49:25 PM
|
BTW dwheeler,
Sorry for the inconvenience, in coming 9.1, we have added a Value() function which can change numeric strings into numeric.
Thanks, Snow Li
OriginLab Corp.
|
Edited by - snowli on 08/27/2013 4:49:49 PM |
|
|
|
dwheeler
USA
3 Posts |
Posted - 08/28/2013 : 3:08:29 PM
|
That works perfectly, thank you.
quote:
Originally posted by Hideo Fujii
Hi dwheeler,
Maybe you can try this way:
Say, your numeric strings are stored in col(B), you can run the Set Column Values tool
with the following formula:[In the "Before Formula Scripts" box]:
dataset loose1;
copy col(B) loose1;
[In the main "Col(C)=" formula box]:
loose1 Here, loose1 is a name of a loose dataset, which has the numeric dataset type, and the strings are converted to numeric values.
Does it work?
--Hideo Fujii
OriginLab
|
|
|
|
dwheeler
USA
3 Posts |
Posted - 08/28/2013 : 3:11:56 PM
|
That's great news! It seemed like a simple function, and I couldn't seem to find any documentation on it glad to know I wasn't just missing it.
quote:
Originally posted by snowli
BTW dwheeler,
Sorry for the inconvenience, in coming 9.1, we have added a Value() function which can change numeric strings into numeric.
Thanks, Snow Li
OriginLab Corp.
|
|
|
| |
Topic |
|
|
|
Convert string to double in column value