Sorting a flat file based on multiple colums(using character position) Post: 302081235

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert at a particular position in flat file

Hi All, I have a flat file with ~ as de-limiter (e.g: aaa~ba a~caa~0~d~e) What I want is check if the 4th character is 0 and replace it with say 4. So now it becomes : aaa~ba a~caa~4~d~e. I have to do this for the whole file, but the delimiter position remains the same, not the...

2. Shell Programming and Scripting

Convert case on specified position of flat file

Please help Need a script which will do the following : Search on fixed width file , go to position (25,2) which means 25th and 26th position, Find if there are any char in lower case: For example 25,2 can be (9T) or (9w) or (Ww) or (wW)....The two positions can be numeric or alpha...no...

3. Shell Programming and Scripting

Sorting the records in the Flat file

Hi all, I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat. Can any tell me how to sort the file except first line in the file For ex: i/p First line: DXYZ Second line : jumy third : cmhk fourth : andy Output should...

4. Shell Programming and Scripting

Cut multiple data based on character position

How to extract multiple data based on character position. I need to fetch from 7-9 and 22-26 and there is no delimiter for 22-26 since it is part of the column. The file may have more than 1000 character long.I managed to pull any one but not both for example test data 12345 zxc vbnmlk...

5. Shell Programming and Scripting

Read from Multiple character delimited flat file

Hello Guys I have a multiple character delimited flat file "|~|". when I tried to read the data the "|" character also coming Example I/P file 9882590|~|20111207|~|K03501000063005574033961|~|K|~| Command to get the second column I used awk -F"|~|" ' {print $2}' ...

6. Shell Programming and Scripting

Find the position of a field/column in a flat file

7. Linux

Linux script to remove a character in a file based on position.

Greetings, We have a requirement where we need to loop in a fixed width file in linux and remove a character based on a position for every record. It would highly appreciate if someone can help to automate this. Appreciate your time and help! Regards

8. Shell Programming and Scripting

Find position of character in multiple strings in a file

Greetings. I have a file with information like this: AMNDHRKEOEU?AMNDHRKEOEU?AMNDHRKEOEU?AMNDHRKEOEU? AMNDHRKEEU?AMNDHREOEU? AMNDHREU?AHRKEOEU?AMNDHRKEU?AMNDKEOEU? What I need to extract is the position, in every line, of every occurrence of '?' A desired output would be something...

9. UNIX for Dummies Questions & Answers

Change a character based on its position number

Hi I have a text file that I want to change some of the characters based on their position. My file contain multiple lines and characters should be counted continuously line by line. For example, I want to convert the 150th T to C. What can I do? Here is a portion of my file:...

10. Shell Programming and Scripting

Splitting based on occurence of a Character at fixed position

I have a requirement where i need to split a file based on occurence of a character which is present at a fixed position. Description is as below: 1. The file will be more than 1 Lakh records. 2. Each line will be of fixed length of 987 characters. 3. At position 28 in each line either 'C' or...

LEARN ABOUT SUSE

opimport

OPIMPORT(1)						      General Commands Manual						       OPIMPORT(1)

NAME

       opimport - converts sample database files

SYNOPSIS

       opimport [ options ] input_file

DESCRIPTION

       opimport converts sample database files from a foreign binary format (abi) to the native format.

OPTIONS

       --abi / -a
	      Input abi file description location.

       --force / -f
	      Force conversion even if the input and output abi are identical.

       --output / -o filename
	      Specify  the  output  filename. If the output file already exists it is not overwritten but data are accumulated in. Sample filename
	      are informative for post profile tools and must be kept identical, in other word the pathname from the first path component contain-
	      ing a '{' must be kept as it in the output filename.

       --help / -? / --usage
	      Show help message.

       --verbose / -V
	      Give verbose debugging output.

       --version / -v
	      Show version.

ENVIRONMENT

       No special environment variables are recognised by opimport

FILES

       /var/lib/oprofile/abi
	      The abi file description of the sample database files

VERSION

       This man page is current for oprofile-0.9.6.

SEE ALSO

       /usr/share/doc/oprofile/, oprofile(1)

4th Berkeley Distribution					 Tue 06 July 2010						       OPIMPORT(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert at a particular position in flat file

Discussion started by: akdwivedi

2. Shell Programming and Scripting

Convert case on specified position of flat file

Discussion started by: ssantoshss

3. Shell Programming and Scripting

Sorting the records in the Flat file

Discussion started by: sudhir_barker

4. Shell Programming and Scripting

Cut multiple data based on character position

Discussion started by: zooby