Search Results

Thanks Chubler,

You have written both o/p in single query , but our requirement is to pass the delimited value and position as a paramter and get respective result.

Example:
Input parameter...

Hi All,

We have a requirement of picking nth position value by using cut command. value would be delimited by any symbols. We have to pass delimited value and postition to get the value in a...

If values other than JE are at the start of records that need to be removed, how are those records identified?

Do you always want to remove every line that starts with a J?
No, we need to remove...

we are using the following version of os version

Linux uklvaucup01a 2.6.32-696.3.2.el6.x86_64 #1 SMP Wed Jun 7 11:51:39 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux

Your question :
Do you always...

Hi Experts,

we have a requirement , need your help to remove the footer record in the file.

Input file :

1011070375,,21,,NG,NG,asdfsfadf,1011,,30/09/2017,ACI,USD,,0.28,,,,,,,,,,,,...

Hi ,

It working fine. last character of double quotes are converted in to §. we need only double dollar are falling in value not at the end of the line. if double quotes falls first and last of...

The below code, i have tried to execute in putty.

awk '{for(i=1; i<=NF; i++) {gsub(/^"|"$/,"^",$i); gsub(/"/,"§",$i)}}1' FS=\~ OFS=\~ file.txt

Sorry for didn't mention in OS version.
the below version we are using .
Red Hat Enterprise Linux Server release 6.8 (Santiago)

Kindly help us to accomodate the query with above versions.

Hi, Thanks for your quick respod.
when i try to execute the command. it is showing syntax error

-ksh: syntax error: `)' unexpected

Hi Team,

We have requirement , we are trying to load the txt format file via sqlloader, we are facing issue like double quotes " are falling inside the value . so sqlloader fails to load the file....

Hi all,

we have a requirement , we need to check the files availability in the unix folder and their record counts need to be emailed as attached format

Files Count
File_1 123
File_2 1898...

If i use in sql file ,we cant get the result and assign in sqlid variable

Hi All,

we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference.

get_sqlid ()
{
sqlid=$(
sqlplus -s...

Hi All,


we have a requirement to split a content in a text file every 5 rows and write in a new file .

conditions:

if 5th line falls between center of the statement . it should look upto...