Sponsored Content
Top Forums Shell Programming and Scripting Compare Hex Value from CSV File Post 302756669 by Yoda on Wednesday 16th of January 2013 09:10:15 AM
Old 01-16-2013
Using gawk, pass hex as argument:
Code:
hex=$1
gawk -F',' --non-decimal-data -v H=$hex ' {
     H3=$3;
     if(H==H3) { print $0; f=1; }
     if((H<H3)&&(f!=1)) { print $0; exit 1; }
}' filename


Last edited by Yoda; 01-16-2013 at 10:28 AM.. Reason: Removed sprintf
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare date in a csv file

Hi all, how can I compare two defferent lines in a csv file, with the date values, and print the latest date! example: cat test.csv test1;whatever;Wed Nov 26 14:17:48 CET 2008 test1;whatever;Wed Nov 26 17:14:06 CET 2008 Any suggession? (4 Replies)
Discussion started by: research3
4 Replies

2. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies

3. Shell Programming and Scripting

Read Two lines in a CSV File and Compare

Hi , I have a CSV file ( file.csv) with some data as below: A,1,abc,x,y,z,,xyz,20100101,99991231 A,1,abc,x,y,z,234,xyz,20100101,99991231 I have to delete the duplicate line based on unique identifiers which are values in the fields- 2,3,4,8.These coulmns in both the rows have same... (6 Replies)
Discussion started by: Sheel
6 Replies

4. UNIX for Dummies Questions & Answers

Hex value search in a csv

I have looked at other posts on this and cannot get what I need, I have a csv file (UTF -8) that has corrupt data in: "p.fażżżż","ażżża","","","","" The hex value for the upside down ? is a C2BF How can I search a csv file for this hex value C2BF Any help would be appreciated ... (2 Replies)
Discussion started by: Pablo_beezo
2 Replies

5. Shell Programming and Scripting

awk to compare hex number

$ awk 'BEGIN{ pat111=0x1000000002E3E02; snBegin=0x1000000002E3E01; if (pat111<=snBegin) printf "a\n"}' a Result is not correct. Looks like the number is too big. Any idea? Thx! Please use code tags <- click the link! (2 Replies)
Discussion started by: carloszhang
2 Replies

6. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

7. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

8. Shell Programming and Scripting

How to compare two lines in a csv file using shell script?

I have a file lets say input.csv having two columns like- Name,Mobile No A,111 B,222 A,333 A,123 B,213 I would like to find result in a new file lets say output.csv as- Name,Mobile No A,111 B,222 means short the file on the basis of first column and first value corresponding to the... (5 Replies)
Discussion started by: Ashish Singhal
5 Replies

9. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

10. UNIX for Beginners Questions & Answers

Compare every column from one csv file to another csv file

1.csv contains following column- Empid code loc port 101 A xy 01 102 B zx 78 103 A cg 12 104 G xy 78 2.csv contains follwing data- Empid code loc port 101 A gf 01 102 B zx 78 103 C cg 32 104 ... (1 Reply)
Discussion started by: rishabh
1 Replies
RAX2(1) 						    BSD General Commands Manual 						   RAX2(1)

NAME
rax2 -- radare base converter SYNOPSIS
rax2 [-ebsSvxkh] [[value] ...] DESCRIPTION
This command is part of the radare project. This command allows you to convert values between positive and negative integer, float octal, binary and hexadecimal values. OPTIONS
-e Swap endian. -b Convert from binary string to caracter (rax2 -b 01000101) -s Convert from hex string to caracter (rax2 -s 43 4a 50) -S Convert from hex string to caracter (rax2 -S C J P) -v Show program version -x Convert a string into a hash -k Keep de same base as the input data -h Show usage help message USAGE
Available variable types are: int -> hex rax2 10 hex -> int rax2 0xa -int -> hex rax2 -77 -hex -> int rax2 0xffffffb3 int -> bin rax2 b30 bin -> int rax2 1010d float -> hex rax2 3.33f hex -> float rax2 Fx40551ed8 oct -> hex rax2 35o hex -> oct rax2 Ox12 (O is a letter) bin -> hex rax2 1100011b hex -> bin rax2 Bx63 With no arguments, rax2 reads values from stdin. You can pass one or more values as arguments. $ rax2 33 0x41 0101b 0x21 65 0x5 You can do 'unpack' hexpair encoded strings easily. $ rax2 -s 41 42 43 ABC And it supports some math operations. $ rax2 0x5*101b+5 30 It is very useful tool for scripting, so you can read floating point values, or get the integer offset of a jump or a stack delta when ana- lyzing programs. SEE ALSO
radare2(1), rahash2(1), rafind2(1), rabin2(1), ranal2(1), radiff2(1), ragg2(1), rarun2(1), rasm2(1), AUTHORS
pancake <pancake@nopcode.org>, nibble <nibble@develsec.org> BSD
Mar 12, 2010 BSD
All times are GMT -4. The time now is 12:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy