10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi All,
I have a data file and need to extract and convert it into csv format:
1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this.
2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 Replies
2. Shell Programming and Scripting
Hello,
I'm attempting to extract 13 digit numbers beginning with 978 from a data file with the following command:
awk '{ for(i=1;i<=NF;i++) if($i ~ /^978/) print $i; }' datafile > outfile
This typically works. However, the new data file is an .xml file, and this command is no longer working... (6 Replies)
Discussion started by: palex
6 Replies
3. Shell Programming and Scripting
Hi
I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it.
IN301330/00001 pvavan kumar limited xyz@ttccpp.com
IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in
IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies
4. Shell Programming and Scripting
Hey all,
i´ve got the following problem:
i´m aquiring data with an instrument and i get data in a .txt file.
This is how the txt file looks like:
Report of AU program poptau
F1P=-49.986ppm F2P=-110.014ppm
Target directory for serfile: D:/data/Spect500/nmr/Thoma/882
Linear... (17 Replies)
Discussion started by: expikx
17 Replies
5. UNIX for Dummies Questions & Answers
Hello all,
I want to extract some particular data from a files and than add all the values .
but i m not able to cut the particular word(USU-INOCT and USU-OUTOCT) as it is coming not in column. and than able to add values coming in it .
can anyone help me Please
cat <file name>
... (7 Replies)
Discussion started by: anamdev
7 Replies
6. Shell Programming and Scripting
I have an of xml file as shown below
<?xml version='1.0' encoding='ASCII' standalone='yes' ?>
<Station Index="10264" >
<Number Value="237895890" />
<Position Lat="-29.5" Lon="3.5" />
<MaxDepth Value="-4939" />
<VeloLines Count="24">
<VeloLine Index="0" >
<Depth... (3 Replies)
Discussion started by: shashi792
3 Replies
7. Shell Programming and Scripting
Hi,
I have a tmp file like below:
<ADATA>
ANUM=900
ADESC=Saving
ATYP=0
TXREGD=0
</ADATA>
<ADATA>
ANUM=890
ADESC=Saving
ATYP=0
ABAL=9000
TXREGD=1
</ADATA>
<ADATA> (6 Replies)
Discussion started by: kunigirib
6 Replies
8. Shell Programming and Scripting
Hi All,
I have a requirement where I have to search the file with some text say "Exception". This exception word can be repeated for more then 10 times.
Suppose the "Exception" word is repeated at line numbers say x=10, 50, 60, 120. Now I want to extract all the lines starting from x-5 to... (3 Replies)
Discussion started by: rrangaraju
3 Replies
9. UNIX for Advanced & Expert Users
hi everybody,
i have a file, in it I need to extract some data that follows a particular pattern..
For example: my file contains like
now running Speak225
sep 22 mon 16:34:05 2008
--------------------------------
... (4 Replies)
Discussion started by: mohkris
4 Replies
10. Shell Programming and Scripting
Hello all,
Iam newbie here and to unix programming. I have the following text file.
A:Woshington,B:London,C:Paris,D:Manchester,C:Lisbon,E:Cape town.
Now I would like extract this and store in database. here is the script I have tried but it did work.
CITY1:`echo "$text" | grep "A:"... (11 Replies)
Discussion started by: mam
11 Replies