Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Organize output with awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Organize output with awk
# 8  
Old 06-30-2018
Alternatively, there is also an option in Excel to use "fixed width" instead of a field separator when reading data. When I tried it only one of the thin dividing lines needed to be moved by one position and it lead to this result:
Code:
AB	XY	UT	ZW	PRAT	VLL	VMI	VKO	VER
0	3	4	7214800	93				
0	3	4	730770	93	39		5	
0	1	4	7318	93				
0	2	4	87477	187	102	7		0-0
0	9	4	49365	185				
0	1	4	5307	93

Last edited by Scrutinizer; 06-30-2018 at 01:47 AM..
This User Gave Thanks to Scrutinizer For This Post:
Ophiuchus
# 9  
Old 07-01-2018
Quote:
Originally Posted by RudiC
Look at lines 4 - 6 in your sample in post#1:


Code:
.
.
.
VLL  VMI  VKO  VER        # $0 ~ HD   {getline  --> found the header (HD); discard and read new line
      39         5        #            printf "%s", $0
                          #            getline  --> empty line; skip with getline
                          #            next     --> go read  and process next input line

Excellent. Thanks for the explanation.

---------- Post updated at 02:30 AM ---------- Previous update was at 02:28 AM ----------

Quote:
Originally Posted by Scrutinizer
Alternatively, there is also an option in Excel to use "fixed width" instead of a field separator when reading data. When I tried it only one of the thin dividing lines needed to be moved by one position and it lead to this result:
Code:
AB	XY	UT	ZW	PRAT	VLL	VMI	VKO	VER
0	3	4	7214800	93				
0	3	4	730770	93	39		5	
0	1	4	7318	93				
0	2	4	87477	187	102	7		0-0
0	9	4	49365	185				
0	1	4	5307	93

Hi Scrutinizer, Thanks for the tip. I did it in that way and it seems was the final step to parse it as I was looking for.Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is there a way to organize bash_profile across different platforms

I want to have one .bash_profile works on multiple platform, ubuntu, debian, redhat, cygwin, osx. So how should I organize .bash_profile? It can be multiple files in some subdir Let me brief you: what i want is a way to organize bash_profile across platforms so I can use one set of profiles... (2 Replies)
Discussion started by: John_Peter
2 Replies

2. Shell Programming and Scripting

Discover unique names and organize

I'm attempting to write a script that will look into a directory, discover all unique names, create directories for their prefix names and place the files inside. I do this now one by one with a simple script but I'd like to automate the process. The directory would contain something like: ... (6 Replies)
Discussion started by: scribling
6 Replies

3. Shell Programming and Scripting

Organize file according to their extension

Hi Everyone ! i want to make an application which is written in shell script and in Bourne shell (sh) i want, when my script is executed, it read all the files in the directly and move them to folders according to their extension. suppose i have a files: test.txt test.jpg test.docx... (1 Reply)
Discussion started by: me_newbie
1 Replies

4. Shell Programming and Scripting

need help for a script to organize data

Hey all, I have a file with info like this 12:05:44 DEV001 (15F6) 71 5 1372 131 58 100 6 0 17 DEV002 (15FA) 60 0 928 15 50 N/A 2 N/A 5 DEV003 (15FE) 77 2 961 59 51 100 1 0 2... (2 Replies)
Discussion started by: leo.maveriick
2 Replies

5. UNIX and Linux Applications

Organize (pretty) code

I'm looking for terminal programs, which organize and pretty code like HTML or JavaScript. Thanks! ---------- Post updated at 07:01 AM ---------- Previous update was at 01:49 AM ---------- Found this Online javascript beautifier (1 Reply)
Discussion started by: borobudur
1 Replies

6. Shell Programming and Scripting

Organize of Data

Hello Expert, I am new in awk. I would like to know how to arrange data like Input File: lpar1 1 2 3 4 5 6 lpar10 4 5 6 lpar3 4 5 (3 Replies)
Discussion started by: shah09
3 Replies

7. Shell Programming and Scripting

how organize my log file ( tabs )

hello i have written a multitask script which performs verifications on the server (RHEL 5 tikanga); based on list of rules. since the results are huge both in length and number and I am sending them all to my log file. Is there any method to organize the STATUS of my results in a defined... (1 Reply)
Discussion started by: goswami.c
1 Replies

8. Shell Programming and Scripting

looking for a simple way to organize envs on our unix box...

would like to standardize how we set envs on our unix box, so I thought a menu would be a great way to accomplish this. The problem I'm experiencing, is the value is set...but ONLY during the time the menu is initiated. please see below: > /home/is/bin/r12MENU.sh ... (2 Replies)
Discussion started by: mr_manny
2 Replies

9. UNIX for Dummies Questions & Answers

How do I organize a series of files in date order?

I'd like to ls a group of files in date order but I'm not sure what the commands would be. Can anyone help with this? (1 Reply)
Discussion started by: hedgehog001
1 Replies
Login or Register to Ask a Question