I thought I had this figured out but was wrong so am humbly asking for help.
The task is to add an additional column to FILE 1 based on records in FILE 2.
The key is in COLUMN 1 for FILE 1 and in COLUMN 1 OR COLUMN 2 for FILE 2.
I want to add the third column from FILE 2 to the beginning of FILE 1 so that the new FILE shows for example:
DESIRED FILE 3
Code:
1:13109 G_T t g -0.4127 0.1042 7.52e-05 ?---??????-? rs540538026
FILE 1
Code:
1:1057989 G_T t g 0.3000 0.0662 5.909e-06 ??++++++???+
1:11007 C_T t c 0.2874 0.0710 5.19e-05 ?????+++???+
1:2190612 A_G a g 1.1252 0.2605 1.561e-05 ???????????+
1:13109 G_T t g -0.4127 0.1042 7.52e-05 ?---??????-?
1:3674534 G_T t g -0.4187 0.1073 9.559e-05 ?---??????-?
1:6932407 A_G a g 1.4977 0.3322 6.535e-06 ???????????+
1:6938780 C_T t c -1.3632 0.3274 3.135e-05 ???????????-
1:7171050 A_G a g 0.0537 0.0134 6.091e-05 ?+++?-++++++
1:8960594 C_T t c -0.9273 0.2319 6.344e-05 ???????????-
1:12203508 C_T t c -1.4228 0.3469 4.111e-05 ???????????-
I have a tab-Delimited file:
Eg:
'test' file contains:
a<tab>b<tab>c<tab>....
Based on certain condition, I wanna increase the number of lines of this file.How do I do that
Eg:
If some value in the database is 1 then one line in 'test' file is fine..
If some value in the database is 2... (1 Reply)
I have a folder that contains say 50 files in a sequential order:
cdf_1.txt
cdf_2.txt
cdf_3.txt
cdf_3.txt
.
.
.
cdf_50.txt.
I need to merge these files in the same order into a single tab delimited file.
I used the following shell script:
for x in {1..50};
do cat cdf_${x}.txt >>... (3 Replies)
Hi Forum
I have a tab delimited file that opens well in Openoffice calc (excel). But when I perform any operation in command line, it reads the file incorrectly. When I 'save As' the same file in office as tab delimited then it works fine.
The file that I think is tab delimited is actually... (8 Replies)
Hi Forum.
I'm struggling to find a solution for the following issue.
I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files.
This is my code so far but it's not working as expected.
for i in... (2 Replies)
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)
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)
Hello,
I have 40 data files where the first three columns are the same (in theory) and the 4th column is different. Here is an example of three files,
file 2: A_f0_r179_pred.txt
Id Group Name E0
1 V N(,)'1 0.2904
2 V N(,)'2 0.3180
3 V N(,)'3 0.3277
4 V N(,)'4 0.3675
5 V N(,)'5 0.3456
... (8 Replies)
Please know that I am very new to unix and trying to learn 'on the job'. I'm only manipulating large tab-delimited files (millions of rows), but I'm stuck and don't know how to proceed with the following. Hoping for some friendly advice :)
I have 2 tab-delimited files - with differing column &... (10 Replies)
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 REDHAT
apple_dump
APPLE_DUMP(1) Netatalk 2.2 APPLE_DUMP(1)NAME
apple_dump - Dump AppleSingle/AppleDouble format file
SYNOPSIS
apple_dump [-a] FILE | DIR
apple_dump -f FILE
apple_dump -d FILE
apple_dump -h | -help | --help
apple_dump -v | -version | --version
DESCRIPTION
apple_dump dump AppleSingle/AppleDouble format file.
OPTIONS -a FILE|DIR
This is default. Dump a AppleSingle/AppleDouble file for FILE or DIR automatically. Extrapolate FinderInfo type from absolute path. If
FILE is not AppleSingle/AppleDouble format, look for .AppleDouble/FILE and ._FILE. If DIR, look for DIR/.AppleDouble/.Parent and ._DIR.
-f FILE
Dump FILE. Assume FinderInfo to be FileInfo.
-d FILE
Dump FILE. Assume FinderInfo to be DirInfo.
-h, -help, --help
Display the help and exit
-v, -version, --version
Show version and exit
NOTE
There is no way to detect whether FinderInfo is FileInfo or DirInfo. By default, apple_dump examins whether file or directory, a parent
directory is .AppleDouble, filename is ._*, filename is .Parent, and so on.
If setting option -f or -d, assume FinderInfo and doesn't look for another file.
SEE ALSO ad(1)Netatalk 2.2 02 Sep 2011 APPLE_DUMP(1)