Search results for query: *

Hi, Thanks for your help.This code is working most of scenario but getting different output in one case and breaks. Below scenario code is Working Code and giving correct output. exp:Source data CREATE TABLE ALU.ABCD_1 ( ABCD VARCHAR(64) NOT NULL , WXYZ NUMERIC(37,10) NOT NULL )...

Hi feherke, if i need to do a small change on the requirement like from 1st example if i want to get the data including the two parenthesis() then where need to change .As per your solution now the parenthesis not coming.So i want data in between from pattern and ; . i thnk its a samll...

Thanks...It is working now

Hi feherke,Thanks a lot .This is working and suits my requirement.Only thing the problem is AWK has to check for the exact pattern matching which is failing now. EXP: i have 2 pattern file XXX_ALUEUTRAN_DB.ABC XXX_ALUEUTRAN_DB.ABC_1 so in this case when the 1st...

Hi Feherke,Thanks this is working fine with my requirement.one small help on Now i need to include one more thing based on that pattern i need to grep from the below file and there will be only 1 entry in file but they may come in different styles like in single line or in 2 line or in 3 line...

Sure feherke but i am new to AWK and faced issues in this scenario.Other forum people with out listening the actual problem they close the thread. Here also i am facing while running your code .Based on the Given example it is working fine.But when i tested with real data it fails.i haven...

Hi , i want to retrive in between data from parenthesis and i a getting errors while run the awk.i have 2 files and want to process 1st file pattern to 2nd file. pattern_file.txt -------------- ABCD PQRS XYZ INPUT FILE.TXT ---------------- CRAETE TABLE ABCD ( A, B, C ); CREATE TABLE PQRS ( P...