Apply condition on fixed width file and filter records Post: 302534279

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters. awk '{printf "%-100s\n",$0}' infile > outfile However, there are some records with a special character "�" These records are using 3 characters in place of one and my record...

2. Shell Programming and Scripting

Extracting records with unique fields from a fixed width txt file

Greetings, I would like to extract records from a fixed width text file that have unique field elements. Data is structured like this: John A Smith NY Mary C Jones WA Adam J Clark PA Mary Jones WA Fieldname / start-end position Firstname 1-10...

3. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated. I...

4. Shell Programming and Scripting

Fixed-Width file from Oracle

Hi All, I have created a script which generates FIXED-WIDTH file by executing Oracle query. SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe...

5. Shell Programming and Scripting

Manupulating Records in a fixed width file

I am trying to determine what would be a fast and simple way to manipulate data that comes in a fixed width format. This data has 6 segments within a record. Each record needs to written out with a header and the 6 segments. Based on the value in column #6 the fields will be defined accordingly....

6. Shell Programming and Scripting

Comparing two fixed width file

Hi Guys I am checking the treads to get the answer but i am not able to get the answer for my question. I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2. File1: P2797f12af 44751228...

7. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on...

8. Shell Programming and Scripting

Alter Fixed Width File

Thank u so much .Its working fine as expected. ---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ---------- I need one more help. I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to...

9. Shell Programming and Scripting

UNIX command -Filter rows in fixed width file based on column values

Hi All, I am trying to select the rows in a fixed width file based on values in the columns. I want to select only the rows if column position 3-4 has the value AB I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that...

10. Shell Programming and Scripting

Filter duplicate records from csv file with condition on one column

I have csv file with 30, 40 columns Pasting just three column for problem description I want to filter record if column 1 matches CN or DN then, check for values in column 2 if column contain 1235, 1235 then in column 3 values must be sequence of 2345, 2345 and if column 2 contains 6789, 6789...

LEARN ABOUT CENTOS

tcfmttest

TCFMTTEST(1)							   Tokyo Cabinet						      TCFMTTEST(1)

NAME

       tcfmttest - test cases of the fixed-length database API

DESCRIPTION

       The command `tcfmttest' is a utility for facility test under multi-thread situation.  This command is used in the following format.  `path'
       specifies the path of a database file.  `tnum' specifies the number of  running	threads.   `rnum'  specifies  the  number  of  iterations.
       `width' specifies the width of the value of each record.  `limsiz' specifies the limit size of the database file.

	      tcfmttest write [-nl|-nb] [-rnd] path tnum rnum [width [limsiz]]
		     Store records with keys of 8 bytes.  They change as `00000001', `00000002'...
	      tcfmttest read [-nl|-nb] [-wb] [-rnd] path tnum
		     Retrieve all records of the database above.
	      tcfmttest remove [-nl|-nb] [-rnd] path tnum
		     Remove all records of the database above.
	      tcfmttest wicked [-nl|-nb] [-nc] path tnum rnum
		     Perform updating operations selected at random.
	      tcfmttest typical [-nl|-nb] [-nc] [-rr num] path tnum rnum [width [limsiz]]
		     Perform typical operations selected at random.

       Options feature the following.

	      -nl : enable the option `FDBNOLCK'.
	      -nb : enable the option `FDBLCKNB'.
	      -rnd : select keys at random.
	      -wb : use the function `tcfdbget4' instead of `tcfdbget2'.
	      -nc : omit the comparison test.
	      -rr num : specifiy the ratio of reading operation by percentage.

       This command returns 0 on success, another on failure.

SEE ALSO

       tcftest(1), tcfmgr(1), tcfdb(3), tokyocabinet(3)

Man Page							    2012-08-18							      TCFMTTEST(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

Discussion started by: alok.benjwal

2. Shell Programming and Scripting

Extracting records with unique fields from a fixed width txt file

Discussion started by: sitney

3. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

Discussion started by: sate911

4. Shell Programming and Scripting

Fixed-Width file from Oracle

Discussion started by: Amit.Sagpariya