Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parsing a column of text file - best practices
Top Forums UNIX for Beginners Questions & Answers Parsing a column of text file - best practices Post 302998663 by SIMMS7400 on Monday 5th of June 2017 04:59:51 PM
Old 06-05-2017
Hi Don -

Thanks for the reply.

I do not have historical content as I'm going through an effort to automate this as it's currently done manually. Then, I'll enable an archive piece (as you see in the script).

The content does not get shipped to customers. What happens is it produces the content output as shown above. Then, the shell script reads col1 and col2 and imports that into the target system as substitution variable and its value.

The \/' symbols are used to import. The particular engine that does the actual import (maxl) requires those symbols as escape characters to import properly.

So, lets just test one, CurrentWeek.

${_SUBVARPATH}${_YEAR}_${_MONTH}${_DAY}/Subvar_List.txt is created with the following content:

Quote:
CurrentWeek,'\06/05/17\'
Then, the shell script reads col1 and col2, passes those values to a Maxl script as shown here:

Code:
#::-- Read file contents into variables and pass to MaxL --::#

while IFS=',' read col1 col2
do

export subvar=$col2

_MAXLLOGFILE=${_INTRAPATH}/${_FN}_${col1}_MAXL.log

. ${_STARTMAXLPATH} ${_MAXLSCRIPTPATH}Update_Subvars.mxl ${_ESSB_USER} ${_ESSB_PSWD} ${_ESSB_SRVR} ${_MAXLLOGFILE} $col1 $subvar

done < ${_SUBVARPATH}${_YEAR}_${_MONTH}${_DAY}/Subvar_List.txt

The MaxL file (${_MAXLSCRIPTPATH}Update_Subvars.mxl) is as follows:

Code:
/* Spool MaxL output to log file */

spool on to $4;

echo MaxL script parameters;
echo Passed in Subvar       = $5;
echo Passed in Subvar value = $subvar;

/* login <UserName> <Password> on <Essbase Server> */
login $1 $2 on $3;

alter system drop variable $5;
alter system add variable $5 $subvar;

logout;
spool off;
Exit 0;

In the above code, $5 is the subvar (col1) and $subvar is the value (col2).

The log file is as follows:

Code:
---------------------------------------------------------
CS_Subvar_Advancement.sh beginning at 164709
---------------------------------------------------------
---------------------------------------------------------
Prepare Subvars
---------------------------------------------------------
---------------------------------------------------------
Prepare Subvars : Successful
---------------------------------------------------------
---------------------------------------------------------
Advance Subvar Values
---------------------------------------------------------
---------------------------------------------------------
Advance Subvar Values : Successful
---------------------------------------------------------
---------------------------------------------------------
Update Subvars on exalytics-madc-01.server.lan
---------------------------------------------------------
~/Hyperion_Batch/Files/Subvar/2017_0605 ~
~

 Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.4.008B019)
 Copyright (c) 2000, 2016, Oracle and/or its affiliates.
 All rights reserved.

MaxL script parameters

Passed in Subvar       = CurrentWeek

Passed in Subvar value = 06/05/17

MAXL> login admin welcome1 on exalytics-madc-01.server.lan;

 OK/INFO - 1051034 - Logging in user [admin@Native Directory].
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> alter system drop variable CurrentWeek;


MAXL> alter system add variable CurrentWeek '06/05/17';

 OK/INFO - 1056090 - System altered.

MAXL> logout;

      User admin is logged out


  MaxL Shell completed

---------------------------------------------------------
Update Subvars on exalytics-madc-01.server.lan : Successful
---------------------------------------------------------

---------------------------------------------------------
CS_Subvar_Advancement.sh - Completed Successfully

Normal Exit
---------------------------------------------------------

And then the the import process reflects the subvar and value as follows:

(see attachment).

So again, the \/'" symbols are used as escape characters for the MAXL engine to import correctly with spaces, slashes and double quotes in the value.

Does that make more sense?
Last edited by SIMMS7400; 06-05-2017 at 07:48 PM..
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
All times are GMT -4. The time now is 07:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy