Extract columns from a file if the name dont exist put blank Post: 302459398

Sponsored Content

Top Forums Shell Programming and Scripting Extract columns from a file if the name dont exist put blank Post 302459398 by durden_tyler on Monday 4th of October 2010 02:47:45 PM

10-04-2010

Registered User

Since you haven't mentioned, I will assume that it's a fixed-format file -

Code:

$
$
$ cat f0
NAME1     NAME2     ADDRESS   TEL
name001   name002   addr001   tel001
name011   name022   addr011   tel011
name111   name222   addr111   tel111
$
$
$ awk 'NR==1{printf("%-10s%-10s%-10s%-10s%-10s%-s\n","ID",$1,$2,"EMAIL",$3,$4)}
       NR>1 {printf("%-10s%-10s%-10s%-10s%-10s%-s\n"," ",$1,$2," ",$3,$4)}
      ' f0
ID        NAME1     NAME2     EMAIL     ADDRESS   TEL
          name001   name002             addr001   tel001
          name011   name022             addr011   tel011
          name111   name222             addr111   tel111
$
$
$

tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Tab Completion showing files that Dont Exist

Has anyone seen this before? if i ls a particular directory (an email Maildir) i get a long list of files, if i 'du -h' that same directory, i get messages like: du: `./1053894791.17207_0.srweb,S=6199': No such file or directory strange. so using tab will complete this filename too, giving...

2. Shell Programming and Scripting

How to extract visually blank lines form the file

Hi, Could some one help me to get rid of visually blank lines from a file using shell or awk or sed (on Solaris machine)? When I use grep grep -v ^$ inputfile >outputfile it removes some blank lines.. but it seems some tab plus space balnk lines remains. thaen I used "grep -v '^]*$' ...

3. Shell Programming and Scripting

Removing blank columns from a file

Hi, I have a sample file as shown below -- id parent name dba -----------------------------------...

4. Shell Programming and Scripting

ls | grep (i dont know what to put here)

Dear users, I googled for a while, but i have got a lot of different answers regarding a simple unix command. lets say there are a lot of files in a directory. How can i list the files in a directory whose file types is "text"? Thank you in advance

5. UNIX for Dummies Questions & Answers

Rsync copy files if dont exist

I have a setup where I have two drives. TV TVbackup For what ever reason, I have a lot of content on my TVbackup drive which isn't on my TV drive. I want to copy all the files across which are on TVbackup but are not currently on TV. If there is a file with the same name but a...

6. Shell Programming and Scripting

How to sort a text file if certain columns are blank?

Dear all, I am trying to sort a text file based on column 3, 10, 11 and 12. But certain column are blank for some lines. Column 3 has to be in ascending order after sorting. Part of my input file is as follows: CN727990 1 A01 4703 5083 73.28 - A_scaffold000011 4365605 4365985 73.28 +...

7. Shell Programming and Scripting

Inserting blank columns in already present CSV file

Hi, i have a csv file which have headers and values of it like below : headers --> CI Ref SerialNumber LastScanDate values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000 i want to have a above csv in below format : headers --> CI Name CI Description CI Ref...

8. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples...

9. Shell Programming and Scripting

Script to find blank records in a file except for few columns

I have a file with the following format: X|High|2|GIC|DM||XHM|||6 Months X|Moderate|2|GIC|DM||XHM|||6 Months X|High|2|GCM|DM||XSF|||6 Months X|Med|2|GCM|DM||XSF|||6 Here there are ten columns but I need to print rows having blank records in any of the rows (except for 6th,8th and 9th...

10. Shell Programming and Scripting

Extract data from a log file and put it in a file

Hi, I would like to seek your help for a script that will extract data from log file and put it in a file. Sample log file 2018-10-23 12:33:21 AI ERROR -- tpid: SAMPLE_TH account: 123456789 aiSessionNumber: 660640464 mapName: xxx to yyy errorDesc: Translation Error:ErrorNumber : 993 ...

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Tab Completion showing files that Dont Exist

Discussion started by: dittonamed

2. Shell Programming and Scripting

How to extract visually blank lines form the file

Discussion started by: hadsuresh

3. Shell Programming and Scripting

Removing blank columns from a file

Discussion started by: sumirmehta

4. Shell Programming and Scripting

ls | grep (i dont know what to put here)

Discussion started by: kevincobain2000

5. UNIX for Dummies Questions & Answers

Rsync copy files if dont exist

Discussion started by: Spadez

6. Shell Programming and Scripting

How to sort a text file if certain columns are blank?

Discussion started by: huiyee1

7. Shell Programming and Scripting

Inserting blank columns in already present CSV file

Discussion started by: omkar.jadhav

8. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Discussion started by: LMHmedchem

9. Shell Programming and Scripting

Script to find blank records in a file except for few columns

Discussion started by: chatwithsaurav

10. Shell Programming and Scripting

Extract data from a log file and put it in a file

Discussion started by: neverwinter112