Dynamic output file generation using a input text file with predefined output format


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Dynamic output file generation using a input text file with predefined output format
# 1  
Old 04-26-2010
Dynamic output file generation using a input text file with predefined output format

Hi,

I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.

Example:

File.txt

AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc


---------

test.sh has following details (already created and working fine with local variables). But, overall I need this working with File.txt as input file to generate single predefined formatted file with different rows mentioned in File.txt file. Thanks a lot.

--------
Code:
#!/bin/csh -f
  set VAR1 = 1
  set LOG_FILE="/home/blabla.OUT"
  set VAR2 = 1
  set VAR3 = 1
  clear

# Check if connected and data files were copied
  set TMP_NUM = 0
  while ( $TMP_NUM <= 50 )
#  set LOG_FILE="/home/test/agent$VAR1.ldif"
      echo "dn: ou=agent$VAR1" >> $LOG_FILE
      echo "sunserviceID: 2.2_Agent" >> $LOG_FILE
      echo "ou: agent$VAR1" >> $LOG_FILE
      echo "SunKeyValue: userpassword=password$VAR2" >> $LOG_FILE
      echo "SunKeyValue: description=agent$VAR3" >> $LOG_FILE
      echo "sunsmspriority: 0" >>  $LOG_FILE
      echo "objectClass: sunServiceComponent" >>  $LOG_FILE
      echo "objectClass: top" >>  $LOG_FILE
      echo "sunKeyValue: sunIdentityServerDeviceStatus=Active" >>  $LOG_FILE
      echo "sunKeyValue: sunIdentityServerDeviceKeyValue=" >>  $LOG_FILE
      echo "  " >> $LOG_FILE
@ VAR1 ++
@ VAR2 ++
@ VAR3 ++
      @ TMP_NUM = $TMP_NUM + 1
  end

--------


I wanted to send File.txt into this test.sh to generate a single output file. So, for each row of File.txt, I wanted to repeat the same thing and continue until end of lines in File.txt to have one single output. Thanks a lot

Last edited by vbe; 04-27-2010 at 04:47 AM.. Reason: use code tags please
# 2  
Old 04-27-2010
Please show us the required output for the first line on input from file.txt.

Jean-Pierre.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies

2. UNIX for Beginners Questions & Answers

Have below input file and need the output as in output file

Hi Geeks, Have below input file and need the output Input File Uber: ABC=Pqrstuv ABC2 abc pqr , G=Pqrstuv Inc, CC=US Uber: ABC=Indiana (Automobile Business 2119), G=Indiana Group, CC=UK Uber: EMAIL=indiana@group2020.gc, ABC=indiana 2020 AC, GC=Products and Solutions Uber: ABC=Gitamo... (3 Replies)
Discussion started by: abhaydas
3 Replies

3. UNIX for Beginners Questions & Answers

Need list of input and output parameter of task in a text file, using shell script

//file begin ===== //some code task abcd_; input x; input y,z; //some comment output w; //some comment reg p; integer q; begin //some code end endtask : abcd_ //some code //file end ===== expected output from above... (1 Reply)
Discussion started by: rishifrnds
1 Replies

4. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

5. Shell Programming and Scripting

How to read each line from input file, assign variables, and echo to output file?

I've got a file that looks like this (spaces before first entries intentional): 12345650-000005000GL140227 ANNUAL HELC FEE EN 22345650-000005000GL140227 ANNUAL HELC FEE EN 32345650-000005000GL140227 ANNUAL HELC FEE EN I want to read through the file line by line,... (6 Replies)
Discussion started by: Scottie1954
6 Replies

6. Homework & Coursework Questions

Loop to Convert a list from an input file and output it to another file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: A) Write a script, which will take input from a file and convert the number from Centigrade to Fahrenheit... (5 Replies)
Discussion started by: AliTheSnake
5 Replies

7. Shell Programming and Scripting

Read from text file;format and print output

Hi Following is the assumed input... Symmetrix ID : 12345 Originator Port wwn : 123456789 User-generated Name : 123456789/123456789 Sym Dev Dir:P LUN ------ ----- ----------------------- ---- --- ---- ---- ---- ------- 1234 ... (4 Replies)
Discussion started by: maddy.san
4 Replies

8. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

9. UNIX for Dummies Questions & Answers

12. If an ‘88’ Record with BAI Code ‘902’ was found on input file and not written to Output file, re

This is my input file like this 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 49,+00000000000416920,00002/ 03,5313236,,015,+00231036992,,,045,+00231036992,,,901,+00000048428,,/ 88,100,+0000000000000,0000000,,400,+0000000000000,0000000,/ 88,902,+0000000079077,,/... (0 Replies)
Discussion started by: sgoud
0 Replies

10. Shell Programming and Scripting

generate tabular output from an input text file in unix shell scripting

Hi, I have the output (as below) which i want it to be in a table. For e.g. space utilization in PSE on path /logs is 0% space utilization in PSE on path /logs/tuxedo/tuxlsp is 16% space utilization in PSE on path /ldvarlsp/lsp/log is 37% space utilization in PSE on path /home is 6%... (7 Replies)
Discussion started by: pkbond
7 Replies
Login or Register to Ask a Question