Converting a Delimited File to Fixed width file Post: 302120447

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!!

2. UNIX for Advanced & Expert Users

Converting field into fixed width csv

Hi I have a file having record as - 1,aaa,a123,a I need this converted to as 2nd col to 5 chars wide & 3rd col to 6chars wide such as - 1,aaa ,a123 ,a How we could achieve this? Thx in advance.

3. UNIX for Dummies Questions & Answers

Converting Space delimited file to Tab delimited file

Hi all, I have a file with single white space delimited values, I want to convert them to a tab delimited file. I tried sed, tr ... but nothing is working. Thanks, Rajeevan D

4. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12...

5. Shell Programming and Scripting

converting fixed length file to delimited file

hi , i need to convert fixed length file to delimited file using unix where length of each column is variable

6. UNIX for Dummies Questions & Answers

cleaning up spaces from fixed width file while converting to csv file

Open to a sed/awk/or perl alternative so that i can stick command into my bash script. This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all...

7. UNIX for Dummies Questions & Answers

Delete header row and reformat from tab delimited to fixed width

Hello gurus, I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:...

8. 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...

9. Red Hat

Converting fixed width file to pipe delimiter in Linux(red-hat)

Hi, I am facing a typical scenario for AWK command . In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result. The below code is for convert the fixed width file to pipe delimiter file in HP-unix server. awk code: #!/bin/awk -f NR!=1...

10. 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 CENTOS

tcftest

TCFTEST(1)							   Tokyo Cabinet							TCFTEST(1)

NAME

       tcftest - test cases of the fixed-length database API

DESCRIPTION

       The command `tcftest' is a utility for facility test and performance test.  This command is used in the following format.  `path' specifies
       the path of a database file.  `rnum' specifies the number of iterations.  `width' specifies the width of the value of each  record.   `lim-
       siz' specifies the limit size of the database file.

	      tcftest write [-mt] [-nl|-nb] [-rnd] path rnum [width [limsiz]]
		     Store records with keys of 8 bytes.  They change as `00000001', `00000002'...
	      tcftest read [-mt] [-nl|-nb] [-wb] [-rnd] path
		     Retrieve all records of the database above.
	      tcftest remove [-mt] [-nl|-nb] [-rnd] path
		     Remove all records of the database above.
	      tcftest rcat [-mt] [-nl|-nb] [-pn num] [-dai|-dad|-rl] path rnum [limsiz]]
		     Store records with partway duplicated keys using concatenate mode.
	      tcftest misc [-mt] [-nl|-nb] path rnum
		     Perform miscellaneous test of various operations.
	      tcftest wicked [-mt] [-nl|-nb] path rnum
		     Perform updating operations selected at random.

       Options feature the following.

	      -mt : call the function `tcfdbsetmutex'.
	      -nl : enable the option `FDBNOLCK'.
	      -nb : enable the option `FDBLCKNB'.
	      -rnd : select keys at random.
	      -wb : use the function `tcfdbget4' instead of `tcfdbget2'.
	      -pn num : specify the number of patterns.
	      -dai : use the function `tcfdbaddint' instead of `tcfdbputcat'.
	      -dad : use the function `tcfdbadddouble' instead of `tcfdbputcat'.
	      -rl : set the length of values at random.
	      -ru : perform random operation on random key.

       This command returns 0 on success, another on failure.

SEE ALSO

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

Man Page							    2012-08-18								TCFTEST(1)