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
 Converting String to Integer

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
Shivavishnu Posted - 03/18/2018 : 6:26:36 PM
Hi,

I'm a novice here, and could use some help. I have a column of string data that looks like:
time frame: 225.55695~225.6712
time frame: 31.1949~32.9995

I'd like to apply something to the F(x)= of an adjacent column that will calculate the duration from those strings. If anyone could point me in the right direction. It would be much appreciated.

Thanks,
Tharanee

Origin Ver. and Service Release (Select Help-->About Origin): Origin Student 2018 b9.5.0.193
Operating System: Windows 10 Home
2   L A T E S T    R E P L I E S    (Newest First)
Shivavishnu Posted - 03/18/2018 : 7:56:41 PM
That blog post is exactly what I need. Thank you!!!
cpyang Posted - 03/18/2018 : 6:58:22 PM
Like this, assuming your text is in column A


value(token(A,2,"~")$) - value(token(A,1,"~")$)



and you can read more on this blog:

http://blog.originlab.com/data-handling/extracting-dates-from-text-strings

CP

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