File Modification


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Modification
# 1  
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"~""~""~ "0002"~"name""dd"~"35.50"~""~""~ "0003"~"name"~"aa"~"21.35"~""~""~ 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. Thanks in advance
# 2  
@mnmonu: Please use code-tags. Unable to understand the layout of your input file and your desired output.
# 3  
Quote:
Originally Posted by balajesuri
@mnmonu: Please use code-tags. Unable to understand the layout of your input file and your desired output.
Quote:

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:

Quote:
"0001"~"name"~"bb"~"20.25"~""~""~
"0002"~"name""dd"~"35.50"~""~""~
"0003"~"name"~"aa"~"21.35"~""~""~


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.

Thanks in advance

Last edited by mnmonu; 02-15-2012 at 02:51 AM..
# 4  
Code:
cat input.txt | tr -d '\n' | sed 's/~\(\"[0-9]\{4\}\)/~\n\1/g'

# 5  
Quote:
Originally Posted by balajesuri
Code:
cat input.txt | tr -d '\n' | sed 's/~\(\"[0-9]\{4\}\)/~\n\1/g'

Hi balajesuri,

your script is correct, but if input file looking like
Quote:
"0001"~"name"~"bb"~"20.25"~"0010"
~""~"0002"~"name"~"dd"~"35.50"~"25"~
""~"0003"~"name"~"aa"~"21.3

5"~"0056"~""~
and output
Quote:
"0001"~"name"~"bb"~"20.25"~"0010"~""~
"0002"~"name"~"dd"~"35.50"~"25"~""~
"0003"~"name"~"aa"~"21.35"~"0056"~""~
then your script not execute properly

Last edited by mnmonu; 02-15-2012 at 04:23 AM..
# 6  
This is what happens if you keep changing requirements over posts. Regex pattern is sed was crafted as per your first requirement.

Code:
cat input | tr -d '\n' | sed 's/\(\"~\"\"~\)\(\"0\)/\1\n\2/g'

# 7  
Quote:
Originally Posted by balajesuri
This is what happens if you keep changing requirements over posts. Regex pattern is sed was crafted as per your first requirement.

Code:
cat input | tr -d '\n' | sed 's/\(\"~\"\"~\)\(\"0\)/\1\n\2/g'

Actually file data may be change, but in first line no like "0001" ; and the string "name" not change.
if count ~ character >6 then new line print,that is the better way.

Last edited by mnmonu; 02-15-2012 at 04:51 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 #371
Difficulty: Medium
PHP opcodes are generated each time the program is launched and are always interpreted and not just-in-time compiled.
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

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

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