Visit The New, Modern Unix Linux Community


Help with regular expression


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with regular expression
# 1  
Help with regular expression

OS version: RHEL 7.4
Shell : bash

I have a file which has lines like below. As you can see , they are SELECT queries.

Code:
SELECT * FROM  S_DEALER_USER WHERE ROWNUM < 100;
SELECT * FROM  S_DEALER_USER_WEB_PROFILE WHERE ROWNUM < 100;
SELECT * FROM  S_USER_ROLE_MASTER WHERE ROWNUM < 100;
SELECT * FROM  S_DEALER_USER_ROLE_MAP WHERE ROWNUM < 100;

The third field/word in each line needs to copied and printed on the top along with the PROMPT.

for example, if the line is "SELECT * FROM EMP WHERE ROWNUM < 100;" , then "PROMPT EMP" needs to printed on top of this line like below
Code:
PROMPT EMP
SELECT * FROM EMP WHERE ROWNUM < 100;


I have shown the expected output below. Any I idea how I can achieve this ?

-- expected output

Code:
PROMPT S_DEALER_USER
SELECT * FROM  S_DEALER_USER WHERE ROWNUM < 100;
PROMPT S_DEALER_USER_WEB_PROFILE
SELECT * FROM  S_DEALER_USER_WEB_PROFILE WHERE ROWNUM < 100;
PROMPT S_USER_ROLE_MASTER
SELECT * FROM  S_USER_ROLE_MASTER WHERE ROWNUM < 100;
PROMPT S_DEALER_USER_ROLE_MAP
SELECT * FROM  S_DEALER_USER_ROLE_MAP WHERE ROWNUM < 100;


Last edited by rbatte1; 03-07-2018 at 12:31 PM.. Reason: Changede ICODE to CODE tags
# 2  
Hello kraljic,

Could you please try following and let me know if this helps you.
Code:
awk '{print "PROMPT",$4 ORS $0}'   Input_file

Thanks,
R. Singh
These 2 Users Gave Thanks to RavinderSingh13 For This Post:
# 3  
It worked. Thank You Ravinder

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #254
Difficulty: Easy
'Steppenwolf' was the code name given to the first Apple Computer before it was announced publicly.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Regular expression

I would like to extract "JDBC Thin Client" from (PROGRAM=JDBC Thin Client); and "C:\Python26\python.exe" from (PROGRAM=C:\Python26\python.exe); "txm_v_awsrf_db.pr" from (PROGRAM=txm_v_awsrf_db.pr). if input line like "(PROGRAM=)", it return unknown. Would you help suggest a regular... (4 Replies)
Discussion started by: cstsang
4 Replies

2. Shell Programming and Scripting

Regular expression

Can someone please explain me what does this mean? ^{1,50}$ (1 Reply)
Discussion started by: Anupam_Halder
1 Replies

3. UNIX for Dummies Questions & Answers

Regular expression help

Hi, I am quite knew to scripting and I am trying to get a regular expression to work to check that a user enters a valid version number such as 1 or 1.1 or 12.3 etc. I dont seem to be able to get it to work as it picks up versions such as 1.......2. I only want it to work with a single dot.... (12 Replies)
Discussion started by: frodo61
12 Replies

4. UNIX for Advanced & Expert Users

sed: -e expression #1, char 0: no previous regular expression

Hello All, I'm trying to extract the lines between two consecutive elements of an array from a file. My array looks like: problem_arr=(PRS111 PRS213 PRS234) j=0 while } ] do k=`expr $j + 1` sed -n "/${problem_arr}/,/${problem_arr}/p" problemid.txt ---some operation goes... (11 Replies)
Discussion started by: InduInduIndu
11 Replies

5. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

6. Shell Programming and Scripting

Integer expression expected: with regular expression

CA_RELEASE has a value of 6. I need to check if that this is a numeric value. if not error. source $CA_VERSION_DATA if * ] then echo "CA_RELESE $CA_RELEASE is invalid" exit -1 fi + source /etc/ncgl/ca_version_data ++ CA_PRODUCT_ID=samxts ++ CA_RELEASE=6 ++ CA_WEEK_NO=7 ++... (3 Replies)
Discussion started by: ketkee1985
3 Replies

7. UNIX for Dummies Questions & Answers

ls with regular expression

I currently list and sort all the files in a directory which begin with an Upper Case C and end with the extension '#finished#'. Here is the command I use: ls -tr $currentDir/*.#finished# what i need to do now is list all the files in a directory that begin with upper case C and end... (3 Replies)
Discussion started by: rkgudde
3 Replies

8. Linux

Regular expression to extract "y" from "abc/x.y.z" .... i need regular expression

Regular expression to extract "y" from "abc/x.y.z" (2 Replies)
Discussion started by: rag84dec
2 Replies

9. Programming

What does the regular expression ['(^[^~]+~).*'] mean?

What does the regular expression +~).*'] mean while using it with regexec.When the string "RCHNUSNT35C~rs07/ASM-RS07" is used with the regular expression +~).*'] regexec gives an error. I know what regexec does,but i do not understand what this expression means wrt to this string... any help... (2 Replies)
Discussion started by: anupamar
2 Replies

10. Shell Programming and Scripting

Regular Expression + Aritmetical Expression

Is it possible to combine a regular expression with a aritmetical expression? For example, taking a 8-numbers caracter sequece and casting each output of a grep, comparing to a constant. THX! (2 Replies)
Discussion started by: Z0mby
2 Replies

Featured Tech Videos