01-29-2009
Help needed to convert delimited to CSV format
I have a file with the data as follows..
FILE 1|#START|Jan 22 15:03
FILE 1|#END|Jan 22 16:06
FILE 2|#START|Jan 22 5:15
FILE 2|#END|Jan 22 5:25
FILE 3|#START|Jan 22 07:03
FILE 3|#END|Jan 22 08:15
FILE 4|#START|Jan 22 16:09
FILE 4|#END|Jan 22 16:55
FILE 1|#START|Jan 22 18:15
FILE 1|#END|Jan 22 18:25
I need to get a .csv file with the format
FILE NAME,START TIME,END TIME
The problem is for the file FILE1,there are two entries...When i am trying to get that format using a loop i am getting second END time,(overcoming first END time)..Can u people suggest some solution...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
2. Shell Programming and Scripting
Hi all perl gurus,
I need your help to get the desired output in perl.
I have a file which has text in it in the format
Connection request start timestamp = 12/08/2008 00:58:36.956700
Connect request completion timestamp = 12/08/2008 00:58:36.959729
Application idle time ... (10 Replies)
Discussion started by: azs0309
10 Replies
3. Shell Programming and Scripting
Can any one give the idea on this, please.
I have the following XML file and wants to convert into CSV(comma separated value) format.
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Waveset PUBLIC 'waveset.dtd' 'waveset.dtd'>
<Waveset>
<Object name='ra8736'>
<Attribute name='ADDRESS'... (2 Replies)
Discussion started by: kumar04
2 Replies
4. Shell Programming and Scripting
Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies
5. UNIX for Advanced & Expert Users
Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies
6. Shell Programming and Scripting
Hi ,
i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies
7. UNIX for Dummies Questions & Answers
I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Discussion started by: evelibertine
3 Replies
8. Shell Programming and Scripting
I have a csv data file :
A,B,C,D,"A,B",E,"GG,H"
E,F,G,H,I,J,"S,P"
I need to replace all "," with "|" except the ones between double quotes i.e
A|B|C|D|"A,B"|E|"GG,H"
E|F|G|H|I|J|"S,P"
CAn someone assist? (8 Replies)
Discussion started by: Shivdatta
8 Replies
9. Shell Programming and Scripting
Hello,
I have a text file with space and tab (mixed) delimited file and need to convert into CSV.
# cat test.txt
/dev/rmt/tsmmt32 HP Ultrium 6-SCSI J3LZ 50:03:08:c0:02:72:c0:b5 F00272C0B5 0/0/6/1/1.145.17.255.0.0.0 /dev/rmt/c102t0d0BEST
/dev/rmt/tsmmt37 ... (6 Replies)
Discussion started by: prvnrk
6 Replies
10. Shell Programming and Scripting
Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant.
The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies
LEARN ABOUT CENTOS
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)