Unix/Linux Go Back    


UNIX for Beginners Questions & Answers If you're not sure where to post a Unix or Linux question, post it here. All unix and Linux beginners welcome in this forum!

Parsing a column of text file - best practices

UNIX for Beginners Questions & Answers


Reply    
 
Thread Tools Search this Thread Display Modes
    #43  
Old Unix and Linux 06-18-2017
Aia's Unix or Linux Image
Aia Aia is offline
Registered User
 
Join Date: May 2008
Last Activity: 2 August 2017, 1:08 AM EDT
Posts: 1,633
Thanks: 46
Thanked 623 Times in 584 Posts
Quote:
Originally Posted by SIMMS7400 View Post
Hi Don -

Thank you for all your help. I reviewed your above post and everything looks 100% - I see no issues or anything that needs correcting.

Thank you!!!!
Four weeks worth on the case for free. You should be more than thankful. Linux
Sponsored Links
    #44  
Old Unix and Linux 06-20-2017
SIMMS7400 SIMMS7400 is offline
Registered User
 
Join Date: Apr 2016
Last Activity: 18 August 2017, 7:10 AM EDT
Posts: 107
Thanks: 23
Thanked 3 Times in 3 Posts
Quote:
Originally Posted by Aia View Post
Four weeks worth on the case for free. You should be more than thankful. Linux
I certainly am! Don has been a huge help and I can't thank him enough. If only he wasn't in CA, I'd buy him dinner and beers!! Linux
Sponsored Links
    #45  
Old Unix and Linux 06-20-2017
rbatte1 rbatte1 is offline Forum Staff  
Root armed
 
Join Date: Jun 2007
Last Activity: 18 August 2017, 12:35 PM EDT
Location: Lancashire, UK
Posts: 3,208
Thanks: 1,369
Thanked 616 Times in 557 Posts
Perhaps you could push the Linux Thanks button on one of Don's posts.

There is no cash allocation (we all help each other for free here) but it is a way to give some kudos.


Kind regards,
Robin
The Following User Says Thank You to rbatte1 For This Useful Post:
drl (06-20-2017)
    #46  
Old Unix and Linux 07-08-2017
SIMMS7400 SIMMS7400 is offline
Registered User
 
Join Date: Apr 2016
Last Activity: 18 August 2017, 7:10 AM EDT
Posts: 107
Thanks: 23
Thanked 3 Times in 3 Posts
Hi Don -

I hope you've been well! I feel like an idiot asking you this, as you are helping me free of charge and out of the goodness of your heart, but would you happen to have an update on this?

Just curious, thank you so much!
Sponsored Links
    #47  
Old Unix and Linux 07-08-2017
Don Cragun's Unix or Linux Image
Don Cragun Don Cragun is online now Forum Staff  
Administrator
 
Join Date: Jul 2012
Last Activity: 19 August 2017, 7:04 AM EDT
Location: San Jose, CA, USA
Posts: 10,463
Thanks: 533
Thanked 3,660 Times in 3,123 Posts
I apologize for the delay. I need to devote a couple of days to finish off the code and test it. And, I haven't had any extended time that I could devote to it recently. This is the kind of thing that isn't easy to spend an hour on it and come back later without taking another hour to get back to where i left off. Rest assured that I am still working on it.

Hoping it will help a little bit, there are runs showing the output you should get from running this today and on the next two Saturdays...
For today:

Code:
"1PeriodPrior",JUN17
"1PeriodPriorq",'"JUN17"'
"2PeriodPrior",MAY17
"2PeriodPriorq",'"MAY17"'
ALLC_CurrentPeriod,JUL17
ALLC_CurrentPeriodq,'"JUL17"'
ALLC_CurrentWeek,'07/08/17'
ALLC_CurrentWeekq,'"07/08/17"'
CurrentHalfq,'"FY 2H2017"'
CurrentPeriod,JUL17
CurrentPeriodq,'"JUL17"'
CurrentPlanYear,'FY 2017'
CurrentPlanYearq,'"FY 2017"'
CurrentQtrInput,'FY 3Q2017_input'
CurrentQtrInputq,'"FY 3Q2017_input"'
CurrentQuarter,'FY 3Q2017'
CurrentQuarterq,'"FY 3Q2017"'
CurrentWeek,'07/08/17'
CurrentWeekq,'"07/08/17"'
CurrentYear,'FY 2017'
CurrentYearq,'"FY 2017"'
FirstQtrWeek,'07/01/2017'
LastQtrWeek,'09/23/2017'
PriorQtrInput,'FY 2Q2017_input'
PriorQuarter,'FY 2Q2017'
PriorQuarterq,'"FY 2Q2017"'
PriorQuarterAD,'AD2-17'
PriorQuarterADq,'"AD2-17"'
PriorQuarterMnth1,APR17
PriorQuarterMnth1q,'"APR17"'
PriorQuarterMnth2,MAY17
PriorQuarterMnth2q,'"MAY17"'
PriorQuarterMnth3,JUN17
PriorQuarterMnth3q,'"JUN17"'

For next Saturday (July 15, 2017):

Code:
"1PeriodPrior",JUN17
"1PeriodPriorq",'"JUN17"'
"2PeriodPrior",MAY17
"2PeriodPriorq",'"MAY17"'
ALLC_CurrentPeriod,JUL17
ALLC_CurrentPeriodq,'"JUL17"'
ALLC_CurrentWeek,'07/15/17'
ALLC_CurrentWeekq,'"07/15/17"'
CurrentHalfq,'"FY 2H2017"'
CurrentPeriod,JUL17
CurrentPeriodq,'"JUL17"'
CurrentPlanYear,'FY 2017'
CurrentPlanYearq,'"FY 2017"'
CurrentQtrInput,'FY 3Q2017_input'
CurrentQtrInputq,'"FY 3Q2017_input"'
CurrentQuarter,'FY 3Q2017'
CurrentQuarterq,'"FY 3Q2017"'
CurrentWeek,'07/15/17'
CurrentWeekq,'"07/15/17"'
CurrentYear,'FY 2017'
CurrentYearq,'"FY 2017"'
FirstQtrWeek,'07/01/2017'
LastQtrWeek,'09/23/2017'
PriorQtrInput,'FY 2Q2017_input'
PriorQuarter,'FY 2Q2017'
PriorQuarterq,'"FY 2Q2017"'
PriorQuarterAD,'AD2-17'
PriorQuarterADq,'"AD2-17"'
PriorQuarterMnth1,APR17
PriorQuarterMnth1q,'"APR17"'
PriorQuarterMnth2,MAY17
PriorQuarterMnth2q,'"MAY17"'
PriorQuarterMnth3,JUN17
PriorQuarterMnth3q,'"JUN17"'

And, for two weeks from today (July 22, 2017):

Code:
"1PeriodPrior",JUN17
"1PeriodPriorq",'"JUN17"'
"2PeriodPrior",MAY17
"2PeriodPriorq",'"MAY17"'
ALLC_CurrentPeriod,JUL17
ALLC_CurrentPeriodq,'"JUL17"'
ALLC_CurrentWeek,'07/22/17'
ALLC_CurrentWeekq,'"07/22/17"'
CurrentHalfq,'"FY 2H2017"'
CurrentPeriod,JUL17
CurrentPeriodq,'"JUL17"'
CurrentPlanYear,'FY 2017'
CurrentPlanYearq,'"FY 2017"'
CurrentQtrInput,'FY 3Q2017_input'
CurrentQtrInputq,'"FY 3Q2017_input"'
CurrentQuarter,'FY 3Q2017'
CurrentQuarterq,'"FY 3Q2017"'
CurrentWeek,'07/22/17'
CurrentWeekq,'"07/22/17"'
CurrentYear,'FY 2017'
CurrentYearq,'"FY 2017"'
FirstQtrWeek,'07/01/2017'
LastQtrWeek,'09/23/2017'
PriorQtrInput,'FY 2Q2017_input'
PriorQuarter,'FY 2Q2017'
PriorQuarterq,'"FY 2Q2017"'
PriorQuarterAD,'AD2-17'
PriorQuarterADq,'"AD2-17"'
PriorQuarterMnth1,APR17
PriorQuarterMnth1q,'"APR17"'
PriorQuarterMnth2,MAY17
PriorQuarterMnth2q,'"MAY17"'
PriorQuarterMnth3,JUN17
PriorQuarterMnth3q,'"JUN17"'

Sponsored Links
    #48  
Old Unix and Linux 23 Hours Ago
SIMMS7400 SIMMS7400 is offline
Registered User
 
Join Date: Apr 2016
Last Activity: 18 August 2017, 7:10 AM EDT
Posts: 107
Thanks: 23
Thanked 3 Times in 3 Posts
HI Don -

I forgot to to provide an update in regards to the content in your last post. Those values matched perfectly when running the current process for those weeks. It looks like the code you're establishing is working just fine!

Thanks!
Sponsored Links
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Parsing a fixed column text file in sed wvdeijk Shell Programming and Scripting 4 06-25-2015 04:23 PM
Parsing text file jacobs.smith Shell Programming and Scripting 7 08-15-2012 06:20 PM
Parsing text file comp8765 Shell Programming and Scripting 3 03-18-2012 05:39 PM
Column wise file parsing. navojit dutta Shell Programming and Scripting 5 02-02-2009 03:21 AM
Text File Parsing Djlethal Shell Programming and Scripting 2 02-27-2008 02:31 AM



All times are GMT -4. The time now is 07:04 AM.