Hi,
I have a file which looks like this, I have stripped most of the columns:
2006,UCA,"02452","NM","1","M","84",123,aa
2006,UCA,"02452","NM","1","L","84",123,bb
2006,UCA,"02452","NM","1","L","84",432,cc
2006,UCA,"02452","NM","1","L","33",213,dd
2006,UCA,"02452","NM","1","L","33",124,ee... (3 Replies)
Hi i have a file with follw data
"20090427","0","","16371311","-100200","","","","16371311","JUL","09"
In the 10th column i need to convert the month name into month number in this case JUL will be 7 and append the 10th and 11th column which shows me the output as 709. Can you suggest a shell... (11 Replies)
file1
----
34556745
32678343
31576776
31455566
21356666
I want to assign the record values to a variable in the below format, so that I can use output in .sql file for querying in database.
('34556745', '32678343', '31576776', '31455566', '21356666')
-----------
below is the... (11 Replies)
Hi! Is there a way to append column and row header to a file in awk script.
For example if I have
Jane F 39 manager
Carlos M 40 system administrator
Sam F 20 programmer
and I want it to be
# name gend age occup
1 Jane F 39 manager
2 Carlos M ... (4 Replies)
Hi,
Trying to change the prompt. I have the following code.
export PS1='
<${USER}@`hostname -s`>$ '
The hostname is not displayed
<abc@`hostname -s`>$ uname -a
AIX xyz 1 6 00F736154C00
<adcwl4h@`hostname -s`>$
If I use double quotes, then the hostname is printed properly but... (3 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
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"" CLAYTON AU"
The above value is for a single column but there are embedded quotes within... (2 Replies)
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2
Scenario 1
i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of... (1 Reply)
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT OSF1
dp
dp(8) System Manager's Manual dp(8)NAME
dp - parse dates RFC 822-style
SYNOPSIS
/usr/lib/mh/dp [-form file] [-format string] [-help] [-width columns] dates
OPTIONS
Overrides the default output format of dp. The output is formatted according to the instructions in the specified file. This must be a
format file; see mh-format(4). Overrides the default output format of dp. The output is formatted according to the instructions in the
specified string. This must be a format string; see mh-format(4).
The argument to the -format option must be interpreted as a single token by the shell that invokes dp. Therefore, you should usually
place the argument to this option inside double quotes ("). Prints a list of the valid options to this command. Specifies the
width of the screen in columns.
The defaults for this command are as follows:
-width defaults to the width of the terminal
DESCRIPTION
The dp command parses dates according to the ARPA Internet standard. It also understands many non-standard formats, such as those produced
by TOPS-20 sites and some UNIX sites using ctime(3). It is useful for seeing how MH will interpret a date.
The dp program treats each argument as a single date, and prints the date out in the official RFC 822 format. Hence, it is usually best to
enclose each argument in double quotes (") for the shell.
EXAMPLES
This is the default format string used by dp:
%<(nodate{text})error: %{text}%|%(pretty{text})%>
When an error is detected, this prints error: and the date that is in error. Otherwise, it outputs the proper RFC 822 format of the date.
FILES
User profile.
SEE ALSO
Commands: ap(8)
Standard for the Format of ARPA Internet Text Messages (RFC 822)
dp(8)