07-22-2010
Need help to read rows from one file and concatenate to another
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the format ('row1','row2','row3')
eg:
file A:
Y781
TGH8
UIP9
output:
('Y781','TGH8','UIP9')
NB: No, I'm not a college student asking for help on his coding assignment!
Last edited by carlos_anubis; 07-22-2010 at 10:41 AM..
Reason: Clarifying nature of source file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to search a file for two values (valueA & valueB). ValueA will be on a different row than valueB, and concatenate the two together on the same row of my output.
Example: search input file for strings "node" and "OS", combine the two results into one row
input
node A
text
text
OS... (4 Replies)
Discussion started by: indianadoug
4 Replies
2. Shell Programming and Scripting
I have 2 files
FILEA
1232342
1232342
2344767
4576823
2325642
FILEB
3472328
2347248
1237123
1232344
8787890
I want the output to go into a 3rd file and look like:
FILEC
1232342 3472328 (1 Reply)
Discussion started by: unxusr123
1 Replies
3. Shell Programming and Scripting
Hi all
i have a file like
2006,1,2
2007,2,3
2008,3,4
I will read this and my output should be like
2006,1,2
2007,1,2
2008,1,2
2007,2,3
2008,2,3
2008,3,4
Giving the explanation, we will read the first line of the file and if the year any other than current year, we will print as many... (1 Reply)
Discussion started by: vasuarjula
1 Replies
4. Shell Programming and Scripting
need a shell which perform following function
file 1 ( every time new data comes)
1212
2323
3434
4545
5656
.
.
.
.
file 2 (fixed line)
update bc_tbl set aix=data , bix=back where cix=U and serial=;
now when i execute shell it will concatinate file 1, file 2 & make file 3 as... (3 Replies)
Discussion started by: The_Archer
3 Replies
5. Shell Programming and Scripting
i have a file as below and i need to load it into oracle. The problem is, some of the rows are in 2 lines.
123456_PosWlist ----- ----- IN 0/0
123456_PosWListRpt ----- ----- IN 0/0
123456_PosWListCSV
----- -----... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies
6. UNIX for Dummies Questions & Answers
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (0 Replies)
Discussion started by: carlos_anubis
0 Replies
7. Shell Programming and Scripting
Hi....
I have a need of script to do delete row whenever condition is true....
2.16 (3) 1 3 9999 0 (1) (0)
34.42 (4) 1 3 9999 37 (2) (3)
34.38 (4) 1 3 9999 64 (2) (3)
34.4 (4) 1 3 1 ... (13 Replies)
Discussion started by: nex_asp
13 Replies
8. Shell Programming and Scripting
I need to concatenate the rows that are broken (because of carriage return and line feed) in unix.
Input
123|456|789|""
987|786|"GRT
"|""
3455|896|654|456|""
457|234|"RT"|"PR
TY"|""
Output
123|456|789|""
987|786|"GRT"|""
3455|896|654|456|""
457|234|"RT"|"PRTY"|"" (16 Replies)
Discussion started by: meet_calramz
16 Replies
9. Shell Programming and Scripting
I'm trying to find a way to concatenate consecutive rows (key is column $1 and $2) if column $5 an $6 are integers and redefine ranges in columns $3&$4 and $5&$6
Unfortunately I'm still learning the very basics so I cannot figure a way of doing this with awk.
Input file
15 30 21 21 25.0... (11 Replies)
Discussion started by: alex2005
11 Replies
10. Shell Programming and Scripting
Hi all,
i need a bash script.
I have a 3 file named Milano, Torino, Firenze
Into file i have:
Milano
Marco
Luca
Giorgio
Michele
PatrizioTorino
Marco
Giulio
Emilio
MicheleFirenze
Luca
Giorgio
Marco
Saverio
EmilioThe output should be a all_city.csv file like: (3 Replies)
Discussion started by: kamose
3 Replies
LEARN ABOUT OPENSOLARIS
readonly
readonly(1) User Commands readonly(1)
NAME
readonly - shell built-in function to protect the value of the given variable from reassignment
SYNOPSIS
sh
readonly [name]...
ksh
**readonly [name [= value]]...
**readonly -p
ksh93
++readonly [-p] [name [= value]]...
DESCRIPTION
sh
The given names are marked readonly and the values of the these names may not be changed by subsequent assignment. If no arguments are
given, a list of all readonly names is printed.
ksh
The given names are marked readonly and these names cannot be changed by subsequent assignment.
When -p is specified, readonly writes to the standard output the names and values of all read-only variables, in the following format:
"readonly %s=%s
", name, value
if name is set, and:
"readonly $s
", name
if name is unset.
The shell formats the output, including the proper use of quoting, so that it is suitable for reinput to the shell as commands that achieve
the same value and readonly attribute-setting results in a shell execution environment in which:
1. Variables with values set at the time they were output do not have the readonly attribute set.
2. Variables that were unset at the time they were output do not have a value at the time at which the saved output is re-input to
the shell.
On this manual page, ksh(1) commands that are preceded by one or two ** (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a
variable assignment. This means that tilde substitution is performed after the = sign and word splitting and file name genera-
tion are not performed.
ksh93
readonly sets the readonly attribute on each of the variables specified by name which prevents their values from being changed. If =value
is specified, the variable name is set to value before the variable is made readonly.
If no names are specified then the names and values of all readonly variables are written to standard output.
readonly is built-in to the shell as a declaration command so that field splitting and pathname expansion are not performed on the argu-
ments. Tilde expansion occurs on value.
-p Causes the output to be in a form of readonly commands that can be used as input to the shell to recreate the current set of readonly
variables.
On this manual page, ksh93(1) commands that are preceded by one or two + symbols are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. They are not valid function names.
5. Words, following a command preceded by ++ that are in the format of a variable assignment, are expanded with the same rules as a
variable assignment. This means that tilde substitution is performed after the = sign and field splitting and file name genera-
tion are not performed.
EXIT STATUS
ksh93
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
ksh(1), ksh93(1), sh(1), typeset(1), attributes(5)
SunOS 5.11 2 Nov 2007 readonly(1)