Spliting text

[jeyanthi]

           5     1090223      224805
           0     1090223      224947
           5     1090223      224948
           0     1090223      225338
           5     1090223      225339
           0     1090223      230219
           5     1090223      230220
           0     1090223      231856
           5     1090223      231857
           0     1090223      232736
           5     1090223      232737
           0     1090223      234019
           5     1090223      234020
           0     1090223      234906
           5     1090223      234907
           0     1090224       04302
           5     1090224       04303
           0     1090224      134918
           5     1090224      134919
           0     1090224      135121
           5     1090224      135122
           0     1090226      135230

Up here is the sample data i get from my client... now they ask me to record the data every 5 minutes(clockwise time).

the five infront indicates the rain.

for example:  

           0     1090224      134918
           5     1090224      134919
           0     1090224      135121
           5     1090224      135122
           0     1090226      135230

1090224 1350

1090224 1355

1090225 0

The program have to this type of output how to do this??? plz help

[MattBradley]

Sorry, but I don't understand what you want.  Can you add some more detail?

[jeyanthi]

       Rain     Date          Time

0     1090223      231856            5     1090223      231857            0     1090223      232736            5     1090223      232737            0     1090223      234019            5     1090223      234020            0     1090223      234906            5     1090223      234907            0     1090224       04302            5     1090224       04303            0     1090224      134918            5     1090224      134919            0     1090224      135121            5     1090224      135122            0     1090226      135230

Red line indicates the rain data

Output:

For this data:        5     1090223      231857

Output first data wil be: 0.5  1090223 2320<--round up to the nearest using clockwise

   5     1090223      232737

  0.5  1090223 2330<--round up to the nearest using clockwise

   5     1090223      234020

  0.5  1090223 2345<--round up to the nearest using clockwise

For this data

  5     1090224      135122 <-- 0.5  1090224 1355<--round up to the nearest using clockwise

  0     1090226      135230<--- here the date shows 1090226 the previous date is not raining so record but i need to state the output as this  0  1090225 0000

                                                                                                                                                                                  
I want to programmatically done this how to do this need some help?.. Plz

[jeyanthi]

       Rain     Date          Time

0     1090223      231856            5     1090223      231857            0     1090223      232736            5     1090223      232737            0     1090223      234019            5     1090223      234020            0     1090223      234906            5     1090223      234907            0     1090224       04302            5     1090224       04303            0     1090224      134918            5     1090224      134919            0     1090224      135121            5     1090224      135122            0     1090226      135230

Red line indicates the rain data

Output:

For this data:        5     1090223      231857

Output first data wil be: 0.5  1090223 2320<--round up to the nearest using clockwise

   5     1090223      232737

  0.5  1090223 2330<--round up to the nearest using clockwise

   5     1090223      234020

  0.5  1090223 2345<--round up to the nearest using clockwise

For this data

  5     1090224      135122 <-- 0.5  1090224 1355<--round up to the nearest using clockwise

  0     1090226      135230<--- here the date shows 1090226 the previous date is not raining so record but i need to state the output as this  0  1090225 0000

                                                                                                                                                                                  
I want to programmatically done this how to do this need some help?.. Plz

[jeyanthi]

Red line indicates the rain data

Output:

For this data: 5 1090223 231857

Output first data wil be: 0.5 1090223 2320<--round up to the nearest using clockwise

5 1090223 232737

0.5 1090223 2330<--round up to the nearest using clockwise

5 1090223 234020

0.5 1090223 2345<--round up to the nearest using clockwise

For this data

5 1090224 135122 <-- 0.5 1090224 1355<--round up to the nearest using clockwise

0 1090226 135230<--- here the date shows 1090226 the previous date is not raining so record but i need to state the output as this 0 1090225 0000

I want to programmatically done this how to do this need some help?.. Plz

[MattBradley · Accepted solution]

This should give you a good start.

Still not sure what you mean by "round up to the nearest using clockwise".  And no idea about your last sentence(s?).  It would probably help if you used commas and periods.  Otherwise, what you are asking is almost incoherent.

[Baji]

Hi Jeyanthi,

     I monitored few of your post. your questions are little wage to understand.

like Ravens mentioned

Jeyanthi,

You'll need to rewrite question again.  Neither your subject line nor your message make any sense to me. 

The troublesome phrases:

"the out is in fraction"

"output in 17.22"

"value in point form"

"connect it to true case"

"if its a number I will pass to false case"

 

In this post its very difficul to understandyour question

mattbradley mentioned

Still not sure what you mean by "round up to the nearest using clockwise".  And no idea about your last sentence(s?).  It would probably help if you used commas and periods.  Otherwise, what you are asking is almost incoherent.

so before posting your questions put it in detail and explain your problem clearly,It is easy to us to answer your question and also usefull to u to get quick answers.

[jeyanthi]

Rain  Date(1YYMMDD) Time(HHMMSS) 

     5     1090223                231857

Red line indicates the rain data

Output:

For this data: 5 1090223 231857

Output first data wil be: 0.5 1090223 2320<--round up to the nearest using clockwise

5 1090223 232737

0.5 1090223 2330<--round up to the nearest using clockwise

5 1090223 234020

0.5 1090223 2345<--round up to the nearest using clockwise

For this data

5 1090224 135122 <-- 0.5 1090224 1355<--round up to the nearest using clockwise

0 1090226 135230<--- here the date shows 1090226 the previous date 190225 is not raining so record but i need to state the output as this 0 1090225 0000

I want to programmatically done this how to do this need some help?.. Plz

Actually if the time is let say 120102, i only round up the first4 digit, round up should b round up to 1205

So does 120600 i round up , it should round up 1210

Im sorry im not good in English ...I will try my best to explain..can u understand this?

[Baji]

Hi Jeyanthi,

 Did you tried, which mattbradley suggested.

[JeffL]

Here's a solution I came up with. I don't think it's as elegant as MattBradley's, though: http://decibel.ni.com/content/docs/DOC-4146