Help for File Modification


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help for File Modification
# 1  
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 's/\([^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~[^~]*"~\)/\1\n/g' > new_filename This code is working. But sometime problem, not count properly. Please help me. Thanks in advance.
# 2  
provide some example input contents

---------- Post updated at 04:48 PM ---------- Previous update was at 04:41 PM ----------

Code:
 
nawk -F~ 'BEGIN{RS="";OFS="~";count=0;}{for(i=1;i<=NF;i++){count+=1;if(count==73){printf("\n");count=0}else{printf("%s~",$i)}}}' input.txt

# 3  
thanks itkamaraj, but this code also some problem. If i want only count ~ character (79 times). then what should i do.
# 4  
change count==73 to count==79
# 5  
hi itkamaraj, yes i know ,but your code not working properly.
# 6  
provide sample data and required output
# 7  
Actually file is huge volume of data

Last edited by mnmonu; 02-14-2012 at 09:36 AM..
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #160
Difficulty: Easy
The Internet Autonomous Network Authority (IANA) is responsible for maintaining the official assignments of Internet port numbers.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do you get the last modification date of a file?

I'm trying to get the date output to be in the form yyyy-mm-dd (e.g. 2013-01-18) !/bin/sh modDate=$(stat -c %y $1) echo $modDate >> $1 When I run this on another file (by typing ./dateScript theFile.txt), I keep getting this message: stat: illegal option -- c What's wrong with my code... (2 Replies)
Discussion started by: Nate18
2 Replies

2. 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

3. Programming

File content modification

HI All, I have a file with content as below Filename: my name is xyz my name abc my name is bdf end Filename: my name uvx my name edd my name jhn end i want to edit the content and save into another file as Filename1: my name is xyz Filename1: my name abc Filename1: my name is... (4 Replies)
Discussion started by: jhon1257
4 Replies

4. 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

5. 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

6. 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

7. 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

8. UNIX for Dummies Questions & Answers

txt file modification which is beyond me

Dear all, I 'd like to create a new txt file using the old file. For example, in old file, if count=2 then in new file, repeat that row twice, with the only difference is: on the first row, 'start' column contains the 1st apart of the 'start' in the old file; while in the 2nd row, the 'start'... (7 Replies)
Discussion started by: forevertl
7 Replies

9. 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

10. 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

Featured Tech Videos