Prefix a variable in the first column of all the records of the files with and without header
In a bash shell, I have to prefix a variable to two .CSV files File1.CSV and File2.CSV. One of the files has a header and the other one is with no header in the below format:
I need to prefix each record with a variable which I derive from another file File3.CSV using some sed and awk commands. Lets say the variable is "string1 to string2" (the variable has double quotes already and the value keeps changing every week) from File3.CSV, now I have to append this to File1.CSV and File2.CSV in the first column of all the records as below.
Please note, the variable value "string1 to string2" could be just a string, (or) from and to dates, (or) from and to numbers with spaces in between.
I tried to capture the string in a variable by name VAR1 and tried to call it in a sed and prefix it to the files, but did not work.
How could I achieve this for the file with the header and for the file without the header using either sed or awk
Last edited by dhruuv369; 10-24-2013 at 03:21 PM..
Reason: Adding the keywords/tags
I have a flat file and need to count no of records in the file less the header and the trailer record.
I would appreciate any and all asistance
Thanks
Hadi Lalani (2 Replies)
Situation:
Our system currently executes a job (COBOL Program) that generates an interface file to be sent to one of our vendors. Because this system processes information for over 100,000 employees/retirees (and growing), we'd like to multi-thread the job into processing-groups in order to... (4 Replies)
Hello All,
I have a file in the following format. I want to extract the date(020090930, 020090929) in the string "STPAGE020090930" and "STPAGE020090929" and prefix it to all lines below them. The output must be put into a new file.
STPAGE020090930
xyzz aalc... (3 Replies)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Hi All,
I have got a requirement.
I have a source file, EMPFULL.txt and I need to split the data for every 30 records
and place a Typical Header as below with system and page number too.
2012.01.03 Employee Dept Report 1... (6 Replies)
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Hi All,
I want to find the difference between two files, by checking only the headers (column names) and report if any new column is added in the latest file.
For Ex: If the file "declartion.txt has these columns
url;image;id;showcase_id;showcase_name
and the actual file "feed.txt" has... (34 Replies)
there can be n number of columns but the number of columns and header name will remain same in all 3 files. Files are tab Delimited.
a.txt
Name 9/1 9/2
X 1 7
y 2 8
z 3 9
a 4 10
b 5 11
c 6 12
b.xt
Name 9/1 9/2
X 13 19
y 14 20
z 15 21
a 16 22
b 17 23
c 18 24 c.txt
Name 9/1 9/2... (14 Replies)
Hi,
I have a backup report that unfortunately has some kind of hanging indent thing where the first line contains one column more than the others
I managed to get the output that I wanted using awk, but just wanting to know if there is short way of doing it using the same awk
Below is what... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT OPENSOLARIS
ssastringtochar
SSAStringCpy(3SNMP) SNMP Library Functions SSAStringCpy(3SNMP)NAME
SSAStringCpy, SSAStringInit, SSAStringToChar, SSAStringZero - Sun Solstice Enterprise Agent string helper functions
SYNOPSIS
cc [ flag ... ] file ... -lssasnmp [ library .. ]
#include <impl.h>
void *SSAStringZero(String *string);
int SSAStringInit(String *string, uchar_t *chars, int len,
char *error_label);
int SSAStringCpy(String *string1, String *string2, char *error_label);
char *SSAStringToChar(String string);
DESCRIPTION
The SSAStringCpy() function makes a deep copy of string2 to string1. This function assumes that string1 has been processed by the SSAS-
tringZero() function. Memory is allocated inside the string1 and the contents of string2, not just the pointer, is copied to the string1.
If an error is encountered, an error message is stored in the error_label buffer.
The SSAStringInit() function copies the char array from chars to the string instance with the specified length len. This function assumes
that the string instance has been processed by the SSAStringZero() function or no memory is allocated inside the string instance. If an
error is encountered, an error message is stored in the error_label buffer.
The SSAStringToChar() function returns a temporary char array buffer for printing purposes.
The SSAStringZero() function frees the memory inside of the String instance, but not the string object itself.
RETURN VALUES
The SSAStringInit() and SSAStringCpy() functions return 0 if successful and -1 if error.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Obsolete |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO attributes(5)SunOS 5.11 30 Apr 2006 SSAStringCpy(3SNMP)