Visit Our UNIX and Linux User Community


File modification problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File modification problem
# 1  
Old 02-15-2012
File modification problem

Hi,

I have a file input.txt.
cat input.txt
output is as follows :

Quote:
"0001"~"name"~"bb"~"20.25"~"0010"
~"abc"~"0002"~"name"~"dd"~"35.50"~"25"~
"xxx"~"0003"~"name"~"aa"~"21.3

5"~"0056"~"ijk"~
I want the output looking like:
cat output.txt
Quote:
"0001"~"name"~"bb"~"20.25"~"0010"~"abc"~
"0002"~"name"~"dd"~"35.50"~"25"~"xxx"~
"0003"~"name"~"aa"~"21.35"~"0056"~"ijk"~
I have a script.
Code:
cat input.txt | tr -d '\n' | sed 's/\("name"\)/\1\n/g' > output.txt

here I have to check "name" string and then enter newline. But I want the output as above. Anyone can help me please. If possible count ~ character equal to 6 then new line.

Thanks in advance

Last edited by mnmonu; 02-15-2012 at 03:55 AM..
# 2  
Old 02-15-2012
Could this help you ?
Code:
tr -d '\n' < Filename | awk -F"~" '{for(i=1;i<=NF;i++){printf i%6?$i"~":$i"~\n"}} END {printf "\n"}'

# 3  
Old 02-15-2012
Quote:
Originally Posted by pravin27
Could this help you ?
Code:
tr -d '\n' < Filename | awk -F"~" '{for(i=1;i<=NF;i++){printf i%6?$i"~":$i"~\n"}} END {printf "\n"}'

Hi pravin,

I want to count "~ this string 6 times.because file data value may be ~ character that is why only ~ count is not working. Count should be "~ character combination.

my code is

Code:
cat filename | tr -d '\n' | sed 's/\([^"\~]*"~[^"\~]*"~[^"\~]*"~[^"\~]*"~[^"\~]*"~[^"\~]*"~\)/\1\n/g'

but my code not working properly.
# 4  
Old 02-15-2012
like this
Code:
# sed ':e;N;s/\n//g;te' file1 |sed 's/~/~X_XsedX/6;s/~/~X_XsedX/12;s/X_XsedX/\n/g'
"0001"~"name"~"bb"~"20.25"~"0010"~"abc"~
"0002"~"name"~"dd"~"35.50"~"25"~"xxx"~
"0003"~"name"~"aa"~"21.35"~"0056"~"ijk"~

regards
ygemici
# 5  
Old 02-15-2012
Quote:
Originally Posted by ygemici
like this
Code:
# sed ':e;N;s/\n//g;te' file1 |sed 's/~/~X_XsedX/6;s/~/~X_XsedX/12;s/X_XsedX/\n/g'
"0001"~"name"~"bb"~"20.25"~"0010"~"abc"~
"0002"~"name"~"dd"~"35.50"~"25"~"xxx"~
"0003"~"name"~"aa"~"21.35"~"0056"~"ijk"~

regards
ygemici
Hi ygemici,

Your code is correct. But when file contain 10000 row then problem. Then some loop is needed.
# 6  
Old 02-15-2012
awk:
Code:
awk '{gsub(/[^~]*~"name"/,RS RS "&")}NF' infile | awk '{gsub(ORS,x)}1' RS=

# 7  
Old 02-15-2012
Hi Scrutinizer,
Your script is running properly when file contain few amount of data. But when file contain huge data that time your script getting lots of time.And also one problem. When I redirect your script then output file only one line.
Code:
awk '{gsub(/[^~]*~"name"/,RS RS "&")}NF' input_file | awk '{gsub(ORS,x)}1' RS= > output_file


Last edited by mnmonu; 02-15-2012 at 08:20 AM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #219
Difficulty: Easy
When a data packet comes in to a port on a router, the router reads the network address information in the packet footer to determine the ultimate destination.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help For File modification

Hi, I have a file. File contains are as follows : Feb 19, 2012 5:05:00 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Feb 19, 2012 5:05:00 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 771 ms Feb 20, 2012... (3 Replies)
Discussion started by: mnmonu
3 Replies

2. Shell Programming and Scripting

File Modification

Hi, I have a file input.txt. cat input.txt output is as follows : Code: "0001"~"name"~"bb"~"20.25"~""~""~"0002"~"name" "dd"~"35.50"~"" ~""~"0003"~"name"~"aa"~"21.3 5"~""~""~ I want the output looking like: cat output.txt Code: "0001"~"name"~"bb"~"20.25"~""~""~... (6 Replies)
Discussion started by: mnmonu
6 Replies

3. Shell Programming and Scripting

Help for File Modification

Hi All, I have a file. This file contain huge amount of data. I want to modify this file. I want enter new line when count of "~ character is 79. Please find below the code : cat file_name | tr -d '\n' | sed... (6 Replies)
Discussion started by: mnmonu
6 Replies

4. Shell Programming and Scripting

Help for File Modification

Hi All, I have a file disk_space.log. cat disk_space.log 94% / 32% /boot 38% /mnt/data 100% /media/CDROM I want the output, like cat disk_space.log 94% / 100% /media/CDROM That means print the line those are grater-than 90%. And rest of the line is remove from file. I have a... (2 Replies)
Discussion started by: mnmonu
2 Replies

5. Shell Programming and Scripting

Help for File Modification

Hi, I have a file abcd.txt. cat abcd.txt output is as follows : "aa"~"bb"~"001"~""~""~"cc" "dd"~"005"~"" ~""~"kk"~"aa"~"00 8"~""~""~ I want the output looking like: cat abcd.txt "aa"~"bb"~"001"~""~""~ "cc""dd"~"005"~""~""~ "kk"~"aa"~"008"~""~""~ I have a script. (4 Replies)
Discussion started by: mnmonu
4 Replies

6. Shell Programming and Scripting

Help with file modification

Hi, I have a file test.txt . The contain of the file is as below : 365798~SAPUS~PR5~0000799005~ADM CHARG MEDCAL INS~~~~~~~~~~~~~~~~~~~~~~~~SLAC480 I want to modify this file. And file contain loking like "365798"~"SAPUS"~"PR5"~"0000799005"~"ADM CHARG MEDCAL... (6 Replies)
Discussion started by: mnmonu
6 Replies

7. Shell Programming and Scripting

File modification history

Can anyone please suggest an alternate command for "stat" . I am trying this on Solaris 5.9 , but the command doesn't exist. Basically i need to see one particalar file modification history. Any help is appreciated. (4 Replies)
Discussion started by: mk1216
4 Replies

8. UNIX for Dummies Questions & Answers

How to change the file modification time of a file on nfs mount point

Hi I am accessing a file on nfs mounted device, after completing using of the file, i am tring to restore the access time and modification times of the file. So i got the previous modified time of the file using stat() function and trying to set the date and time for the file, To set these... (6 Replies)
Discussion started by: deepthi.s
6 Replies

9. Shell Programming and Scripting

File modification

Dear all, i have a file which contains this lines. 0-0 CC=1 0-01 0-011 0-0111 0-01110 F=500 CC=1 L=15 M=5 TRD=3948... (2 Replies)
Discussion started by: panknil
2 Replies

10. AIX

snmpd modification problem

Hi Gurus, I am relatively new in AIX. I have a problem in modifying the community string in snmpd. I have edited the /etc/snmpd.conf file and changed the default community name 'public' to new one (P@@$w0rd). When I tried to query my aix server with the new string , it is not giving any... (1 Reply)
Discussion started by: helloajith
1 Replies

Featured Tech Videos