Left pad spaces using awk or sed Post: 302741793

Sponsored Content

Top Forums Shell Programming and Scripting Left pad spaces using awk or sed Post 302741793 by Soujanya_K on Monday 10th of December 2012 01:23:34 AM

12-10-2012

Registered User

Left pad spaces using awk or sed

Hi,I've a unix pipe delimited file as below

Code:

f1|f2|f3|f4|f5|f6

My requirement is to pad spaces on the left to fields f2, f3 and f5. Field Lengths according to file layout f2 - 4 char f3 - 5 char f5 - 3 char If my record is as below

Code:

1|43|bc|h0|34|a

Output record should be as below

Code:

1|  43|   bc|h0| 34|a

Kindly provide a solution using awk or sed. Appreciate help! Regards,Soujanya

Last edited by Scrutinizer; 12-10-2012 at 12:34 PM.. Reason: code tags

Soujanya_K

View Public Profile for Soujanya_K

Find all posts by Soujanya_K

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pad spaces

Hello, I have to write a function to input a Label and a number, and output a line as the following format: Column 1 to 30: field label, left justified. Column 31 to 45: A number, right justified. The middle is padded with space. May I know how can I achieve this? (I don't know how to count...

2. Shell Programming and Scripting

Left join on files using awk

nawk 'NR==FNR{a;next} {if($1 in a) print $1,"Found" else print}' OFS="," File_B File_A The above code is not working help is appreciated

3. Shell Programming and Scripting

Fixed Width Join & Pad Sed/Awk Help

I was wondering someone might be able to push me in the right direction, I am writing a script to modify fixed-width spool files, As you can see below the original spool file broke a single line into two for printability sake. I have had been able do the joins using sed, the thing I am...

4. Linux

sed couldn't flush stdout no space left on device

I am running Oracle Linux enterprise server 5.0. I just installed JDE 9.0 and after I started Webserver my root directory is 100% full. Can some one help me flush stdout. I am new to linux. Sam

5. Shell Programming and Scripting

How to remove spaces using awk,sed,perl?

Input: 3456 565 656 878 235 8 4 8787 3 7 35 878 Expected output: 3456 565 656 878 235 8 4 8787 3 7 35 878 How can i do this with awk,sed and perl?

6. Shell Programming and Scripting

How to delete ending/trailing spaces using awk,sed,perl?

How to delete ending/trailing spaces using awk,sed,perl? Input:(each line has extra spaces at the end) 3456 565 3 7 35 878 Expected output: 3456 565 3 7 35 878

7. Shell Programming and Scripting

Unix Cut or Awk from 'Right TO Left'

Hello, I want to get the User Name details of a user from a file list. This list can be in the format: FirstName_MiddleName1_LastName_ID FirstName_LastName_ID FirstName_MiddleName1_MiddleName2_LastName_ID What i want it to return is FirstName_MiddleName1_LastName of a user. I...

8. Shell Programming and Scripting

left join using awk

Hi guys, I need to use awk to join 2 files file_1 A 001 B 002 C 003 file_2 A XX1 B XX2 output desired A 001 XX1 B 002 missing C 003 XX2 thank you!

9. Shell Programming and Scripting

left join using awk

Hi guys, I need AWK to merge the following 2 files: file1 1 a 1 1 2 b 2 2 3 c 3 3 4 d 4 4 file2 a a/a c/c a/c c/c a/a c/t c c/t c/c a/t g/g c/c c/t desired output: 1 a 1 1 a/a c/c a/c c/c a/a c/t 2 b 2 2 x x x x x x 3 c 3 3 c/t c/c a/t g/g c/c c/t 4 d 4 4 x x x x x x

10. Shell Programming and Scripting

awk pad 1 column with leading zero if char > 12

Hello, I got a question. I have several csv files with lots of data in it and for the first column i have EAN codes. The problem that i am facing is that some of these codes have the leading 0 removed so they are 12 or less chars while a EAN code is (always?) 13 chars. For this i used a...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pad spaces

Discussion started by: sarahho

2. Shell Programming and Scripting

Left join on files using awk

Discussion started by: pinnacle

3. Shell Programming and Scripting

Fixed Width Join & Pad Sed/Awk Help

Discussion started by: Cho Nagurai

4. Linux

sed couldn't flush stdout no space left on device

Discussion started by: s1a2m3

5. Shell Programming and Scripting

How to remove spaces using awk,sed,perl?

Discussion started by: cola

6. Shell Programming and Scripting

How to delete ending/trailing spaces using awk,sed,perl?

Discussion started by: cola

7. Shell Programming and Scripting

Unix Cut or Awk from 'Right TO Left'

Discussion started by: limamichelle

8. Shell Programming and Scripting

left join using awk

Discussion started by: g1org1o

9. Shell Programming and Scripting

left join using awk

Discussion started by: g1org1o

10. Shell Programming and Scripting

awk pad 1 column with leading zero if char > 12

Discussion started by: SDohmen