Read from file and split varialble


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read from file and split varialble
# 1  
Old 11-28-2016
Read from file and split varialble

Hello Experts,

Can anybody assist me in writing a code to do the following:

I have a file present in the same directory from where this cod would run. The content of the file would be as below:

Config Filename: config_details.txt
Format:
Server_prefix,IP_of_server,username, password, directory_path, file_name
Example:
Code:
S1,127.0.0.1,xyz_user1,xyz_password1, /home/xyz1/logs/,error.log
S2,127.0.0.1,xyz_user2,xyz_password2, /home/xyz2/logs/,error.log

  1. Read the file config_details.txt in loop and go through the records in the file from second line onwards.
  2. Login to the server based on the IP address, username, password provided in the config_details.txt file.
  3. Go to the path as mentioned in directory_path.
  4. Copy the file e.g. error.log to the local directory.
  5. Move to the next server details in the config_Details.txt file and repeat step 1to 5.

There are other steps involved in this script which I have managed to do already. I can read from the file using below code. But I cannot read the variables e.g.server name or username etc from the file. It is either full line or nothing.

Code:
while read line; do echo $line; done > config_details.txt


Any help would be appreciated.


Thanks
Chetan



Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
DON'T use FONT and SIZE that abundantly!

Last edited by rbatte1; 11-28-2016 at 08:53 AM.. Reason: RudiC: Added CODE tags and removed FONT and SIZE tags. ; rbatte1: Converted text numbered list to formatted numbered list
# 2  
Old 11-28-2016
Looks like you want to write a shell script; for which shell? e.g. bash or ksh allow to read individual variables from a line in a file, and, on top, to define the field separator, in your above case a comma.
But, most importantly, you should redirect the stdin file descriptor using < , NOT the stdout fd like you do.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Read Table in file and split

HELLO I need your help please , i need to read a file that contain a table like : Name | Status ------------------ DB 1 | UP DB 2 | UP DB 3 | DOWN DB 4 | UP DB 5 | UP the objective to read each line and check if DB is UP or Down and give me the name of Down database.... (10 Replies)
Discussion started by: Abdellah
10 Replies

2. Shell Programming and Scripting

Read a File line by line and split into array word by word

Hi All, Hope you guys had a wonderful weekend I have a scenario where in which I have to read a file line by line and check for few words before redirecting to a file I have searched the forum but,either those answers dint work (perhaps because of my wrong under standing of how IFS... (6 Replies)
Discussion started by: Kingcobra
6 Replies

3. Shell Programming and Scripting

How to read and Split a file?

Hi, I have a .csv file which I want to split into smaller files as .csv format only Thanks in advance. (26 Replies)
Discussion started by: azherkn3
26 Replies

4. Shell Programming and Scripting

Read from file and execute the read command

Hi, I am facing issues with the below: I have a lookup file say lookup.lkp.This lookup.lkp file contains strings delimited by comma(,). Now i want to read this command from file and execute it. So my code below is : Contents in the lookup.lkp file is : c_e,m,a,`cd $BOX | ls cef_*|tail... (7 Replies)
Discussion started by: vital_parsley
7 Replies

5. UNIX for Dummies Questions & Answers

When reading a csv file, counter to read 20 lines and wait for minute then read next 20 till end

Hello All, i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file. Any inputs are appreciated ... (3 Replies)
Discussion started by: victor.s
3 Replies

6. UNIX for Dummies Questions & Answers

Writing awk script to read csv files and split them

Hi Here is my script that calls my awk script #!/bin/bash set -x dir="/var/local/dsx/csv" testfile="$testfile" while getopts " f: " option do case $option in f ) testfile="$OPTARG";; esac; done ./scriptFile --testfile=$testfile >> $dir/$testfile.csv It calls my awk... (1 Reply)
Discussion started by: ladyAnne
1 Replies

7. Shell Programming and Scripting

PHP read large string & split in multidimensional arrays & assign fieldnames & write into MYSQL

Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP. I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Discussion started by: lowmaster
0 Replies

8. Programming

Cannot read a file with read(fd, buffer, buffersize) function

# include <stdio.h> # include <fcntl.h> # include <stdlib.h> # include <sys/stat.h> int main(int argc, char *argv) { int fRead, fPadded, padVal; int btRead; int BUFFSIZE = 512; char buff; if (argc != 4) { printf ("Please provide all of the... (3 Replies)
Discussion started by: naranja18she
3 Replies

9. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this. For example: split -l 3000000 filename.txt This is very slow and it splits the file with 3 million records in each... (10 Replies)
Discussion started by: madhunk
10 Replies

10. Shell Programming and Scripting

Varialble in pipelines

Hi, As per shell docs because commands in pipelines are run as separate processes, variables set in a pipeline have no effect on the parent shell In the sample below I am unable to set variable in Proc1 so that I can see it in the main program Is there any work around ? Thanks Zam... (4 Replies)
Discussion started by: zam
4 Replies
Login or Register to Ask a Question