Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to use sed to insert character in the beginning of file path?
Top Forums UNIX for Beginners Questions & Answers How to use sed to insert character in the beginning of file path? Post 303039269 by duke0001 on Friday 27th of September 2019 04:28:19 PM
Old 09-27-2019
How to use sed to insert character in the beginning of file path?
I need to manipulate one Database file on Solaris 11 in which contains more than 5000 lines of data file path like this:

Code:
 '/data1/oradata/DBNAME/system01.dbf',
  '/data7/oradata/DBNAME/undotbs1_01.dbf',
  '/data1/oradata/DBNAME/sysaux01.dbf',
  '/data28/oradata/DBNAME/userdata01.dbf',
  '/data28/oradata/DBNAME/user_data01.dbf',
  '/data128/oradata/DBNAME/undotbs1_02.dbf',
................................................
  '/datadw29/oradata/DBNAME/corp/comm_sd37.dbf',
  '/datadw28/oradata/DBNAME/corp/comm_sd38.dbf',
.................................................................................................
  '/dataidxdw42/oradata/DBNAME/ods/ODS_DATA_IDX_07.dbf',
  '/dataidxdw42/oradata/DBNAME/ods/ODS_DATA_IDX_08.dbf'

,

In these path lines, the first part of path name contains number '/data28/ and three path group with different first part of name. I need to insert one path name: "bck1" in the beginning of each path name. After manipulation, the path name in the file should be like this:

Code:
 '/bck1/data1/oradata/DBNAME/system01.dbf',
  '/bck1/data7/oradata/DBNAME/undotbs1_01.dbf',
  '/bck1/data1/oradata/DBNAME/sysaux01.dbf',
  '/bck1/data28/oradata/DBNAME/userdata01.dbf',
  '/bck1/data28/oradata/DBNAME/user_data01.dbf',
  '/bck1/data128/oradata/DBNAME/undotbs1_02.dbf',
................................................
  '/bck1/datadw29/oradata/DBNAME/corp/comm_sd37.dbf',
  '/bck1/datadw28/oradata/DBNAME/corp/comm_sd38.dbf',
.................................................................................................
  '/bck1/dataidxdw42/oradata/DBNAME/ods/ODS_DATA_IDX_07.dbf',
  '/bck1/dataidxdw42/oradata/DBNAME/ods/ODS_DATA_IDX_08.dbf'

I tried to use "v"i editor and "sed" to insert first part of path name. it can work on some lines and could not globally make change. I want to learn how to use "sed" to globally update the file path and deal with different number in path name and with different path name. Please help to provide your advice and command here. I will test and come back to report progress. Thanks for your time and help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding a character in the beginning of every line in a .dat file

How can i add a character(#) in the beginning of every line in a .dat file (2 Replies)
Discussion started by: Cool Coder
2 Replies

2. UNIX for Dummies Questions & Answers

How can I insert character to end of file?

Hello all How can I insert character to the end of text file without opening it in vi Just simple one liner, can it be done? Tnx (1 Reply)
Discussion started by: umen
1 Replies

3. Shell Programming and Scripting

Insert two strings at the beginning and at the end of each line of a file

Hi, excuse me for my poor english. My problem is that: I have a File i want to add to each line of that file two strings: one at the beginning of the line, one at the ending. string1="abcd" string2="efgh" i want $string1 content $string2 for each line. Is that possible? (3 Replies)
Discussion started by: Linux-fueled
3 Replies

4. UNIX for Dummies Questions & Answers

Remove words beginning with a certain character from a file

Hi, how could you go about removing words that begin with a certain character. assuming that this character is '-' I currently have echo "-hello" | sed s/-/""/ which replaces the leading dash with nothing but I want to remove the whole word, even if there are multiple words beginning... (3 Replies)
Discussion started by: skinnygav
3 Replies

5. Shell Programming and Scripting

Need to insert text(constant) at the beginning of file

I am very new to scripting and I know this request is simple but I am having no luck with it. I have a file a.dat with the following data in it. aa bb cc dd I need to run a script that will take each line of a.dat and put dsjc/ubin/ in front of each record, so the output looks like ... (2 Replies)
Discussion started by: jclanc8
2 Replies

6. Shell Programming and Scripting

SED - insert space at the beginning of line and multi replace command

hi I am trying to use SED to replace the line matching a pattern using the command sed 'pattern c\ new line ' <file1 >file 2 I got two questions 1. how do I insert a blank space at the beginning of new line? 2. how do I use this command to execute multiple command using the -e... (5 Replies)
Discussion started by: piynik
5 Replies

7. Shell Programming and Scripting

Insert output from a file to beginning of line with sed

Hi I've been trying to search but couldn't quite get the answer I was looking for. I have a a file that's like this Time, 9/1/12 0:00, 1033 0:10, 1044 ... 23:50, 1050 How do I make it so the file will be like this? 9/1/12, 0:00, 1033 9/1/12, 0:10, 1044 ... 9/1/12, 23:50, 1050 I... (4 Replies)
Discussion started by: diesel88
4 Replies

8. Shell Programming and Scripting

sed to insert a character

Hi all, I have a file like this Q8N302 21-84 Q8N157 15-45 Q99996 167-201 202-251 269-318 I want to insert a character or space if the line starts with a number and I used the command sed 's/^/#/' But in the output file, when it inserts this character, first digit in the number is... (2 Replies)
Discussion started by: kaav06
2 Replies

9. Shell Programming and Scripting

sed - replacement file path with variable - Escaping / character

Hi,, I have the line below in a file: $!VarSet |LFDSFN1| = '"E:\APC\Trials\20140705_427_Prototype Trial\Data\T4_20140705_Trial_Cycle_Data_13_T_Norm.txt" "VERSION=100 FILEEXT=\"*.txt\" FILEDESC=\"General Text\" "+""+"TITLE{SEARCH=NONE NAME=\"New Dataset\" LINE=1I want to write a script to change... (2 Replies)
Discussion started by: carlr
2 Replies

10. UNIX for Advanced & Expert Users

Insert a column in the beginning

Hi, I have been trying to see how i can insert a column in the beginning to my html table This is how it looks Name Age Sid 32 John 33 Mary 34 I want to insert a column Job before Name column, so it looks like Job Name Age IT Sid 32 Doctor... (3 Replies)
Discussion started by: sidnow
3 Replies

LEARN ABOUT DEBIAN

smd-client

smd-client(1)						 Sync Mail Dir (smd) documentation					     smd-client(1)

NAME

       smd-client - receives diffs and performs actions

SYNOPSIS

       smd-client [-v|--verbose] [-d|--dry-run] [-t|--translator]
	     [-l|--local-sync] [--rename-only]
	     [--override-db dbf] endpoint mailboxes

DESCRIPTION

       smd-client needs to know a name (endpoint) for the client (that must not be used by others) and a list of mailboxes (directories).

       smd-client  waits  on  stdin  a mail dir diff. It attempts to execute these actions, eventually asking data printing commands on stdout and
       expecting the data on stdin.

OPTIONS

       -t --translator
	      Specify a program to translate remote mailbox names to local ones. Note that the translator 'cat' (the identity  program)  is  opti-
	      mized away

       -l --local-sync
	      Local synchronization, no changes is made to the db-file since smd-server takes care of it

       --rename-only
	      Do not synchronize the mailboxes but generate the script '~/smd-rename.sh' to uniform the files names in the mailbox

       --override-db dbf
	      Use dbf as the db-file

       -v --verbose
	      Increase program verbosity (printed on stderr)

       -d --dry-run
	      Do not perform any action for real

NOTES

       smd-client is a low level utility. You should use higher level tools like smd-pull(1) and smd-push(1)

SEE ALSO

       mddiff(1), smd-server(1), smd-pull(1), smd-push(1)

AUTHOR

       Enrico Tassi <gares@fettunta.org>

								   11 June 2012 						     smd-client(1)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy