I have data coming in like below. Not all data is like that, these are the problem records that is causing the ETL load to fail. Can you pls help me with combining theese broken records!
Appreciate your time and effort!
Thanks,
Last edited by radoulov; 01-05-2012 at 07:00 PM..
Reason: Code tags!
i am writing a script that reads in a file and i just want it to print each element on a new line here is my code and the data that i want to read in
#!/usr/bin/perl
use strict;
use CGI qw(:standard);
use CGI qw(:cgi);
my $data_file = "/tmp/results.txt";
my $configuration;
my... (3 Replies)
Hi All,
I have been trying to re-arrange the below data using AWK or Perl.
Can anybody help me ?
Thanks in advance.
Input:
111 222
333 444
AAA BBB
CCC DDD
555 666
777 888
EEE FFF
GGG HHH
Output: (6 Replies)
Hi
I have to convert the data in a file
*******
01-20-09 11:14AM 60928 ABC Valuation-2009.xls
01-20-09 11:16AM 55808 DEF GHI Equation-2009.xls
01-20-09 11:02AM 52736 ABC DF Valuation-2009.xls
01-20-09 11:06AM 89600 THE... (6 Replies)
I want to check whether if any column data has any + , - , = prefixed to it then convert it in such a form that in excel its not read as formula.
echo "$DATA" | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5,$6,$7,$8.$9,$10,$11,$12}' (4 Replies)
Hello everybody,
I have a file containing some statistics regarding CPU usage. The file has this syntax :
Fri Jul 16 14:27:16 EEST 2010
Cpu(s): 15.2%us, 1.4%sy, 0.0%ni, 82.3%id, 0.1%wa, 0.0%hi, 0.9%si, 0.0%st
Fri Jul 16 15:02:17 EEST 2010
Cpu(s): 15.3%us, 1.4%sy, 0.0%ni, 82.3%id, ... (9 Replies)
HI
I want to make it single row if start with braces i.e. { .Any idea
{1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4:
:R:GENL
:C::xx//xx1
:20C::yy//yy1
:2S:xxT}
{1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4:
:z:GENL
:v::xx//xx1
:10C::yy//yy1
:4S:xxT
... (2 Replies)
Hi,
I am generating the following output from my script.
Country,A,B,C,D,E,F
INDIA ,3755019,774604,484749,329838,7333612,442031
CHINA ,3716520,889197,530899,379754,6198475,355768
JAPAN ,52038,30462,231224,147275,1272,498
USA,9494,1130,0,0,15303,451... (5 Replies)
Need assistance on the data extraction using awk
Below is the format and would like to extract the data in another format
-------------------------------------------------------------------------------------------------
Minimum Temperature (deg F )
DAY 1 2 3 4 5 6 7 8 9 10 11... (4 Replies)
Discussion started by: ajayram_arya
4 Replies
LEARN ABOUT OSF1
acct
acct(2) System Calls Manual acct(2)NAME
acct - Enables and disables process accounting
SYNOPSIS
int acct ( char *path );
PARAMETERS
Specifies a pointer to the pathname of the file, or specifies a null pointer.
DESCRIPTION
The acct() function enables and disables UNIX process accounting. When enabled, process accounting produces an accounting record on behalf
of each terminating process. The path parameter specifies the pathname of the file to which an accounting record is written. When the
path parameter is 0 (zero) or a null value, the acct() function disables the accounting routine.
If the path parameter refers to a symbolic link, the acct() function writes records to the file pointed to by the symbolic link.
If Network File System is installed on your system, the accounting file can reside on another node. To ensure accurate accounting, each
node must have its own accounting file, which can be located on any node in the network.
The calling process must have superuser privilege to enable or disable process accounting.
RETURN VALUES
Upon successful completion, the acct() function returns a value of 0 (zero). Otherwise, a value of -1 is returned and errno is set to
indicate the error.
ERRORS
If the acct() function fails, errno may be set to one of the following values: The calling process does not have appropriate system privi-
lege. The file named by the path parameter does not exist.
The file named by the path parameter is not an ordinary file. Write permission is denied for the named accounting file. The named file
resides on a read-only file system.
RELATED INFORMATION
Functions: exit(2), sigaction(2), sigvec(2), expacct(3), raise(3) delim off
acct(2)