09-29-2009
How to convert a column to last five digits
Hi
Suppose I have a input.csv file like this
Fort, 2034440-3333
Honda, b293489289
Toyota, 23423000
How to convert the second column to the following format, there are only two cases:
a.if the last five character is a hyphen plus four numeric digit, keep the the last five digits before the hypen as well as everything after hyphen (including hyphen).
b. if the last five character doesn't contain a hyphen, keep the last five digits.
so the output.csv is:
Fort, 34440-3333
Honda, 89289
Toyota, 23000
Thanks, I guess this will be done in awk but I have no idea how to do it.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file:
2009_11
3455 500
5355 600
7777 700
The first line is the period. I want to concatenate the Period into every line using a one line command..I guess maybe awk or something. So the output would look like this:
3455 500 2009_11
5355 600 2009_11
7777 700 2009_11
... (4 Replies)
Discussion started by: alfredo123
4 Replies
2. Shell Programming and Scripting
Hi Folks
Probably an easy one here but how do I get a sequence to get used as mentioned. For example in the following I want to automatically create files that have a 2 digit number at the end of their names:
m@pyhead:~$ for x in $(seq 00 10); do touch file_$x; done
m@pyhead:~$ ls file*... (2 Replies)
Discussion started by: amadain
2 Replies
3. Shell Programming and Scripting
Hi
I got this:
aix.acct,aix.system.config.cron,aix.system.config.src,aix.system.install,string2
and
I want this:
aix.acct
system.config.cron
aix.system.config.src
aix.system.install
string2
I tried using sed by changing ',' into an 'ENTER' but I couldn't. :-(
thxs (2 Replies)
Discussion started by: iga3725
2 Replies
4. Shell Programming and Scripting
Hello all! I've looked all over the internet and this site and have come up a loss with an easy way to make a bash script to do what I want to do. I have a file with a naming convention as follows:
2012-01-18 string of words here 123.jpg
2012-01-18 string of words here 1234.jpg
2012-01-18... (2 Replies)
Discussion started by: Buzzman25
2 Replies
5. Shell Programming and Scripting
Input file A.txt :-
C2062 -117.6 -118.5 -117.5
C5145 0 0 0
C5696 0 0 0
Output file B.txt
C2062 X -117.6
C2062 Y -118.5
C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies
6. Shell Programming and Scripting
Hello Guy's
Quick question which im sure many can answer in seconds. Basically I have a perl script which is running commands to an element and then taking some of the
the output and printing it to the screen. One of the outputs is a variable Hex Number. What I would like to do is strip... (1 Reply)
Discussion started by: mutley2202
1 Replies
7. Shell Programming and Scripting
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies
8. Shell Programming and Scripting
Hi,
I need to convert my text file into a sort of matrix form. my input file has 5 columns. $2 and $4 will be ignored and omitted from output, while $3 need to be re-arranged horizontally on top:-
Akd1 aa233 Akd1 545 524.2
jlk01 aa233 Akd1 90 447
mht5 ... (2 Replies)
Discussion started by: redse171
2 Replies
9. Programming
Dear Team
We use DB2 v10.5 and using DBArtisan tool
Can someone please guide how to convert digits to binary numbers using db2 feature.
Ex> for number 9 , binary should be 1001 ( 8+1)
Any help appreciated. Thanks (2 Replies)
Discussion started by: Perlbaby
2 Replies
10. UNIX for Beginners Questions & Answers
Hi All ,
I am having an input file as stated below
5728 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r03_q_reg_20_/Q 011
611 U_TOP_LOGIC/U_CM0P/core/u_cortexm0plus/u_top/u_sys/u_core/r04_q_reg_20_/Q 011
3486... (4 Replies)
Discussion started by: kshitij
4 Replies
LEARN ABOUT SUNOS
dfshares_nfs
dfshares_nfs(1M) System Administration Commands dfshares_nfs(1M)
NAME
dfshares_nfs - list available NFS resources from remote systems
SYNOPSIS
dfshares [ -F nfs] [-h] [server...]
DESCRIPTION
dfshares provides information about resources available to the host through NFS. The -F flag may be omitted if NFS is the first file sys-
tem type listed in the file /etc/dfs/fstypes.
The query may be restricted to the output of resources available from one or more servers.
dfshares without arguments displays all resources shared on the local system, regardless of file system type.
Specifying server displays information about the resources shared by each server. Server can be any system on the network. If no server
is specified, then server is assumed to be the local system.
The output of dfshares consists of an optional header line (suppressed with the -h flag) followed by a list of lines containing whitespace-
separated fields. For each resource, the fields are:
resource server access transport
where
resource Specifies the resource name that must be given to the mount(1M) command.
server Specifies the system that is making the resource available.
access Specifies the access permissions granted to the client systems; however, dfshares cannot determine this information
for an NFS resource and populates the field with a hyphen (-).
transport Specifies the transport provider over which the resource is shared; however, dfshares cannot determine this information
for an NFS resource and populates the field with a hyphen (-).
A field may be null. Each null field is indicated by a hyphen (-) unless the remainder of the fields on the line are also null; in which
case, the hyphen may be omitted.
OPTIONS
-F nfs Specify the NFS file system type
-h Suppress header line in output.
FILES
/etc/dfs/fstypes
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWnfscu |
+-----------------------------+-----------------------------+
SEE ALSO
mount(1M), share(1M), unshare(1M), attributes(5)
SunOS 5.10 6 Nov 2000 dfshares_nfs(1M)