Search Results

Delete

It is against our forum rules you agreed to remove your posts, for that you have been banned!



After 13 years, not once you did the effort of showing an attempt in finding a...

Delete

---- Original post, restored by mod after being deleted by abhilashnair ----
I have a requirement where, I need to create a control file which will have 3 columns in the header row as...

The above code worked perfectly.

(|) will never appear inside a quoted field. it is the delimiter, so acts like a separator between 2 columns

I tried the code, it is removing the consecutive quotes but it is also removing the empty strings, which I don't want because that is a perfectly valid value

I need to replace consecutive double quotes in a csv file, the data in the file is enclosed in double quotes but there are some places where the quotes are repeating
Example is below

Incoming...

I want to know how this command output will be

sed 's/^"\(.*\)"$/\1/' <filename>

There are no leading spaces in the script. Must have come when I pasted the code into this thread

I want my new script to do the opposite of what the current script is doing

I need it to Not...

AIX
ksh
Oracle
Access using sqlplus within script
Database field contains file pattern not file name and in another column it contains absolute path

age of file to be determined by...

I have a requirement where I need parse through files in a directory which have a specific pattern and then check whether the file has been processed or not. The exit condition is any file that has...

I have a EBCDIC multi layout file which has a header record which is 21 bytes, The Detail records are 2427 bytes long and the trailer record is 9 bytes long.

Is there a command to remove the...

awk '{$0=$0 ~ /\|\r\n$/?$0:$0"|\r\n"} 1' filename>output

worked for me

I need to append |\r\n (a pipe character and CRLF) at end of each record in Unix to all records where they are not already present.

So first check for the presence of |\r\n and if absent append it...

I am on AIX system and the file has been pushed to this from Mainframe

Please advise how can I proceed in this case

Is there any command to eliminate Header and footer from EBCDIC file

I have a text file where each field is enclosed in double quotes and separated by a comma.
But in certain rows we have embedded double quotes within column data

For e.g

"""TRUSPICE CENTRE"" ...

Thanks, the awk command worked for me.

I have a text file in which all records end with pipe character and newline, but a few do not have a pipe at the end.

Something like this

1|John|32|US|
2|Matt|35|UK
3|Rex|36|EU|


So in...

Sample records

1 1 InPayANZ 12.0000 NZD NOW 011179099848025

2 2 InPayNonANZ 25.0000 NZD ...

I am trying to omit the trailer record in a variable width file

I tried using awk 'NR >1 { print prev } { prev = $0 }' filename

The above command is giving output but somehow it is trimming...

It is not working even when I give actual email ids in the place of variables

I am facing a peculiar problem in AIX 6.1
I can execute sendmail command using the following script

sendmail -f sender -v recepient
Body of email
^dThe command executes successfully and mail is...

Hi All,
I need a basic overview of connecting a HTML web page to Unix
I will give a brief of my exact requirement.
There will be a front end HTML page - a web page which will have certain buttons....

It works. But it also returns many other lines not at all related to the filename which I am giving as input
for eg: if i give command as find /home -name abc.dat it returns the output as given...

What is the command to find the path of a file if we know the file name and the root directory where the file resides..

For eg. if a file abc.dat resides in /home/mydir/myfiles/. I am looking for...