Just some crude looking code, for a possible start (without awk)
Code:
copy file to file1
// loop thru while data in file
while ($wc -l file1 > 0)
do
// extract data from that first column
matchf = head -1 file1 | cut -f1
// pull out matching lines
grep $matchf < file1 > file3
// now temp file3 has common entries for first unique column value
// put these into your column format
// write these to file4
//
// copy everything but that first column match to file2
grep -v $matchf <file1 >file2
// copy temp file back to working file1
cp file2 file1
done
RudiC's approach in bash using Associative Arrays:-
Code:
#!/bin/bash
declare -A LN
declare -A HD
declare -A MX
while read v1 v2 v3
do
LN["$v1"]="$v1"
HD["$v2"]="$v2"
MX["${v1}${v2}"]="$v3"
done < filename
for j in "${LN[@]}"
do
printf "%10s" "$j"
for k in "${HD[@]}"
do
[ -z "${MX[${j}${k}]}" ] && printf "%10s" "null" || printf "%10s" "${MX[${j}${k}]}"
done
printf "\n"
done
Dear all,
Pzl let me know what is the syntax for converting the columns format to text as i have lots of values for but when i put these values in xls sheet the values are automatically converted to
and one more question i have is how to call values from shell script into perl script
eg.
... (3 Replies)
I have a script that creates a file with three column output. The columns look like this:
Policy Name Name Volume
VLS-EDWARDS-ARCHIVED_FILE-WINDOWS 10 12
XLZ-BASE-CYGWIN-ARCHIVED-FILE-LINUX 2 21
ZLX-GOLD-FILES-JAPANFILERS1-LINUX 20 27
ZLX-GOLD-FILES-JAPANFILERS2-LINUX13 29... (4 Replies)
Hi
I have a file that is several gigs in size and basically I want to change the format of it. Obviously I cannot go through it manually.
The file looks like this:
897 2
901 2
905 2
909 2
913 2
917 2
921 2
925 2
929 2
933 2
937 2
941 2
945 2
949 0 (1 Reply)
HI
I want to make it single row if start with braces i.e. { .Any idea
{1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4:
:R:GENL
:C::xx//xx1
:20C::yy//yy1
:2S:xxT}
{1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4:
:z:GENL
:v::xx//xx1
:10C::yy//yy1
:4S:xxT
... (2 Replies)
Hi all,
I'm a little stuck with a data file I've been collecting data in. The file contains one field of data running continuously down the file and I can't work out how to format the data into three columns.
This is a mock up of the file: Each r# is a random number and varies in length, this... (3 Replies)
i am writing a script that reads in a file and i just want it to print each element on a new line here is my code and the data that i want to read in
#!/usr/bin/perl
use strict;
use CGI qw(:standard);
use CGI qw(:cgi);
my $data_file = "/tmp/results.txt";
my $configuration;
my... (3 Replies)
Hi
This question has kind of been asked before but I couldn't get any of the solutions to work.
I need to format fields being cut from a file into columns so it looks like a table.
e.g
Full name Address Hiredate
Joe Smith London 11.01.01
Bill King ... (8 Replies)
I want to take a file that is generated in 132 columns from a unix based report generator and transfer it to a windows environment and preserve the column length. Any ideas how I can do this so that whatever windows based text editor that reads the document will know it should be in 132 columns?... (16 Replies)