Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Parsing a column of text file - best practices

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Parsing a column of text file - best practices
# 43  
Old 06-18-2017
Quote:
Originally Posted by SIMMS7400
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. Smilie
# 44  
Old 06-20-2017
Quote:
Originally Posted by Aia
Four weeks worth on the case for free. You should be more than thankful. Smilie
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!! Smilie
# 45  
Old 06-20-2017
Perhaps you could push the Smilie 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
This User Gave Thanks to rbatte1 For This Post:
drl
# 46  
Old 07-08-2017
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!
# 47  
Old 07-08-2017
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"'

# 48  
Old 08-18-2017
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!
# 49  
Old 08-31-2017
Hi Don -

I hope you've been well!! I was wondering if you may happen to have an update? if not, no problem - just wanted to check in to make sure you didn't need anything from me?

Thank you!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing a fixed column text file in sed

I have a text file with records of the form: A X1 Y1 X2 Y2 X3 Y3 where A is character length 10, Xi is character length 4 and Yi is numeric length 10. I want to parse the line, and output records like: A X1 Y1 A X2 Y2 A X3 Y3 etc Can anyone please give me an idea of how to do this. ... (4 Replies)
Discussion started by: wvdeijk
4 Replies

2. Shell Programming and Scripting

Parsing text file

Hi Friends, I am back for the second round today - :D My input text file is this way Home friends friendship meter Tools Mirrors Downloads My Data About Us Help My own results BLAT Search Results ACTIONS QUERY SCORE START END QSIZE IDENTITY CHRO STRAND ... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

3. Shell Programming and Scripting

Parsing text file

I'm totally stumped with how to handle this huge text file I'm trying to deal with. I really need some help! Here is what is looks like: ab1ba67c331a3d731396322fad8dd71a3b627f89359827697645c806091c40b9 0.2 812a3c3684310045f1cb3157bf5eebc4379804e98c82b56f3944564e7bf5dab5 0.6 0.6... (3 Replies)
Discussion started by: comp8765
3 Replies

4. Programming

Parsing a Text file using C++

I was trying to parse the text file, which will looks like this ###XYZABC#### ############ int = 4 char = 1 float = 1 . . ############ like this my text file will contains lots of entries and I need to store these entries in the map eg. map.first = int and map.second = 4 same way I... (5 Replies)
Discussion started by: agupta2
5 Replies

5. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

7. Shell Programming and Scripting

Need help parsing a text file

I have a text file: router1#sh ip blah blah | incl --- Gi2/8 10.60.4.181 --- 10.60.123.175 11 0000 0000 355K Gi2/8 10.60.83.28 --- 224.10.10.26 11 F9FF 3840 154K Gi2/8 10.60.83.198 --- ... (1 Reply)
Discussion started by: streetfighter2
1 Replies

8. Shell Programming and Scripting

Column wise file parsing.

Shell script for the below operation : File "A" contains : SEQ++1' MOA+9:000,00:ABC' RFF+AIK:000000007' FII+PH+0170++AA' NAD+PL+++XXXXXXXXXXX XXXXXXX XX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL' SEQ++2' MOA+9:389,47:ABC' RFF+AIK:02110300000008' FII+PH+0PSTBNL2A:25:5+BB'... (5 Replies)
Discussion started by: navojit dutta
5 Replies

9. Shell Programming and Scripting

Parsing text from file

Any ideas? 1)loop through text file 2)extract everything between SOL and EOL 3)output files, for example: 123.txt and 124.txt for the file below So far I have: sed -n "/SOL/,/EOL/{p;/EOL/q;}" file Here is an example of my text file. SOL-123.go something goes here something goes... (0 Replies)
Discussion started by: ndnkyd
0 Replies

10. Shell Programming and Scripting

Text File Parsing

Hey Guys.I am a newbie on Bash Shell Scripting and Perl.And I have a question about file parsing. I have a log file which contains reports about a communication device.I need to take some of the reports from the log file.Its hard to explain the issue.but shortly I can say that, the reports has a... (2 Replies)
Discussion started by: Djlethal
2 Replies
Login or Register to Ask a Question