07-24-2006
Quote:
PS: Assume the 20 and 19, island and airline are all at the same char position
cat test
Faroe Island 20 island
japan 19 test
japan 19 airline
Alpha Zulu 21 island
Alpha 121 island
Try this:
sed '
s/ \([0-9]\)/,\1/
s/\([0-9]\) /\1,/
' test | sort -k1,3
Alpha,121,island
Alpha Zulu,21,island
Faroe Island,20,island
japan,19,airline
japan,19,test
if you want to change "," back to space
sed '
s/ \([0-9]\)/,\1/
s/\([0-9]\) /\1,/
' test | sort -k1,3 | sed 's/,/ /g'
Alpha 121 island
Alpha Zulu 21 island
Faroe Island 20 island
japan 19 airline
japan 19 test
Last edited by vish_indian; 07-24-2006 at 07:45 AM..
Reason: Remove -n from sort
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (10 Replies)
Discussion started by: akdwivedi
10 Replies
2. Shell Programming and Scripting
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... (13 Replies)
Discussion started by: ssantoshss
13 Replies
3. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: sudhir_barker
5 Replies
4. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: zooby
1 Replies
5. Shell Programming and Scripting
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}' ... (2 Replies)
Discussion started by: Pratik4891
2 Replies
6. Shell Programming and Scripting
Hi,
Let say I have a file which has around 400 fields.
SampleFile
=========
PATIENTID|FACILITY|................|TIME_LAST_VISITED_BY_MD|.....|STATUS|
How is it possible to find out which field is TIME_LAST_VISITED_BY_MD?fro example by seeing the above structure we can saw FACILITY... (5 Replies)
Discussion started by: machomaddy
5 Replies
7. Linux
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 (3 Replies)
Discussion started by: mailme0205
3 Replies
8. Shell Programming and Scripting
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... (6 Replies)
Discussion started by: Twinklefingers
6 Replies
9. UNIX for Dummies Questions & Answers
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 Replies)
Discussion started by: a_bahreini
10 Replies
10. Shell Programming and Scripting
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... (9 Replies)
Discussion started by: Neelkanth
9 Replies
LEARN ABOUT PHP
mb_strrpos
MB_STRRPOS(3) 1 MB_STRRPOS(3)
mb_strrpos - Find position of last occurrence of a string in a string
SYNOPSIS
int mb_strrpos (string $haystack, string $needle, [int $offset], [string $encoding = mb_internal_encoding()])
DESCRIPTION
Performs a multibyte safe strrpos(3) operation based on the number of characters. $needle position is counted from the beginning of
$haystack. First character's position is 0. Second character position is 1.
PARAMETERS
o $haystack
- The string being checked, for the last occurrence of $needle
o $needle
- The string to find in $haystack.
o $offset
- May be specified to begin searching an arbitrary number of characters into the string. Negative values will stop searching at an
arbitrary point prior to the end of the string.
o $encoding
-The $encoding parameter is the character encoding. If it is omitted, the internal character encoding value will be used.
RETURN VALUES
Returns the numeric position of the last occurrence of $needle in the $haystack string. If $needle is not found, it returns FALSE.
CHANGELOG
+--------+---------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------+
| 5.2.0 | |
| | |
| | Added the optional parameter $offset. |
| | |
+--------+---------------------------------------+
NOTES
Note
The $encoding parameter was moved from the third position to the fourth in PHP 5.2.0. For backward compatibility, $encoding can be
specified as the third parameter, but doing so is deprecated and will be removed in the future.
SEE ALSO
mb_strpos(3), mb_internal_encoding(3), strrpos(3).
PHP Documentation Group MB_STRRPOS(3)