My .csv file looks like below, with each header separated out into a separate column. And data
in the columns below. These headers are interspersed throughout the file.
I want to remove all the interspersed headers from the file so that there is just numeric data.
Just like below
So basically I need a way of 'cutting' out lines which begin with "//DATE TIME" per se.
Can someone help me with the following 2 objectives?
1) The following command is just an example. It gets a list of all print jobs. From there I am trying to extract the printer name. It works with the following command:
lpstat -W "completed" -o | awk -F- '{ print $1}'
Problem is, I want... (6 Replies)
Hi,
i have a file with contents like below ( any number of entries can be there)
111
222
333
444
555
i need to make another file with single line like below:
111,222,333,444,555 (without ending , )
TIA
Prvn (8 Replies)
Hi
I have a requirement as follows. My Input file is as follows.
COL1,COL2,COL3,COL4,COL5
987,2,3~7~5,400~468~598,0005~4687~5980
1111,2,2~7,400~468,0005~897
Expected OUTPUT
============
COL1,COL2,COL3,COL4,COL5
987,2,3,400,0005
987,2,7,468,4687
987,2,5,598,5980
1111,2,2,400,0005... (6 Replies)
Hello,
I have file to work with. It has 5 columns. The first three, altogether, constitutes the position. The 4th column contains some values for downstream analysis and the fifth column contains some values that I want to add to 4th column (only if they happen to be in the same position).
My... (5 Replies)
I want to extract the last rows of a data file, similar to that one below:
C1 xxx
C2 rrr
C3 ttt
....
Cn-1 hhh
Cn bbb
C1 yyy
C2 sss
C3 uuu
...
Cn-1 iii
Cn ccc
...
I just want to extract the final rows between C1 and Cn at each data file. n is not a constant,... (2 Replies)
I know uniq exists, but am not sure how to remove repeating lines when they are groups of two different lines repeating themselves, without using sort. I need them to be sorted in the original order, just to remove repeats.
cd /media/AUDIO/WAVE/9780743518673/mp3
~/Desktop/mp3-to-m4b... (1 Reply)
Hi everyone,
I got a data frame like the one below and and would like to do the following:
Ignore the first 3 rows and check in all following rows the second position. If the value is >500, subtract 100.
Example DF:
ABC 22 DE 12
BCD 223 GH 12
EFG 2104 DH ... (4 Replies)
Hi Experts ,
I need your help to collect the complete data between two time frame from the log files, when I try awk it's collecting the data only which is printed with time stamp
for example, awk works well from "16:00 to 17:30" but its not collecting <line*> "from 17:30 to 18:00"
... (8 Replies)
im using the code below to monitor a file:
gawk '{
a += gsub("(^| )accepted( |$)", "&")
a += gsub("(^| )open database( |$)", "&")
} END {
for (i in a)
printf("%s=%s\n", i, a)
}' /var/log/syslog
the code is searching the syslog file for the string "accepted" and "open... (2 Replies)
Discussion started by: SkySmart
2 Replies
LEARN ABOUT ULTRIX
ctod
ctod(1) General Commands Manual ctod(1)Name
ctod - combine DDIS objects into DOTS format
Syntax
ctod [ -x ] object.ddis
Description
The command combines a DDIS encoded object into a Data Object Transport Syntax (DOTS) format, which is written to standard output. The
object may contain references to other DDIS files. The purpose of is to create a single file from multiple references to other files, in
order to transfer or move DDIS objects from one location to another.
object.ddis is a file name, or a minus sign (-) for standard input. If a minus sign is specified, or if no file name is present, standard
input is read. The named object and its external references, if any, are combined into a DOTS data stream which is written to standard
output.
Because a DOTS stream contains binary data, output should be redirected to a file or a pipe.
Options-x Specifies that is to DOTS encode the input file without resolving any external references present in the file. This option is for use
only with files containing no external references.
Restrictions
The only DDIS object types supported in this release are DDIF and DTIF.
Diagnostics
The exit status is 0 if all files were combined successfully and 1 if any of the files could not be combined. Consult `standard error' to
see what files failed, and why.
If the -x option is used and contains any external references, returns an error status of 1, and writes an error message to `standard
error'.
See Alsodtoc(1), DDIS(5), DDIF(5), DTIF(5), DOTS(5)ctod(1)