Search Results

Thank you

I have a file with some SQL query, I want to fetch only Table Name from that file line by line.

INPUT FILE
SELECT * FROM $SCHM.TABLENAME1;
ALTER TABLE $SCHM.TABLENAME1 ADD DateOfBirth date;...

just check both the file are same, just content was different.
but still code is not working.
It's not a different pattern.

---------- Post updated at 03:33 PM ---------- Previous update was at 03:33 PM ----------

Thank you, Code is working fine with above file, but i have another file, and this code is not work with...

I want a string between two delimeter like " " from below file and also send send output to the file.

Input File,

2007_08_07_IA-0100-014_"January".PDF
2007_08_07_IA-0100-031_"January...

Thank you. I need one more help, I have another file with just delimeter change( ) to " ".
so in this code where i have to change?

yes this file names in different lines.

I want a string between two delimeter like ( ) from file.

Input File,
2007_08_07_IA-0100-014_(January).PDF
2007_08_07_IA-0100-031_(January February March
April June July).PDF ...