How to get the right string from Variable using PARSE VAR ?

jackzhang75 · Active User Joined: 09 Jun 2014 Posts: 125 Location: US

Hi experts,

I want to get only 2015.317 from following variable like

enrico-sorichetti · Posted: Mon Nov 16, 2015 10:30 pm

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

You can also know this if you know the starting position of date:

jackzhang75 · Active User Joined: 09 Jun 2014 Posts: 125 Location: US

Thank you expters , thats work perfect

jackzhang75 · Active User Joined: 09 Jun 2014 Posts: 125 Location: US

Another question , how to split 2015.317 into two varible ? one for 2015 as YEAR one for 317 as Date ?

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

If you understand the above 2 methods then it should be really simple. What method are you using ?

Nic Clouston · Posted: Tue Nov 17, 2015 8:32 pm

As that line is fixed format you could have used SUBSTR.
Read the manual about PARSE.

Marso · Posted: Tue Nov 17, 2015 9:00 pm

There are many ways:

Willy Jensen · Posted: Thu Nov 19, 2015 1:31 am

you could also do
dv=word(translate(var,' ','-'),5)
yes I know you asked for PARSE

Willy Jensen · Posted: Thu Nov 19, 2015 1:59 am

or with parse, as there is only one dot in the string:
parse var v . '.' -4 dv +8 .