|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Sort tab delimited file according to which rows have missing values
Post 302939681 by RudiC on Friday 27th of March 2015 03:25:04 PM
03-27-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
So my file looks like this:
title number
JR 2
JR 2
JR 4
JR 5
NM 5
NM 8
NM 2
NM 8
I used this line that I wrote to convert it to rows so it will look like this:
awk -F"\t" '!/^$/{a=a" "$3} END {for ( i in a) {print i,a}}' occ_output.tab > test.txt
JR 2 2 4 5
NM 5 8... (4 Replies)
Discussion started by: kylle345
4 Replies
2. Shell Programming and Scripting
Hi
I am trying to retrieve values from a tab-delimited file.I am using
while read record
value=`echo $record | cut -f12`
done
Where 12 is the column no i want retieve and record is one line of the file.
But it is returning the full record.
Plz help (4 Replies)
Discussion started by: akashtcs
4 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have the following code:
LIST=`ls | grep '.sql$'`
echo $LIST
The above code will give me something like..
file1.sh file2.sh file3.sh file4.sh file5.sh
I want to display the values into rows using echo like...
file1.sh
file2.sh (5 Replies)
Discussion started by: adshocker
5 Replies
4. UNIX for Advanced & Expert Users
Hi
I have two tab delimited file with different number of columns but same number of rows. I need to combine these two files in such a way that row 1 in file 2 comes adjacent to row 1 in file 1.
For example:
The content of file1:
field1 field2 field3
a1 a2 a3
b1 b2 b3... (2 Replies)
Discussion started by: mary271
2 Replies
5. Shell Programming and Scripting
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies
6. UNIX for Dummies Questions & Answers
I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies
7. UNIX for Dummies Questions & Answers
I have tried the following to no avail.
xargs -n8 < test.txt
awk '{if(NR%6!=0){p=""}else{p="\n"};printf $0" "p}' Mod_Alm_log.txt > test.txt
I have tried different variations of the above, the problem is mixes lines together.
And it includes the tags "%a and %A" I need them to be all tab... (16 Replies)
Discussion started by: mytouchsr
16 Replies
8. UNIX for Dummies Questions & Answers
Here's a sample of the data:
NAME BIRTHDAY SEX LOCATION AGE ID
Jim 05/11/1986 M Japan 27 86
Rei 08/25/1990 F Korea 24 33
Jane 02/24/1985 F India 29 78
I've been trying to sort files using the... (8 Replies)
Discussion started by: maihani
8 Replies
9. UNIX for Dummies Questions & Answers
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies
10. UNIX for Beginners Questions & Answers
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT FREEBSD
sdpcontrol
SDPCONTROL(8) BSD System Manager's Manual SDPCONTROL(8) NAME
sdpcontrol -- Bluetooth Service Discovery Protocol query utility SYNOPSIS
sdpcontrol -h sdpcontrol -a address command [parameters ...] sdpcontrol -l [-c path] command [parameters ...] DESCRIPTION
The sdpcontrol utility attempts to query the specified Service Discovery Protocol (SDP) server. Remote SDP servers are identified by their address. Connection to the local SDP server is made via the control socket. The sdpcontrol utility uses Service Search Attribute Requests and prints results to standard output and error messages to standard error. The options are as follows: -a address Connect to the remote device with the specified address. The address can be specified as BD_ADDR or a name. If a name was speci- fied, the sdpcontrol utility attempts to resolve the name via bt_gethostbyname(3). -c path Specify path to the control socket. The default path is /var/run/sdp. -h Display usage message and exit. -l Query the local SDP server via the control socket. command One of the supported commands (see below). The special command help can be used to obtain a list of all supported commands. To get more information about a specific command, use help command. parameters One or more optional space separated command parameters. COMMANDS
The currently supported node commands in sdpcontrol are: Browse Search EXIT STATUS
The sdpcontrol utility exits 0 on success, and >0 if an error occurs. SEE ALSO
bluetooth(3), sdp(3) AUTHORS
Maksim Yevmenkin <m_evmenkin@yahoo.com> CAVEATS
The sdpcontrol utility only implements client side functionality. The sdpcontrol utility only requests the following attributes from the SDP server: 1. Service Record Handle 2. Service Class ID List 3. Protocol Descriptor List 4. Bluetooth Profile Descriptor List BSD
February 7, 2015 BSD