File formating Post: 302992880

Sponsored Content

Top Forums Shell Programming and Scripting File formating Post 302992880 by Scrutinizer on Thursday 2nd of March 2017 11:33:11 PM

03-03-2017

Moderator

To help you get on your way, try:

Code:

echo 'a|b|c|d|e|f' |awk 'BEGIN {FS = "|";column_length[0]=6;column_length[1]=3;column_length[2]=2;column_length[3]=3;column_length[4]=4;column_length[5]=5}
{for(i=1;i<=NF;i++) printf("| %-" column_length[i-1] "s",$i); printf("|\n")}'

Code:

| a     | b  | c | d  | e   | f    |

--
Note: instead of

Code:

printf("| %-" column_length[i-1] "s",$i)

,you can also use:

Code:

printf("| %-*s", column_length[i-1],$i)

Last edited by Scrutinizer; 03-03-2017 at 12:40 AM..

This User Gave Thanks to Scrutinizer For This Post:

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help required on file formating

I have two files file1 and file2 as shown below: file1: name nameabc bcd nameabcdefg file2: age age1111 age2345 age6743 I have pasted one file on the other with the delimiter "|" and the resulttant file is: name|age nameabc|age1111 bcd|age2345 nameabcdefg|age6743

2. Shell Programming and Scripting

File formating question.

Hi, I have a file with only data 1 row: AA#?BB#?CC#?DD Assume '#?' is the delimiter, i want the output in another file to be: AA BB CC DD Pls let me know if this is possible by sed ? Thanks in advance.

3. Shell Programming and Scripting

file formating in Perl

Hi, I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement .. My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need...

4. UNIX for Dummies Questions & Answers

File formating help needed.

I have a file called vm.cfg . content of file. acpi = 1 apic = 1 builder = 'hvm' How would i write a script which will add boot = 'd' at 3rd line. For example. after running the script the file should be like below. acpi = 1 apic = 1 boot = 'd' builder = 'hvm' I dont want to...

5. Shell Programming and Scripting

File formating (sed command)

I am new ot unix. Is there one or two lines of command (sed may be) to format a file. My source is.. <tag1> <tag2> <datatag1> data1 </datatag1> <datatag2> data2 </datatag2> <datatag3> data3 </datatag3> <datatag4> data1 </datatag3> </tag2> </tag1>

6. Shell Programming and Scripting

Help in formating a txt file

Pls help in formatting a txt file using shell scripting Input file format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Output required: name priya hi how r u

7. Shell Programming and Scripting

Help in formating a file with field separator

hi thanks a lot But pls help me if my input file is the below format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Name2 priya2 2010-09-21 10:43:49 TEXT ID 1 hi1 TEXT ID 2 how1 TEXT ID 3 r1

8. UNIX for Beginners Questions & Answers

File formating with lines

Hi All, Need to modify a file basically join the extra line to one I am having a file like below And would like to make it as below .

9. UNIX for Beginners Questions & Answers

File formating help

Hi all, I am having the file below I need that as below Thanks, Arun

10. Shell Programming and Scripting

Help with ... Formating the file using awk

I have a file like below position1 0 7802 7802 0 client1 - - position1 8 8032 8032 0 client1 ...

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help required on file formating

Discussion started by: udiptya

2. Shell Programming and Scripting

File formating question.

Discussion started by: smc3

3. Shell Programming and Scripting

file formating in Perl

Discussion started by: julirani

4. UNIX for Dummies Questions & Answers

File formating help needed.

Discussion started by: pinga123

5. Shell Programming and Scripting

File formating (sed command)

Discussion started by: reachsam11

6. Shell Programming and Scripting

Help in formating a txt file

Discussion started by: bha148

7. Shell Programming and Scripting

Help in formating a file with field separator

Discussion started by: bha148

8. UNIX for Beginners Questions & Answers

File formating with lines

Discussion started by: arunkumar_mca

9. UNIX for Beginners Questions & Answers

File formating help

Discussion started by: arunkumar_mca

10. Shell Programming and Scripting

Help with ... Formating the file using awk

Discussion started by: manas_ranjan