F12 F11 F481 F55 F989 E1 E2 E3

8204 20160930 1064.848 test Y 10

8204A 20160930 1064.505 test Y 6 4

Thanks for all the help.Now things are getting lil more from previous.We have three more columns added E1,E2 ,E3.E3 doesnt have anything as off now .Just a placeholder. Now a new logic must be bulit for as below: F481 = IF (E2 NOT NULL) then (E1 - E2) / 2 ELSE (F481) So after computations the output must be as:

F12 F11 F481 F55 F989

8204 20160930 1064.848 test Y

8204A 20160930 1 test Y

The final output record format will be as per previous format .The first record meets the else part and hence remain unchanged . The second record gets computed as above.The new columns are never part of actual output

In reply to Re^4: perl file formatting by perlforsgs
in thread perl file formatting by perlforsgs

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.