I have attached a txt doc with data sorted into columns (it is best to open with "word pad" to maintain the correct format. In the data there are two columns E/N and Ko. I wanted to know how to extract the data and form an excel sheet. Or at least just extract the data. The data is in much larger files so I would need to some how search for the E/N and Ko columns and extract the data underneath them for approximatly 100 rows skipping the first row. Let me know if that makes sense. Thanks for the help in advance. Lenny
Hello,
I need your help to extract text from following:
./sherg_fyd_rur:blkabl="R23.21_BL2008_0122_1"
./serge_a75:rlwual="/main/r23.21=26-Mar-2008.05:00:20UTC@R11.31_BL2008_0325"
./serge_a75:blkabl="R23.21_BL2008_0325"
./sherg_proto_npiv:bkguals="R23.21_BL2008_0302 I80_11.31_LR"
I... (11 Replies)
Hi, I have 600 text files. In each txt file, I have 3 columns, e.g:
File 1
a 0.21 0.003
b 0.34 0.004
c 0.72 0.002
File 2
a 0.25 0.0083
b 0.38 0.0047
c 0.79 0.00234
File 3
a 0.45 0.0063
b 0.88 0.0027
c 0.29 0.00204
...
my filename as "sc2408_0_5278.txt sc2408_0_5279.txt... (2 Replies)
I have the following requirement.
file1.txt (this could contain 5 million rows)
ABC 1234 XYZ .... (3000 bytes)
QRD 4612 GHT .... (3000 bytes)
I need to create
file2.txt
1234
4612
I have a EAI process to change file2.txt into
file3.txt
4555
3743
Then I would have to use... (0 Replies)
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 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
I have roughly ~30 .txt files in a directory which all have unique names. These files all contain text arranged in columns separated by whitespace (example file:
[#YY MM DD hh mm WDIR WSPD GST WVHT DPD APD MWD PRES ATMP WTMP DEWP VIS TIDE
#yr mo dy hr mn degT m/s m/s m sec ... (5 Replies)
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
Hi,
PFB the input:
unix/java/perl/random.txt
unix1/java1/random1.txt
unix2/java2/perl2/random2.txt
unix3/java3/random3.txt
unix4/random4.txt
i want the following output:
random.txt
random1.txt
random2.txt
random3.txt
random4.txt
the patterns can change but i need the .txt file... (5 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)