BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
kaushik_pushpen
Community Trekker

How to extract a value?

Hello,

There is one value given in the table like +0.003-0.003. Into which i want to extract 0.003 value using script. Please help me.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
vince_faller
Super User

Re: How to extract a value?

You could use word to pick the first word and give it delimeters

Num( Word( 1, :Column 1, "+-" ) )

or a regex and grab the value itself between + and -

Num( Regex( :Column 1, "\+(.*)\-", "\1" ) )

Vince Faller - Predictum
2 REPLIES 2
vince_faller
Super User

Re: How to extract a value?

You could use word to pick the first word and give it delimeters

Num( Word( 1, :Column 1, "+-" ) )

or a regex and grab the value itself between + and -

Num( Regex( :Column 1, "\+(.*)\-", "\1" ) )

Vince Faller - Predictum
kaushik_pushpen
Community Trekker

Re: How to extract a value?

Thanks Vince

0 Kudos