Remove new line character and add space to convert into fixed width file Post: 302753155

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

Source File: abcdefghijklmnop01qrstuvwxyz abcdefghijklmnop02qrstuvwxyz abcdefghijklmnop03qrstuvwxyz abcdefghijklmnop04qrstuvwxyz abcdefghijklmnop05qrstuvwxyz Whatever characters are in 17-18 on each line of the file, it should be concatenated to the same line at the character number...

2. UNIX for Dummies Questions & Answers

Remove duplicates based on a column in fixed width file

Hi, How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters. The file is a fixed width file. ex of Record: DTYU12333567opert tjhi kkklTRG9012 The data in bold is the key on which...

3. HP-UX

How to remove new line character and append new line character in a file?

Hi Experts, I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line. File is comma (,) seperated. Eg: ID,Client ,SNo,Rank 37,Airtel \n...

4. UNIX for Dummies Questions & Answers

convert # delimited text file to fixed width

Hello gurus, I have a file containing 5 columns delimited by '#' as shown in the example below: HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA# 99991231#AU7129#000000000#1 PROCTER & GAMBLE# 99991231#TT4283#1000013883#21111 LAUNDRY# 99991231#TT4283#1000013884#21121 DISH...

5. UNIX for Dummies Questions & Answers

Replace the unexpected newline char with space in a Fixed width file

Input eg: Ouput Expected. The #rd line had the unexpted new line, which need to be replaced with space. I was planing to go with checking the length of each line using awk and if the length is less than the defeined limit, (12 in above case) will replace the newline with space. ...

6. Shell Programming and Scripting

How to add a character after the first word/space on each line?

Hi:) I have a large file ( couple thousand lines ) and I'm trying to add a character after the first word/space on each line. eg: First line of text Second line of text Third line of text Fourth line of text Fifth line of text I'd like to accomplish: First - line of text Second...

7. UNIX for Beginners Questions & Answers

How do I remove leading spaces in UNIX when count of space character is not fixed? Example below-

Script showStreamsGLIS$reg.$env.ksh gives me output as below- Job Stime Etime Status ExitCode GLIS-AS-S-EFL-LOCK-B ----- ----- OI 103313880/0 GLIS-ALL-Q-EOD-FX-UPDT-1730-B ----- ----- TE 0/0 GLIS-TK-S-BWSOD-B ...

8. Shell Programming and Scripting

awk issue splitting a fixed-width file containing line feed in data

Hi Forum. I have the following script that splits a large fixed-width file into smaller multiple fixed-width files based on input segment type. The main command in the script is: awk -v search_col_pos=$search_col_pos -v search_str_len=$search_str_len -v segment_type="$segment_type"...

9. UNIX for Beginners Questions & Answers

Convert a fixed width file to a delimited file

Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ?

LEARN ABOUT DEBIAN

tcfmgr

TCFMGR(1)							   Tokyo Cabinet							 TCFMGR(1)

NAME

       tcfmgr - the command line utility of the fixed-length database API

DESCRIPTION

       The  command `tcfmgr' is a utility for test and debugging of the fixed-length database API and its applications.  `path' specifies the path
       of a database file.  `width' specifies the width of the value of each record.  `limsiz' specifies the limit  size  of  the  database  file.
       `key' specifies the key of a record.  `value' specifies the value of a record.  `file' specifies the input file.

	      tcfmgr create path [width [limsiz]]
		     Create a database file.
	      tcfmgr inform [-nl|-nb] path
		     Print miscellaneous information to the standard output.
	      tcfmgr put [-nl|-nb] [-sx] [-dk|-dc|-dai|-dad] path key value
		     Store a record.
	      tcfmgr out [-nl|-nb] [-sx] path key
		     Remove a record.
	      tcfmgr get [-nl|-nb] [-sx] [-px] [-pz] path key
		     Print the value of a record.
	      tcfmgr list [-nl|-nb] [-m num] [-pv] [-px] [-rb lkey ukey] [-ri str] path
		     Print keys of all records, separated by line feeds.
	      tcfmgr optimize [-nl|-nb] path [width [limsiz]]
		     Optimize a database file.
	      tcfmgr importtsv [-nl|-nb] [-sc] path [file]
		     Store records of TSV in each line of a file.
	      tcfmgr version
		     Print the version information of Tokyo Cabinet.

       Options feature the following.

	      -nl : enable the option `FDBNOLCK'.
	      -nb : enable the option `FDBLCKNB'.
	      -sx : the input data is evaluated as a hexadecimal data string.
	      -dk : use the function `tcfdbputkeep' instead of `tcfdbput'.
	      -dc : use the function `tcfdbputcat' instead of `tcfdbput'.
	      -dai : use the function `tcfdbaddint' instead of `tcfdbput'.
	      -dad : use the function `tcfdbadddouble' instead of `tcfdbput'.
	      -px : the output data is converted into a hexadecimal data string.
	      -pz : do not append line feed at the end of the output.
	      -m num : specify the maximum number of the output.
	      -pv : print values of records also.
	      -rb lkey ukey : specify the range of keys.
	      -ri str : specify the interval notation of keys.
	      -sc : normalize keys as lower cases.

       This command returns 0 on success, another on failure.

SEE ALSO

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

Man Page							    2011-02-12								 TCFMGR(1)