Search Results

Hi Chubler_XL,

Thank you for the answers.

Thanks,
Chill3chee.

Greetings Experts,

I am working for a bank client and have a question on connect-direct and SFTP.

We are using Linux RedHat servers. We use connect-direct to transfer (NDM) files from one...

Thank you RudiC and MadeInGermany. That works. Just wanted to know that during reading $2 is 0e123456789 but why does awk interpret $2 to 0 i.e., process $2 as scientific notation during ! $2 in...

Greetings Experts,
We are migrating from AIX to RHEL Linux. I have created a script to verify and report the NULLs and SPACEs in the key columns and duplicates on key combination of "|" delimited...

Excellent Scrutinizer. You saved me :) There was already an existing script written by someone. So, re-used it by modifying the needed ones. Your suggestion worked perfectly. Again, thank you.

Greetings Experts,
I am on AIX using ksh; I am processing the input files and generating a awk_output.txt file using AWK. By reading that awk_output.txt file, I am building a output.html file ...

Thank you Ravinder Singh, RudiC, Don Cragun, Bakunin for your inputs. Have used the RudiC's suggestion along with Don's excellent considerations. The error I was facing for
sed "/$line/ s/^/--/g"...

Hi RudiC/Ravinder Singh,
The file1 specified in the above is sql file generated after applying modifications to the template file. Now file1.txt had to be run in Oracle whose sample contents are ...

Greetings Experts,
I am on AIX and in process of creating a re-startable script that connects to Oracle and executes the statements. The sample contents of the file1 is
CREATE OR REPLACE VIEW...

Thank you Yoda, that did it :)

Hi Vgersh99,

Thank you for your time. But the file ${drctry}/${v_timestamp}_sql_primary_log.txt content is empty. Did I miss something here please.. However, I did see the contents in another...

Greetings Experts,

I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to...

That was absolutely brilliant. Thank you RudiC :)

Hi MadeInGermany,

Thank you for the suggestion. Creating one more array to count the combination of $1 OFS $4 OFS $7 and then I need to find a way to go through this algorithm
for (i in a) {...

Hi Bhupesh,
For the comparison, can you please check whether the following does meet your need (untested)
awk '
BEGIN {FS = "\n"
OFS = ","
RS = ""
}
{trn=$1;nm=$2;tme=$3;msg=$4;...

Greetings Experts,
I am generating a validation query through awk and facing an issue, which I need to overcome by splitting the data based on the pattern matching count in the value of an array....

Learning awk and sed through the valuable posts in the forum. Just curious on how to achieve this through sed. Thank you RudiC, request you to please explain the code..

Greetings Experts,
I need to pass a parameter to ksh and the value is windows path eg: sh abc.txt C:\Users\chill3chee\Desktop

No matter I try with \ delimiter, still could not get this exact...

Greetings Experts,
I am in AIX; I have a file generated through awk after processing the input files. Now I need to replace or remove the new-line characters on all lines that doesn't have a ;...

I aligned your post to suit my requirement and works great. As always, awesome and thank you RudiC.
I have a small question here. My script uses 2 input files is facing issues when reading the...

Greetings Experts,
Issue: Within awk script, remove the duplicate occurrences that are space (1 single space character) separated

Description: I am processing 2 files using awk and during...

Greetings experts,
Have 2 input files, of which 1 file has 1 record per line; in 2nd file, multiple lines constitute 1 record; Hence declared the RS=";"
Now in the first file which ends with ";"...

Hi MadeinGermany,
The NR is same for both the FS="@"and FS="[@]" However the NF differs in the above cases; as you specified for FS="@"it is treating line feeds as a delimiter. Thanks again

Thank You MadeInGermany; The first solution did work; however the second solution did produce the same output as my post (not able to recognize ; as RS) Can you please explain how [@] different is...

Greetings Experts,

As part of automating the sql generation, I have the source table name, target table name, join condition stored in a file join_conditions.txt which is a delimited file (I can...