Help with concatinating the data of 2 files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with concatinating the data of 2 files
# 8  
Old 02-07-2013
Then you have to play with FS and OFS, as mentioned before. Try like FS=" +" and OFS="\t" and combinations of white space that you see in your in your input files. BTW - your input files have trailing spaces that can influence results as well. Try to get rid of them.
# 9  
Old 02-08-2013
Hi RudiC,

Below im pasting the script which is running on 2 different servers and generating the files 348.csv & 349.csv (which we are trying to merge)

Code:
#!/bin/bash
F=eai_js_348.csv
D=dm_eai_348.csv
cat > $F << EOF # Write a header to the file $F
Timestamp             BRM Servers
                           348
EOF
cat > $D << EOF # Write a header to the file $D
Timestamp             BRM Servers
                           348
EOF
# Write data every 1800 seconds.
while sleep 1800; do
    date +'%m/%d/%Y %H:%M' | tr -d \\n >> $F
    printf '          ' >> $F
    netstat | grep 16001 | wc -l >> $F
    date +'%m/%d/%Y %H:%M' | tr -d \\n >> $D
    printf '          ' >> $D
    ps -ef | grep -i DM_EAI | wc -l >> $D
done

So, wanted to check if something can be fine tuned in this script only so that can avoid the formatting of the final output (after the merge) or atleast can get rid of the trailing spaces or any other formatting issues what you mentioned in the previous post.

Thanks
# 10  
Old 02-08-2013
I can't see anything immediately jumping to my eyes. There's no trailing spaces in above script...
You could try to print everything in one go to the respective files:
Code:
$ printf "%s\t\t%s", $(date +'%m/%d/%Y %H:%M), $(netstat | grep 16001 | wc -l)  > $F

, but I'm not sure that would really help...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

2. Shell Programming and Scripting

Combine data from two files base on uniq data

File 1 ID Name Po1 Po2 DD134 DD134_4A_1 NN-1 L_0_1 DD134 DD134_4B_1 NN-2 L_1_1 DD134 DD134_4C_1 NN-3 L_2_1 DD142 DD142_4A_1 NN-1 L_0_1 DD142 DD142_4B_1 NN-2 L_1_1 DD142 DD142_4C_1 NN-3 L_2_1 DD142 DD142_3A_1 NN-41 L_3_1 DD142 DD142_3A_1 NN-42 L_3_2 File 2 ( Combination of... (1 Reply)
Discussion started by: pareshkp
1 Replies

3. Shell Programming and Scripting

Concatinating the lines based on number of delimiters

Hi, I have a problem to concatenate the lines based on number of delimiters (if the delimiter count is 9 then concatenate all the fields & remove the new line char bw delimiters and then write the following data into second line) in a file. my input file content is Title| ID| Owner|... (4 Replies)
Discussion started by: bi.infa
4 Replies

4. Shell Programming and Scripting

How to extract data from indexed files (ISAM files) maintained in an unix server.

Hi, Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format . Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
Discussion started by: devina
2 Replies

5. Shell Programming and Scripting

Problem when concatinating wildcard onto file location in bash script

I am having difficulty with the following script: #! /bin/bash filelist=~/data/${1}* ~/./convertFile $filelist ~/temp/outputEssentially, there are a large number of files in the directory ~/data, each with a four-letter code at the beginning (eg. aaaa001 aaaa002 bbbb001 bbbb002 etc). The... (11 Replies)
Discussion started by: Lears_Fool
11 Replies

6. Shell Programming and Scripting

Help - Bug: A script to compile two types of data files into two temporary files

Dear other forum members, I'm writing a script for my homework, but I'm scratching all over my head and still can't figure out what I did wrong. Please help me. I just started to learn about bash scripting, and I appreciate if anyone of you can point out my errors. I thank you in advance. ... (3 Replies)
Discussion started by: ilove2smoke
3 Replies

7. Shell Programming and Scripting

concatinating the string in each line of the file

how to concatenate particular string in each line of a file.. root$cat conf check_11043 heartbeat_4345 ---------- if i want to add the string "done" output of the file should be check_11043 done heartbeat_4345 done (1 Reply)
Discussion started by: mail2sant
1 Replies

8. Shell Programming and Scripting

concatinating the array

i need to concatenate array like. eg: a = { a,b,c} b= { 1,2,3} result should be like below c={a1,b2,c3} can u help me out (2 Replies)
Discussion started by: mail2sant
2 Replies

9. UNIX for Dummies Questions & Answers

concatinating data

Hi All, I have a file penn.txt which has the following data: hello I wish to append a sting to this file so that data in the file would be represented as: hello%%% Any help on this is greatly appreciated. Thanks KOP. (1 Reply)
Discussion started by: kingofprussia
1 Replies

10. Programming

copying or concatinating string from 1st bit, leaving 0th bit

Hello, If i have 2 strings str1 and str2, i would like to copy/concatenate str2 to str1, from 1st bit leaving the 0th bit. How do i do it? (2 Replies)
Discussion started by: jazz
2 Replies
Login or Register to Ask a Question