Sponsored Content
Full Discussion: Replace 4th field if null
Top Forums Shell Programming and Scripting Replace 4th field if null Post 302340378 by zaxxon on Monday 3rd of August 2009 09:37:13 AM
Old 08-03-2009
Also read my note in your post up there please.

Code:
awk -F"|" '$5 == "" {$5="NA"; print; next} {print}' OFS="|" infile
|A|21|B1|NA|1.1|
|A|21|B1|www.none.com|1.1|
|A|21|B1|NA|1.1|
|A|21|B1|www.trail.com|1.1|

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep for NULL for a specific field in a unix file

hii.. I have a pipe delimited file For ex: TEST_1-8J6TZN|ASLANK|BHR-09||TRAM I want to grep for NULL in the 4th field only from the above file Please suggest Also let me know if there is any limitation in the suggested command Thanks all in advance..!! (5 Replies)
Discussion started by: sureshg_sampat
5 Replies

2. AIX

display file where 4th field = 200704

Hello I have a file which is pipe delimited. The 4 th field has value like 200704 or 200705 etc. Now i have to get only those records where 4th field is 200704 How can i do this? I have to get the whole record where 4th field = 200704 (4 Replies)
Discussion started by: vasuarjula
4 Replies

3. Shell Programming and Scripting

display file where 4th field = 200704

Hello I have a file which is pipe delimited. The 4 th field has value like 200704 or 200705 etc. Now i have to get only those records where 4th field is 200704 How can i do this? I have to get the whole record where 4th field = 200704 (7 Replies)
Discussion started by: vasuarjula
7 Replies

4. Shell Programming and Scripting

awk Problem while insert null field to file

Dear All, I have the following input file. I want to replace data with null values. I/P File: 9022334455|2008-12-06 06:10:21|2|Error@@@|esoo8erp| 9024334432|2008-12-06 08:40:59|6|Error@@@|6y2o8e6r| O/P File: 9022334455||2||esoo8erp| 9024334432||6||6y2o8e6r| ... (4 Replies)
Discussion started by: hanu_oracle
4 Replies

5. Shell Programming and Scripting

How to replace all after 4th character in line ?

How to replace all after 4 character at line? & convert to upper case ? google.com -> GOOG (2 Replies)
Discussion started by: Trump
2 Replies

6. Shell Programming and Scripting

Replace 0's with NULL

Hi all, Need a small help I am in lookout for a command that changes 0's to NULL in my file, The content will look like 1139,223108,R,2009,0,854,854,854,732,854,854,854,854,854 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,... (3 Replies)
Discussion started by: Sri3001
3 Replies

7. Shell Programming and Scripting

perl script to split the text file after every 4th field

I had a text file(comma seperated values) which contains as below 196237,ram,25-May-06,ram.kiran@xyz.com,204183,Pavan,4-Jun-07,Pavan.Desai@xyz.com,237107,ram Chandra,15-Mar-10,ram.krishna@xyz.com ... (3 Replies)
Discussion started by: giridhar276
3 Replies

8. Shell Programming and Scripting

How to extract 4th field if numerics?

I have a file which contains fields comma separated & with each field surrounded by quotes. The 4th field contains either a serial number, the text ABC, the text XYZ or it's blank. I want to only extract records which have a serial number. Here's some sample data: > cat myfile... (4 Replies)
Discussion started by: CHoggarth
4 Replies

9. Shell Programming and Scripting

Replace a field where values are null in a file.

Hi, I've a pipe delimited file and wanted to replace the 3rd field to 099990 where the values are null. How can I achieve it using awk or sed. 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S... (12 Replies)
Discussion started by: rudoraj
12 Replies

10. Shell Programming and Scripting

To find char field and replace null

hi, i having a file with | seperated in which i need to search char in 3rd column and replace with null. i need to replace only the coulmn where character occurs in 3rd field for eg: file1.txt xx|yy|xx|12 output file: xx|yy||12 (5 Replies)
Discussion started by: rohit_shinez
5 Replies
cmddump(1)						      General Commands Manual							cmddump(1)

Name
       cmddump - simulated TRS-80 CMD file loader

Syntax
       cmddump [flags] infile [outfile startbyte nbytes]

Description
       cmddump	displays  information about TRS-80 DOS binary (command) files.	It takes an optional set of flags (described below), an input /cmd
       file, and an optional outfile, an optional starting offset of startbyte into the /cmd file, and an optional nbytes number of bytes to dump.
       Non-flag  arguments  must  be given in the order shown.	If the optional arguments are given, the given byte range is dumped from the simu-
       lated memory after loading.

Options
       -d     print detailed map; same as -m, but don't coalesce

       -i n   select ISAM entry n (0x notation OK)

       -m     print running load map as file is parsed, coalescing adjacent blocks (implies -t) (default)

       -p foo select PDS entry foo (padded to 8 bytes with spaces)

       -q     quiet; turns off -t, -m, -d, -s (later flags can override)

       -s     print summary load map after file is parsed

       -t     print text of module headers, pds headers, patch names, and copyright notices

       -x     ignore anything after the first transfer address

Author
       cmddump was written by Timothy Mann.  This man page was generated by Branden Robinson from comments in the source code.

See also
       xtrs(1)

       See the LDOS Quarterly, April 1, 1982 (Vol 1, No 4), for documentation of the TRS-80 DOS /cmd file format.  It is available on the  Web	at
       http://www.tim-mann.org/misosys.html.

								    2001-02-22								cmddump(1)
All times are GMT -4. The time now is 09:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy