Visit Our UNIX and Linux User Community


interesting problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting interesting problem
# 1  
Old 02-27-2008
interesting problem

Hi,

I am new in this forum and I am glad to be a part of it. I have a problem that has two parts:

1/ extract just the timestamp from a filename: for example, I have a file called 'sales20080226144525.txt' and I want to extract just the '20080226144525' part out of it.

2/ Now, take that timestamp and insert it in the beginning of each line with a '|' delimiter. For example,

before:
%> cat test.txt
The cow jumped over the moon
The dish ran away with the spoon

after:
%> cat test.txt
20080226144525|The cow jumped over the moon
20080226144525|The dish ran away with the spoon

Thanks,
CB
# 2  
Old 02-27-2008
Code:
TIMESTAMP=`echo "sales20080226144525.txt" | sed "s/^[^0-9]*\([0-9]*\).*/\1/"`

sed -i "s/^/$TIMESTAMP|/" test.txt

For extracting the timestamp, you can use a simpler method, it all depends on the filename format. For example, for the given filename you can also use:

Code:
TIMESTAMP=`echo "sales20080226144525.txt" | sed "s/[^0-9]*//g"

# 3  
Old 02-27-2008
Code:
echo "sales20080226144525.txt" | sed 's/sales\(.*\)\..*$/\1/'

filename=`echo "sales20080226144525.txt" | sed 's/sales\(.*\)\..*$/\1/'`

sed 's/^/'$filename'|/' input > output

# 4  
Old 02-27-2008
Thanks Robotronic, it works... the power of sed.

CB
# 5  
Old 02-29-2008
Just one comment - for me this is not "interesting problem". Next time try to use more accurate title, like "How to parse and modify a string".
Thanks and sorry for correcting you
# 6  
Old 02-29-2008
just one more way to do this.

Code:
 filename=`print "sales20080226144525.txt" | tr -d "A-z."`

agree with prior poster, please use proper title next time.

Previous Thread | Next Thread
Test Your Knowledge in Computers #928
Difficulty: Medium
64-bit versions of the Unix time stamp will cease to work at 15:30:08 UTC on Sunday, 14 December 2922770265960.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Interesting awk problem

Hello; I wish to manipulate the output from the following: ps axo %mem,pid,euser,cmd|sort -nr 14.4 3170 root /usr/sbin/snmpd -Lsd -Lf /dev/null -p /var/run/snmpd.pid -a 3.6 3635 root splunkd -p 8089 start 2.6 3383 root /usr/sbin/httpd 2.1 15496 apache /usr/sbin/httpd ... (5 Replies)
Discussion started by: delphys
5 Replies

2. Solaris

Interesting Disk Error Problem

Hi Folks, Have an interesting problem here, have just upgraded some machines (Test and Development) to the latest and greatest as in. SunOS ss063a 5.10 Generic_147440-13 sun4u sparc SUNW,Sun-Fire-V440 However on all the systems we are seeing the same problems, during the boot there is a... (3 Replies)
Discussion started by: gull04
3 Replies

3. AIX

Interesting Problem! 2 VIOs, One is problematic, assigning disks and resources from the other only

Hi, The scenario is like this: 1.We needed to assign two hdisks to an LPAR 2.SAN team gives us two ldevs 3.One of our VIO is hanging on cfgmgr operation 4. We ran cfgmgr on the smooth VIO. Got the disks and assigned the disks from there to the LPAR.(By passed the other VIO as in didnt run... (11 Replies)
Discussion started by: aixromeo
11 Replies

4. Solaris

Very Interesting Problem

Ok Lets say i have a webpage on a solaris box. and i am trying to make a hyperlink. This hyperlink references a Microsoft Access file on a Windows box. So, How do i make a file reference from The unix box to a windows box. Things to keep in mind -- 1.) Solaris doesnt need to... (6 Replies)
Discussion started by: Demon002
6 Replies

5. Programming

Interesting Problem About Incrementing ++

Here is my code: int startingPort = 200; string tempPort; stringstream out; out<<startingPort; tempPort = out.str(); //tempPort carries startingPort in string format //convert tempPort to *char - currentPort going to be passed into getaddrinfo() char currentPort;... (10 Replies)
Discussion started by: f.ben.isaac
10 Replies

6. Shell Programming and Scripting

Interesting problem

Hello, So I'm utilizing the bash brace expansion feature to checkout multiple folders from cvs with ease, while excluding certain subfolders within. So I do a command like this: cvs co trunk/{mod_a,mod_b,mod_c} \!trunk/{mod_a,mod_b,mod_c}/web to checkout modules trunk/mod_a , trunk/mod_b ,... (1 Reply)
Discussion started by: neked
1 Replies

7. SCO

I have an interesting problem and need advice

We have an inhouse built application which handles our AR function. We'd like to email statements out of the application directly. My question is this is there a good, solid, command line driven, scriptable Mail Transport Agent that would allow us to send a semi unique email (with a statement and... (1 Reply)
Discussion started by: Maldain
1 Replies

8. UNIX for Advanced & Expert Users

interesting problem

After a server reboot for regular mainatanance we face the following situation: 1/ user accounts with ksh can't start the korn shell 2/ korn shell scripts do work however, if executed from bash 3/ normal users with bash can't run ksh 4/ root can run ksh 5/ if I switch the default shell to... (3 Replies)
Discussion started by: rein
3 Replies

9. UNIX for Advanced & Expert Users

An interesting problem

hi!, here is an interesting problem ..... I ftp a file named " my first file.doc" from windows to my HP workstation. Ftp is succesful. The file appears with the same name in my home directory.. But now how do I open this file?? while using Vi or More or other editor, they take only the... (5 Replies)
Discussion started by: jyotipg
5 Replies

Featured Tech Videos