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
# 29  
Old 06-05-2017
The use of backslashes in your example:
Code:
CurrentWeek,'\06/05/17\'

makes absolutely no sense to me at all. Please humor me and show us the results of running those same steps with each of the following alternative inputs:
Code:
CurrentWeek,'06/05/17'
CurrentWeek,"06/05/17"
CurrentWeek,06/05/17
CurrentWeek,'\"06/05/17\"'
CurrentWeek,06\/05\/17
CurrentWeek,06\\/05\\/17
CurrentWeek,06\\\/05\\\/17
CurrentQuarter,'"FY 2Q2017"'
CurrentQuarter,'\"FY 2Q2017\"'
CurrentQuarter,FY\ 2Q2017

# 30  
Old 06-05-2017
Hi Don -

I performed the task as you wished. What I did, in the interst of time, is just append a suffix to each to make them unique so I could import all at one time:

Here is what I added to to ${_SUBVARPATH}${_YEAR}_${_MONTH}${_DAY}/Subvar_List.txt so can be read in for import:

Code:
aCurrentWeek,'06/05/17'
bCurrentWeek,"06/05/17"
cCurrentWeek,06/05/17
dCurrentWeek,'\"06/05/17\"'
eCurrentWeek,06\/05\/17
fCurrentWeek,06\\/05\\/17
gCurrentWeek,06\\\/05\\\/17
hCurrentQuarter,'"FY 2Q2017"'
iCurrentQuarter,'\"FY 2Q2017\"'
jCurrentQuarter,FY\ 2Q2017

Here are the only ones that worked:

(see attached)

It does look like some variations worked. HOwever please note, the subvars suffixed with "q" (in my original list) needs to be imported WITH " surrounding the value.

Thank you for all your help, Don.
Parsing a column of text file - best practices-essbase_subvarpng
Last edited by SIMMS7400; 06-05-2017 at 09:56 PM..
# 31  
Old 06-05-2017
Also, here are the log files from the ones that failed to import:
20170605_204733_CS_Subvar_Advancement_cCurrentWeek_MAXL.txt (542 Bytes) 
20170605_204733_CS_Subvar_Advancement_eCurrentWeek_MAXL.txt (542 Bytes) 
20170605_204733_CS_Subvar_Advancement_fCurrentWeek_MAXL.txt (546 Bytes) 
20170605_204733_CS_Subvar_Advancement_gCurrentWeek_MAXL.txt (546 Bytes) 
# 32  
Old 06-05-2017
OK. Thanks for running the test. It looks like quoting is a lot simpler and saner than you had indicated before.
This User Gave Thanks to Don Cragun For This Post:
SIMMS7400
# 33  
Old 06-06-2017
Thank you, Don. Please let me know if you need anything else. Anxious to see the results.

Thanks!
# 34  
Old 06-11-2017
Hi Don -

Struggling with this one to account for those exceptions. Would this be something you could help me with in regards to the proper code?

Thank you!
# 35  
Old 06-11-2017
Hi SIMMS7400,
I'm still playing with it in the background... running into problems with more undefined variables and it appears that your script depends on being run from a certain directory which is not mentioned in your comments. So:
  1. What is the current working directory in which you run your script?
  2. How is _MAINPATH defined?
  3. How is _LOGPATH defined?
  4. How is _ERRORPATH defined?
  5. How is _STARTMAXLPATH defined? And, if it isn't defined to be an absolute pathname, in what directory is it located?
  6. How is _MAXLSCRIPTPATH defined?
  7. In what directory is CS_Subvar_Advancement.sh located?
  8. How are _ESSB_USER, _ESSB_PSWD, and _ESSB_SRVR defined?
I wouldn't be surprised if there will be more questions after these are answered, but I am making (slow) progress.
This User Gave Thanks to Don Cragun For This Post:
SIMMS7400
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