Replace variable value from inputfie


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace variable value from inputfie
# 1  
Old 02-06-2009
Replace variable value from inputfie

I have file (which is output of different script.)

Code:
int hsi foram

inst2.sysadmin
inst2.sysusers
inst2.syslogins
inst2.sysauth

Like so many lines.


This output is input to another script.
I want to have only table name not schemaname.

how can I do it?

Thanks in advance.

Last edited by Neo; 02-29-2020 at 12:58 AM..
# 2  
Old 02-06-2009
Question what are the fields

For example, given the following:

Code:
inst2.sysauth

Is this what how you define your fields?
tablename= inst2
schemaname= sysauth
# 3  
Old 02-06-2009
I don't need the schema name at all in second script.

Last edited by newbie22102; 02-06-2009 at 05:28 PM..
# 4  
Old 02-06-2009
deleted
# 5  
Old 02-06-2009
Deleted
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace string in variable?

Hello, I have simple while and for loops in a shell script and I would like to replace some characters in COL2 when I run it. I am on ubuntu 14.04 while read COL1 COL2 COL3 COL4 do name=$COL2 #cat $name | sed -i "s|_| |g" $name for i in $COL3 $COL4 do some codes ...... run $i b="$name"... (11 Replies)
Discussion started by: baris35
11 Replies

2. UNIX for Dummies Questions & Answers

Search and replace with variable

Hello all, I stumbled upon a command line for multiple search and replace within given destination perl -pi -w -e 's/SEARCH_FOR/REPLACE_WITH/g;' *.html I want to replace the following line where the date is the variable, from <div class="meta"> <ul> <li>05.05.2015 with date tags, like... (5 Replies)
Discussion started by: uninuub
5 Replies

3. Shell Programming and Scripting

Sed/replace using variable

Hello everyone, In one of my shell script I am doing sed/replace using a variable to find a string in a file & replace it with another string in same file. The challenge which I am facing is that, the variable which I am using with "sed" is having one of character as "/" Here is below how... (4 Replies)
Discussion started by: gr8_usk
4 Replies

4. Red Hat

How to pass value of pwd as variable in SED to replace variable in a script file

Hi all, Hereby wish to have your advise for below: Main concept is I intend to get current directory of my script file. This script file will be copied to /etc/init.d. A string in this copy will be replaced with current directory value. Below is original script file: ... (6 Replies)
Discussion started by: cielle
6 Replies

5. Shell Programming and Scripting

Replace variable with its value while printing

Hi I have a file in which there is list of files. eg: $path1/file1 $path1/file2 $path2/file3 I am trying to read this file in other script.However the value of variable i.e. $path1 and $path2 is not replaced by its value. How to do it ? I am trying: while read line do echo... (2 Replies)
Discussion started by: dashing201
2 Replies

6. Shell Programming and Scripting

How to partially replace variable value?

I have variable $2 whose value is expdp_SDW_MSTR_VMDB.par I want to replace three characters from right (par) with (log) Input --> expdp_SDW_MSTR_VMDB.par Output --> expdp_SDW_MSTR_VMDB.log Thanks Deep (2 Replies)
Discussion started by: deep.singh
2 Replies

7. Shell Programming and Scripting

How to replace variable inside the variable

hi sir, i need your help for this script inside /rnmucdr/ednms05/ken/xMNBDF045_Script.sql content variable like this select * from invoice where bill_date=$BILLDATE and startNum=$STARTPARTNNUM and total_partn=$TOTALPARTN if i just paste this replace with the $SCRIPT it works great,if... (31 Replies)
Discussion started by: mani_um
31 Replies

8. Shell Programming and Scripting

find and replace variable

Is there an easy way of doing this cat file1 jkasjhjgfg LTRIM(RTRIM(aa_bb_cde)) aragsfdg LTRIM(RTRIM(aa_bb_cde)) aregfafdgfg sdgsfdagdfg gadfg eafgsadgsa asdgsfdgag LTRIM(RTRIM(aa_bb_cde)) rfghsdfhd I want to replace each occurence of LTRIM(RTRIM($x)) with LENGTH(LTRIM(RTRIM($x)))=0... (4 Replies)
Discussion started by: alfredo123
4 Replies

9. Shell Programming and Scripting

Replace variable with a user defined variable

I have a file that has a list of entries in a column x z z z x y z The column can have any length and any number of any strings. I need to replace each unique string with a user defined number. I can filter the unique entries out using awk '{if (NF==5) print $2}' file | uniq | nl >... (1 Reply)
Discussion started by: ce124
1 Replies

10. Shell Programming and Scripting

How to replace a variable content

Hi, variable1="This is a car" Now I want to replace the content of variable1, "car" to "dog". Is there any simple command I can use. Thanks. Joseph (4 Replies)
Discussion started by: josephwong
4 Replies
Login or Register to Ask a Question