Sponsored Content
Top Forums Shell Programming and Scripting Search for a pattern in a file and split the line into two lines Post 302957519 by Pradhikshan on Monday 12th of October 2015 11:50:19 AM
Old 10-12-2015
Search for a pattern in a file and split the line into two lines

Hi All,

Greetings everyone !!!

I have a file which has many lines, out of which one line is as below.

Quote:
declare @newname varchar(30) Select @newname = filename from table_bck
I need to search for pattern "varchar(30) Select" and if exists, then split the line as below.

Quote:
declare @newname varchar(30)
Select @newname = filename from table_bck
I am trying to achieve this in ksh. Can anyone help me on this.

Last edited by Pradhikshan; 10-12-2015 at 01:08 PM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search file for pattern and grab some lines before pattern

I want to search a file for a string and then if the string is found I need the line that the string is on - but also the previous two lines from the file (that the pattern will not be found in) This is on solaris Can you help? (2 Replies)
Discussion started by: frustrated1
2 Replies

2. Shell Programming and Scripting

Split File Based on Line Number Pattern

Hello all. Sorry, I know this question is similar to many others, but I just can seem to put together exactly what I need. My file is tab delimitted and contains approximately 1 million rows. I would like to send lines 1,4,& 7 to a file. Lines 2, 5, & 8 to a second file. Lines 3, 6, & 9 to... (11 Replies)
Discussion started by: shankster
11 Replies

3. Shell Programming and Scripting

Search a pattern in a file with contents in a single line

Hi all I am searching for a pattern in a file . The file content is in a single line.If am doing a grep or sed for the a particular pattern am getting whole file. I want the result in different lines. attaching the file for reference search pattern "/xxxxxx/hhhh/tttttttt/sss/" and... (4 Replies)
Discussion started by: sparks
4 Replies

4. Shell Programming and Scripting

Search for a pattern in a file and print previous lines from a particular point

Hi, I am new to ksh scripting and I have a problem. I have a file in which I have to search for a particular pattern say 'a' then from that line I need to search for another pattern say 'b' in the previous lines and thne print the file from pattern 'b' till the end of file. For eg: ... (2 Replies)
Discussion started by: umaislearning
2 Replies

5. Shell Programming and Scripting

Grep the word from pattern line and update in subsequent lines till next pattern line reached

Hi, I have got the below requirement. please suggest. I have a file like, Processing Item is: /data/ing/cfg2/abc.txt /data/ing/cfg3/bgc.txt Processing Item is: /data/cmd/for2/ght.txt /data/kernal/config.klgt.txt I want to process the above file to get the output file like, ... (5 Replies)
Discussion started by: rbalaj16
5 Replies

6. Shell Programming and Scripting

Search for a pattern,extract value(s) from next line, extract lines having those extracted value(s)

I have hundreds of files to process. In each file I need to look for a pattern then extract value(s) from next line and then search for value(s) selected from point (2) in the same file at a specific position. HEADER ELECTRON TRANSPORT 18-MAR-98 1A7V TITLE CYTOCHROME... (7 Replies)
Discussion started by: AshwaniSharma09
7 Replies

7. Shell Programming and Scripting

Search pattern and write line into another file

Hi, I have a file which contains the below details.. My requirement is to fetch all the lines which are starting with "ABC_XY_" into 1 file and rest of the lines (not starting with "ABC_XY_") into another file. Could you please help with what command needs to be used? file1.txt ----------... (12 Replies)
Discussion started by: satyaatcgi
12 Replies

8. Shell Programming and Scripting

How to split a file based on pattern line number?

Hi i have requirement like below M <form_name> sdasadasdMklkM D ...... D ..... M form_name> sdasadasdMklkM D ...... D ..... D ...... D ..... M form_name> sdasadasdMklkM D ...... M form_name> sdasadasdMklkM i want split file based on line number by finding... (10 Replies)
Discussion started by: bhaskar v
10 Replies

9. UNIX for Beginners Questions & Answers

Reading a file line by line and print required lines based on pattern

Hi All, i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field. i am using centos 7 Operating system. want to read below file. # cat /tmp/d5 NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Discussion started by: balu1234
4 Replies
RENAME(3)								 1								 RENAME(3)

rename - Renames a file or directory

SYNOPSIS
bool rename (string $oldname, string $newname, [resource $context]) DESCRIPTION
Attempts to rename $oldname to $newname, moving it between directories if necessary. If $newname exists, it will be overwritten. PARAMETERS
o $oldname - Note The old name. The wrapper used in $oldname must match the wrapper used in $newname. o $newname - The new name. o $context - Note Context support was added with PHP 5.0.0. For a description of contexts, refer to "Streams". RETURN VALUES
Returns TRUE on success or FALSE on failure. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.3.1 | | | | | | | rename(3) can now rename files across drives in | | | Windows. | | | | | 5.0.0 | | | | | | | rename(3) can now also be used with some URL | | | wrappers. Refer to "Supported Protocols and Wrap- | | | pers" for a listing of which wrappers support | | | rename(3). | | | | | 4.3.3 | | | | | | | rename(3) may now be able to rename files across | | | partitions on *nix based systems, provided the | | | appropriate permissions are held. Warnings may be | | | generated if the destination filesystem doesn't | | | permit chown() or chmod() system calls to be made | | | on files -- for example, if the destination | | | filesystem is a FAT filesystem. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 Example with rename(3) <?php rename("/tmp/tmp_file.txt", "/home/user/login/docs/my_file.txt"); ?> SEE ALSO
copy(3), unlink(3), move_uploaded_file(3). PHP Documentation Group RENAME(3)
All times are GMT -4. The time now is 11:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy