I've got text files (say file1 and file2) in a directory (say directory1) with several columns like this:
I need to add a header to the files in directory1 and the names of the columns must contain an identifier from another text file (say file3) like this:
So, the output should be like this:
In reality, file3 has over 6000 entries and there are more than 2 files that need a header, so I've written the following loop:
However, the added headers look like this:
I suppose the '' prevent the shell to read the loop syntax. Is there anyway to avoid that? Or any other solution to add the headers?
Many thanks in advance!
---------- Post updated 08-18-16 at 01:20 AM ---------- Previous update was 08-17-16 at 11:32 PM ----------
I've figured it out, I just need to put '' around the looping variable:
Thank you!
Moderator's Comments:
Please use CODE (not HTML) tags as required by forum rules!
Last edited by rbatte1; 08-18-2016 at 06:38 AM..
Reason: Added CODE tags and changed ICODE tags for CODE tags
Hi,
Actually I have a file which consists data . for eg names.
Then I want my sql query to read this file and produce the output.
Currently I am using this
FOR EG : FILENAME is NAMES
for i in `cat NAMES`
{
sqlplus -s $CONNECTID << EOF
spool rooh
set heading off
select... (1 Reply)
I am pretty new to this, but imagine what I am trying to do is possible
iI am trying to make an automated DB comparison tool that selects all columns in all tables and compares them to the same thing in another DB.
anyway I have created 2 files to help with this
the first file is a... (13 Replies)
Hi
I have around 100 users in sun server and have default home directory in /usr/home/<username>
I want to clean their home directory time to time to make free space on root, as users generate many output files during usage of application.
My idea is, generate a file with following command... (4 Replies)
Hi guys
I having som problem trying to use sed to get a file and insert inside another one. I'll try to explain better.
I have a base.txt and using sed(having a array variables) I'm chaging some strings inside this file and saving as base1.txt. until here okay.
Then, I have to get this... (4 Replies)
I run into a issue when I try to do sorting of the following with ascending order, one round of for looping seems not working, anyone knows how to use shell or perl?
$array = (5,0,3,2,7,9,8) (2 Replies)
Hello, where can I get usefull information on the use of looping with for , if and while with extensive examples.
Also use of variables in scripts (1 Reply)
Hi,
Now I have written a script which sorts the records in the file and splits them according to some condition.
Now, I need to modify the script so that it reads all the files one after the other and does the sorting & splitting.
Pls help me in reading all the files in a directory and... (8 Replies)
Although my sed skills are gradually developing, thanks in large part to this forum, I'm having a hard time dealing with pattern space and looping, which I suspect is what I'll need a better handle on to figure out my current issue, which is converting a multi line file like this:
... (4 Replies)
Hey guys, so I am trying to do a loop script that will go through each folder (no gui so just each domain has a folder) and grab out the databases being used on that domain. I know I would use
mysql -e "show databases where not 'information_schema';" once in each directory to pull the actual... (3 Replies)