03-18-2012
Editing strings within lines of file
Dear All,
I have a file which contains a column with age, which is represented in two following patterns
1. "007/A" or ''007/a" or ''7 /a" ..... In this case A or a means year and I would like to extract only the numeric values eg 7 in the above case if this pattern exits in a line of file.
2. "004/M" or "004/m" where M or m means month ...... for these lines I would like to first extract the numeric value of Month eg. 4 in this case and then convert it into a value of years which would be 0.33 eg 4 divided by 12.
Can someone please enlighten on this problem?
Appreciate your feedback.
Have a nice Sunday.
Cheers
Pawan
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a sql file and i need to extract the table names used in the sql file using a unix script. If i can extract the lines between the keywords 'FROM' and 'WHERE' in the file, my job is done. can somebody tell me how to do this using a shell script. If u can just let me know, how to... (2 Replies)
Discussion started by: babloo
2 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
I'm very very new to UNIX and AWK world.Please help me in finding a solution for my problem.
I'm having a file like this
-----------------------------------------------------------------
~Version Information
VERS. 2.0: CWLS log ASCII Standard -VERSION 2.0
WRAP. ... (4 Replies)
Discussion started by: santyshyam
4 Replies
3. Shell Programming and Scripting
Hi all,
I have a positional text file that comes from some source application. Before it is processed by destination application I have to add some header (suffix) to every record(line) in the file.
e.g.
Actual File
...............
AccountDetails
AcNO Name Amount
1234 John 26578
5678... (3 Replies)
Discussion started by: sharath160
3 Replies
4. Shell Programming and Scripting
Hi,
I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines).
#################################
huge_file.txt
a
a
ab
b
##################################
small_file.txt
a 1.5
b 2.5
ab ... (4 Replies)
Discussion started by: AshwaniSharma09
4 Replies
5. Shell Programming and Scripting
input file
Desired csv output
gc_type, date/time, milli secs
af, Mar 17 13:09:04 2011, 144.596
af, Mar 20 00:37:37 2011, 144.242
af, ar 20 21:30:59 2011, 108.518
Hi All,
Any help in acheiving the above would be appreciated. I would like to parse through lines within one file and... (5 Replies)
Discussion started by: satish.vampire
5 Replies
6. Shell Programming and Scripting
Hi, i would really appreciate any help anyone can give with the following info.
Thanks in advance.
I need to run a search on a file that contains thousands of trades, each trade is added into the file in blocks of 25 lines. i know the search has to take place between a time stamp specified... (4 Replies)
Discussion started by: sp3arsy
4 Replies
7. Shell Programming and Scripting
The question is not as simple as the title... I have a file, it looks like this
<string name="string1">RZ-LED</string>
<string name="string2">2.0</string>
<string name="string2">Version 2.0</string>
<string name="string3">BP</string>
I would like to check for duplicate entries of... (11 Replies)
Discussion started by: raidzero
11 Replies
8. Shell Programming and Scripting
test.txt:
appleboy
orangeletter
sweetdeal
catracer
conducivelot
I want to only grep out lines that contain "appleboy" AND "sweetdeal". however, the closest thing to this that i can think of is this:
cat test.txt | egrep "appleboy|sweetdeal"
problem is this only searches for all... (9 Replies)
Discussion started by: SkySmart
9 Replies
9. UNIX for Dummies Questions & Answers
Hello All,
this is my first post so I don't know if I am doing this right.
I would like to append entries from a series of strings (contained in a text file) consecutively at the end of specifically labeled lines in another file.
As an example:
- the file that contains the values to be... (3 Replies)
Discussion started by: gus74
3 Replies
10. Shell Programming and Scripting
I have a bunch of file numbers in the file 'test':
I'm trying the above command to change all the instances of "H" to "Na+" in the file testsds.pdb at the line numbers indicated in the file 'test'. I've tried the following and various similar alternatives but nothing is working:
cat test |... (3 Replies)
Discussion started by: crunchgargoyle
3 Replies
LEARN ABOUT DEBIAN
px_timestamp2string
PX_TIMESTAMP2STRING(3) Library Functions Manual PX_TIMESTAMP2STRING(3)
NAME
PX_timestamp2string -- Convert paradox timestamp into formated string
SYNOPSIS
#include <paradox.h>
char * PX_timestamp2string(pxdoc_t *pxdoc, double timestamp, const char *format)
DESCRIPTION
Creates a string representation of a paradox timestamp as specified in the parameter format. The timestamp must be either retrieved with
PX_get_data_double(3) after calling PX_get_record(3) or by simply using the double value in the pxval_t struct as returned by
PX_retrieve_record(3). A timestamp contains both time and date information. The format string contains chars which stand for certain values
of the date/time. The following table lists all available characters with a meaning. All other characters are being copied unmodified to
the output string. If a special character shall not be interpreted it must be preceded with a backslash.
Characters and their meaning in date/time format string
Character Meaning
Y year, numeric, 4 digits
y year, numeric, 2 digits
m month, numeric
n month, numeric, no leading zeroes
d day of the month, numeric
j T{
day of the month, numeric, no leading zeros
T}
H hour, numeric, 24 hour format
h hour, numeric, 12 hour format
G T{
hour, numeric, 24 hour format, no leading zeroes
T}
g T{
hour, numeric, 12 hour format, no leading zeroes
T}
i minutes, numeric
s seconds, numeric
A AM/PM
a am/pm
L boolean for leap year
RETURN VALUE
Returns pointer to string on success and NULL on failure.
SEE ALSO
PX_time2string(3), PX_date2string(3)
AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_TIMESTAMP2STRING(3)