Sponsored Content
Top Forums Shell Programming and Scripting Script to complete all fields of template Post 302919457 by renderuas on Wednesday 1st of October 2014 11:23:03 AM
Old 10-01-2014
Question Script to complete all fields of template

Hello gurus;

I need to do a script to complete a technical template and I don't have idea to how to do Smilie I've try with bash and awk or sed but my brain is empty in this script. I need help please.

The incoming file is a csv with an index number, first occurence in the possition of the element, the number of line for the element, type of element and name of the element, this is an example of imput file:
Code:
1;0;1;Service;TEST Operating;;;;;;;;;;;;;;;;;;;
2;1;1;System;LoadBalancer_5;;;;;;;;;;;;;;;;;;;
3;2;1;System;HTTP_Server_4;;;;;;;;;;;;;;;;;;;
4;3;1;System;AS_KXKK1;;;;;;;;;;;;;;;;;;;
5;4;1;System;LDAP;;;;;;;;;;;;;;;;;;;
6;5;1;Component;LDAP;;;;;;;;;;;;;;;;;;;
7;4;2;Component;p_TEST;;;;;;;;;;;;;;;;;;;
8;4;3;Component;WASSRV5;;;;;;;;;;;;;;;;;;;
9;3;4;System;AS_KXKK2;;;;;;;;;;;;;;;;;;;
10;4;4;System;LDAP;;;;;;;;;;;;;;;;;;;
11;5;4;Component;LDAP;;;;;;;;;;;;;;;;;;;

This is an explanation of the first line of the imput file:
Code:
INDEX;POSSITION_IN_LINE;NUMBER_OF_LINE;TYPE_OF_ELEMENT;ELEMENT
1;0;1;Service;TEST Operating;;;;;;;;;;;;;;;;;;;

The idea is generate an output file with all type of elements and elements filled and if no previus element in the line is complete i need put the same element that is in the upper row:
Code:
1;Service;TEST Operating;System;Loadbalancer_5;System;HTTP_Server_4;System;AS_KXKK1;System;LDAP;Component;LDAP;;;;;;
2;Service;TEST Operating;System;Loadbalancer_5;System;HTTP_Server_4;System;AS_KXKK1;Component;p_krex;;;;;;;;
3;Service;TEST Operating;System;Loadbalancer_5;System;HTTP_Server_4;System;AS_KXKK1;Component;WASSRV5;;;;;;;;
4;Service;TEST Operating;System;Loadbalancer_5;System;HTTP_Server_4;System;AS_KXKK2;System;LDAP;Component;LDAP;;;;;;

The line one puts each possition, the first line is easy because I have all elements with the "NUMBER_OF_LINE" field but in the rest of lines I don't have idea that how complete with the rest of elements.

Please help me SmilieSmilieSmilie

I've attached two example files to try explain better that my english Smilie sorry for that.

May thats for your time.

Ren



Moderator's Comments:
Mod Comment Please use code tags next time for your code and data. Thanks
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

BASH complete-filename & menu-complete together

Hi, Does anyone know how to make BASH provide a list of possible completions on the first tab, and then start cycling through the possibilites on the next tab? Right now this is what I have in my .bashrc: bind "set show-all-if-ambiguous on" bind \\C-o:menu-complete This allows... (0 Replies)
Discussion started by: Mithu
0 Replies

2. Shell Programming and Scripting

Expect script does not complete

I am new to Expect and need an expect script to expect data from a telnet session and respond with options as written in the script. There is no human input required. Problem is it gets to a point in the script and will just end. I have tried adjusting 'set timeout' and still does not help. The... (0 Replies)
Discussion started by: NQReady
0 Replies

3. Infrastructure Monitoring

Zabbix Template and PERL Script for Monitoring Apache2

Hello, Kindly find attached a copy of the Zabbix template and PERL script we are using to monitor our Apache2 server. Here are the entries for zabbix_agentd.conf UserParameter=apache2.total_accesses,/etc/zabbix/zabbix_apache2.pl|cut -f1 -d":"... (4 Replies)
Discussion started by: Neo
4 Replies

4. Shell Programming and Scripting

Script template for inputting filenames and print results

Hi, Hope you are all well. New to scripting, and all those characters are all a new language for me. Though hoping to get my little head round it all sooner or later. I was wondering whether anyone could help with a script template example. What I would like to happen is to run the script... (8 Replies)
Discussion started by: loky27
8 Replies

5. Programming

Perl script to create latex template.

Hi, I have XML file and I extracted some tags and stored in hash, my data as look like this $var1={ 'stud.xml'={ '24'=>'<address> <streetname="xxxx"/> <housenum="138"/"> ... (9 Replies)
Discussion started by: veerubiji
9 Replies

6. Shell Programming and Scripting

Script to create EVIM template with SAS extension

I write lots of SAS programs and would like to create a script that allows me to have a template each time I create a new program file. Specs: I use EVIM for my editor. I run SAS in batch mode. We use RedHat 6. I don't use c shell. I want a script that will do the following: >... (3 Replies)
Discussion started by: starbecks
3 Replies

7. Shell Programming and Scripting

Tip: template for a safe and portable script

In an attempt to finally end this article I start this new thread. Here is a template for a safe and portable script. #!/bin/bash # /bin/bash exists on most still supported Unixes # # tr and date behave better with if ; then export LC_ALL=C; else export LANG=C; fi # # Unix optional packages... (2 Replies)
Discussion started by: MadeInGermany
2 Replies
All times are GMT -4. The time now is 02:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy