Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

alter data in a file

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers alter data in a file
# 1  
Old 03-09-2011
Java alter data in a file
Hi ,

I have data in file like below.
Code:
status ----------- ------ 2287 C 1502 E 19

can anyone pls help me how can i get it modified as below
Code:
status 2287|C|1502 E|19

can someone pls help.

Thanks.
Last edited by vbe; 03-09-2011 at 09:37 AM..
# 2  
Old 03-09-2011
Code:
cat << EOF |
status ----------- ------ 2287 C 1502 E 19
EOF

perl -lne '
s/--* //g;
s/ /\|/g;
s/\|/ /;
s/\|(.)\|([^\|]*)$/ $1\|$2/;
print;
'

a nasty little bit of edits....
# 3  
Old 03-10-2011
TRY
Code:
cat File_Name |sed 's/---* //g' |awk '{FS=" " ;OFS="|"}{print $1 FS $2 OFS $3 OFS $4 FS $5 OFS $6}'

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Alter existing script to work with longer file name

I have this script: #!/bin/sh for file in "$@" do ext=${file##*.} base=${file%.*} num=${base##*v} zeroes=${num%%*} num=${num#$zeroes} #remove leading zeros, or it uses octal num=$((num+1)) base=${base%v*} new=$(printf... (4 Replies)
Discussion started by: scribling
4 Replies

2. Shell Programming and Scripting

Alter Fixed Width File

Thank u so much .Its working fine as expected. ---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ---------- I need one more help. I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Discussion started by: vinus
6 Replies

3. Shell Programming and Scripting

How to get MD5 from a pipe stream and do not alter it?

Say I have a stream and want to get MD5 from it, without altering it. I won't know how big the stream is or how much time it will take to close. Here is the idea: cat somefile | calculate md5 and put it somewhere | bzip2 > somefile.bz2 (5 Replies)
Discussion started by: Tribe
5 Replies

4. Homework & Coursework Questions

Help with bash shell to alter text file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: My first question pertains to the adding a book section, I'm unsure which command or conditional statement I... (0 Replies)
Discussion started by: Vitrophyre
0 Replies

5. Shell Programming and Scripting

Alter file descriptor for stdout

Is there a way to alter the file descriptor for stdout.? sample: #!/bin/ksh exec 1>file exec 2>file echo hi --------->This will go to file print -u4 "come statement"---->I want to make the file descriptor 4 to point to stdout. The reason is ,I have a script which has lot of db2... (1 Reply)
Discussion started by: prasperl
1 Replies

6. UNIX for Dummies Questions & Answers

alter data in column

Hello All, I want to alter the first column of a dataset, say, 001 0.700 100.000 002 0.715 99.998 003 0.730 99.998 004 0.744 99.975 005 0.759 99.916 011 0.847 97.987 012 0.861 97.317 020 0.978 87.789 021 0.993 86.400 022 1.008 84.904 023 1.022 83.014 100 2.148 11.426 101... (2 Replies)
Discussion started by: tintin72
2 Replies

7. Solaris

Alter zip file without unzipping

I have some zip files. Every file has a "folder/xml file" inside it. Is there any way to change these zip files directly without unzipping them. I want to convert these zip files to "/xml file" (want to move the xml file/s one root up by removing the folder inside it.) Ex: -bash-3.00$ for file... (1 Reply)
Discussion started by: _prasad
1 Replies

8. Shell Programming and Scripting

File Alter Problem--need help

i have 3 files a.txt , b.txt and c.txt each files have keyfields and some column fields e.g. a.txt keyfield1 keyfield2 keyfield3 col1 col2 col3 1 2 3 44 55 66 4 5 6 92 48 33 .....................etc.................. b.txt keyfield1... (2 Replies)
Discussion started by: manas_ranjan
2 Replies

9. AIX

Can't alter bootlist

Made a sysback tape backup on our 595 running 4.1.5 but when trying to do a restore discovered that rmt0 not in bootlist(s). Tried to alter both the normal and service bootlists but system wont respond to F7(commit). Erased the service boolist then tried alter again, same result. Now have... (2 Replies)
Discussion started by: mooshkie
2 Replies

10. UNIX for Dummies Questions & Answers

how to alter the old file permanently using sed?

hi , m new to sed and awk. can anyone tell me how to alter the old file permanenetly using sed. e.g. $sed 's/cat/dog/g' old_file the above command will replace all the occrance of cat by dog in the file called old_file and by default will show the output at stdout. so is there anyway of... (2 Replies)
Discussion started by: mxms755
2 Replies
Login or Register to Ask a Question