Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Highlighting specific column in cat/grep

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Highlighting specific column in cat/grep
# 1  
Old 04-02-2015
Highlighting specific column in cat/grep
I have a large * delimited text file and need to highlight specific columns on specific lines. The file looks similar to this:

Code:
ABC*01*00*01*00000 000000    *00000  000000    *35*0*0*0*0*20000*0*0*1*0000*00*4*0*3*0*0*1*0*  *35*0000*001*4*1OT2*0148*0*0*0*0*0*0*6A7801B0**TEST1
ABC*02*00*01*00000 000000 000000 000000    *00000 000000     *35*0*0*0*0*0*0*0*1*0010*00*4*0*0*0*0*1*0*  *35*0000*001*4*1OR2*0148*0*0*0*0*0*0*6A7701B0**TEST2

Is there any way of highlighting a specific column, so, for example, I get this:
Code:
ABC*01*00*01*00000 000000    *00000  000000     *35*0*0*0*0*20000*0*0*1*0000*00*4*0*3*0*0*1*0*   *35*0000*001*4*1OT2*0148*0*0*0*0*0*0*6A7801B0**TEST1
ABC*02*00*01*00000 000000 000000 000000    *00000 000000      *35*0*0*0*0*0*0*0*1*0010*00*4*0*0*0*0*1*0*   *35*0000*001*4*1OR2*0148*0*0*0*0*0*0*6A7701B0**TEST2

Unfortunately the values may be different, so I can't use egrep --color, or, the value may occur more than one in the line - eg one of the 0's.

Thanks in advance
# 2  
Old 04-02-2015
Please be aware that color etc. are terminal attributes visible only if printed to the screen and if the terminal/emulator supports them. They can spoil the data in the text file. Try
Code:
awk -F\* '{$COL="\033[31;1m" $COL "\033[0m"} 1' OFS=\* COL=30 file

(c.f. man console_codes)
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can grep a specific column?

Hello All I have an input file with data below. I would like to grep and display the data where 3rd column contains string or at least one character. Kindly please help me with this! Input: tjfa3|zznpou|224fdd.34.ff3.35 |Tiv|Otj|1 fgduul7|zznikj| ... (7 Replies)
Discussion started by: DoveLu
7 Replies

2. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

3. Shell Programming and Scripting

Grep on a value in a specific column

I need to grep all records from a file that has 1072 in 3rd column. 1072 can be prefixed by "SBC.", "CLS." or "DPT.". My search is just based on string 1072 in 3rd column. Delimiter in the file is tab. For example: Input FIle: "InvType" "Organization" "SBC.10720101" "CP.BUP.NY" "InvType"... (4 Replies)
Discussion started by: yale_work
4 Replies

4. Shell Programming and Scripting

How to grep an empty line in a specific column of a file?

Suppose i have the following data : cat file.txt 12431,123334,55353,546646,14342234,4646,35234 123123,3535,123434,132535,1234134,13535,123534 123213,545465,23434,45646,2342345,4656,31243 2355425,2134324,53425,342,35235,23434,234535 3423424,234234,65465,,2344,35436,234524,234... (7 Replies)
Discussion started by: Ravi Tej
7 Replies

5. Shell Programming and Scripting

Grep only specific lines ordered by column/date

Hi everybody, I'd like to think I've been through the search tool not only on this site, but also on google too, but I haven't been able to find what I was looking for. If I might've missed something on this forum, please slap me in the face with a link that you consider useful for my query :D ... (4 Replies)
Discussion started by: dilibau
4 Replies

6. UNIX for Dummies Questions & Answers

Grep from specific column in one file based on another file [Please help!]

Hey Guys, to keep it simple, I have an idFile: 1006006 1006008 1006011 1007002 ...... and famFile: 1006 1006001 1006016 1006017 1 1006 1006006 1006016 1006017 1 1006 1006007 0 0 2 1006 1006008 1006007 1006006 2 1006 1006010 1006016 1006017 2 1006 1006011 1006016 1006017 1 1006... (2 Replies)
Discussion started by: Zoho
2 Replies

7. Shell Programming and Scripting

grep and cat based on specific mod date

I'm trying to figure out how to open and copy all contents of files last modded on aug 14 to one single text file. Also, I'm trying to do this in one command string. I have ls -l -R | grep "Aug 1" but all this does is print the -l info with Aug 1 in it. how can I modify this so that ls... (3 Replies)
Discussion started by: mmixology
3 Replies

8. UNIX for Dummies Questions & Answers

color highlighting with 'more','grep' and 'vi'

Hi all, i would to find out how can i turn on color hightlighting with the 'more' command. When i view a big file, i tend to use the 'more' command and i would search for a interested string with the '/' command. Something the search returns more than 1 line found on the screen, how can i... (0 Replies)
Discussion started by: new2ss
0 Replies

9. UNIX for Dummies Questions & Answers

grep/cat/more -- search in a txt file and display content from a specific "keyword"

Hi, I have a .txt file Sample: ===================== NEXT HOST ===================== AEADBAS001 ip access-list extended BLA_Incoming_Filter ip access-list extended BLA_Outgoing_Filter access-list 1 permit xxxxxxxxxxxxxx access-list 2 permit xxxxxxxxxxxxxx =====================... (4 Replies)
Discussion started by: I-1
4 Replies
Login or Register to Ask a Question