thanks, but the last command remove the comma at the beginning but at the end of the line remains but what i want is just to remove the last comma before the r$ character (End of line). this is the output
Code:
sed -n l file4|head -5
1790365,1,F,1,01,00,20121205,23305300,17.00,0000001700,03214534032,03\
187170198,I,,0,,,N,I,20121207 001649,EDFN,,,0,I,STD,COMCE,BSC,COMBOGE\
G,TAND,27,0404,MOB-315,ENT,ENT-MOB,MM01,Telefonos de BSC,N,0,T_D,1,1.\
00,60.00,17.00,MINRED,1,COMCE,TO,PCO,0.000000,0.000000,MINUTO,1.00,1,\
0.000000,0.00,0.00,,0.00,\r$
Id appreciate your help thanks in advanced
Moderator's Comments:
Please use code tags
---------- Post updated at 09:57 PM ---------- Previous update was at 08:17 PM ----------
furthermore i tested to substitute with a string and then grep it and i couldnt find the substitution i.e
Code:
sed 's/,$/TestStr/g' file1 > file4
grep -i TestStr file4
found nothing
now another doubts arises: this is a 100000 records file i want to process, and im working with ubuntu 10.1 with bourne shell and then want to run in a HP unix,so dont know if the version of the sed command has something to do ?
Last edited by Scott; 12-10-2012 at 12:17 AM..
Reason: Code tags
Hi,
I need to put the single line contents of a file into a variable, but remove the last character, for example the file would have this sort of contents:
2;4;3;10;67;54;96;
And I want the variable to be:
2;4;3;10;67;54;96 (notice the last ";" has gone).
Unfortunately I can't just... (4 Replies)
Hi,
I am facing one interesting problem :
I have a file which contains data like this
459,|1998-11-047|a |b |c \n efg | d|e | \n
459,|1998-11-047|a \n c|b |c \n efg | d|e | \n
Basically what I have to do is , I have to remove all \n which is coming ( enclosed ) in between... (7 Replies)
Hi Experts,
I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line.
File is comma (,) seperated.
Eg:
ID,Client ,SNo,Rank
37,Airtel \n... (8 Replies)
Hi,
we are trying to process a csv file,in which we are getting data with line breaks.How to remove the line break character in the file?
when i try to print the line break charcter using od -c,it gives as '\n' character for both line break and line feed.
Please provide your valuable... (6 Replies)
I need to remove new line character from end of file.
Suppose here are content.
a|b|c|d|r
a|b|c|d|r
a|b|c|d|r
<new line>
that means file contains 4 lines but data is there in 3 lines.
so I want that only 3 lines should be there in file.
Please help (20 Replies)
Hi,
I have a file with lines such as the below. I want to remove the comma only if it is the first character on a line. I can't work out how to do this using sed.
*ELSET, ELSET=WHEEL_TD2
63, 64, 65, 72, 82, 88, 89, 92, 120, 121, 152, 181, 190, 221, 252, 259
, 260, 282, 283, 285, 286,... (2 Replies)
I have a file with different record length. The file as to be converted into fixed length by appending spaces at the end of record. The length should be calculated based on the record with maximum length in the file.
If the length is less than the max length, the spaces should be appended... (4 Replies)
Hi guys,
Does anyone know how to remove the last character in each of the line?
This is what I have:
ABCDE.1
GLSJD.2
HIJPL.2
HKAGB.3
IUBWQ.1
What I want (remove the dot and number):
ABCDE
GLSJD
HIJPL
HKAGB
IUBWQ
I tried to use this: sed 's/.*//'
But I'm not sure if that is... (3 Replies)
how to Remove comma as last charector in end of last line of file:
example:
input file
---------------
aaaaaa,
bbbbbb,
cccc,
12345,
____________
output file :
-----------
aaaaaa,
bbbbbb, (6 Replies)
Hi All,
Could any one suggest how to remove $ symbol in a text file when i am opening in vi editor.
Scenario;
For example iam having a file name aaa.txt the data inside the file is like
sample
name
when i am opening in vi editor
The same file resembles like below when i am... (1 Reply)
Discussion started by: Chandru_Raj
1 Replies
LEARN ABOUT DEBIAN
input
INPUT(5) File Formats Manual INPUT(5)NAME
input - input data file format
DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII
file, so can be edited manually if required. It is read by yagi or optimise. The program optimise also creates the same file format.
NOTES
FREQUENCY
MIN_FREQUENCY
MAX_FREQUENCY
STEP_FREQUENCY
ELEMENTS
DRIVEN
PARASITIC
ANGULAR_STEP
DATA_DRIVEN
DATA_PARASITIC
The
#
is used as a comment.
A typical file, for an antenna designed for the 2m amateur band (144-146
MHz) might be as shown below. Note:
1) Reflector is at position 0.0
2) All elements lengths/positions are in m.
NOTES This line can be up to 400 characters.
FREQUENCY 145.000000
MIN_FREQUENCY 144.000000
MAX_FREQUENCY 146.000000
STEP_FREQUENCY 0.100000
ELEMENTS 10
DRIVEN 1
PARASITIC 9
ANGULAR_STEP 180.000000
#DATA_DRIVEN x y length diameter voltage phase
DATA_DRIVEN 0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000
# DATA_PARASITIC x y length diameter
DATA_PARASITIC
0.00000 0.00000 1.01902 0.00630
0.49859 0.00000 0.95551 0.00630
1.07338 0.00000 0.93595 0.00630
1.81020 0.00000 0.92050 0.00630
2.58152 0.00000 0.91322 0.00630
3.30390 0.00000 0.91243 0.00630
4.03692 0.00000 0.90423 0.00630
4.64108 0.00000 0.89081 0.00630
5.37418 0.00000 0.83912 0.00630
FILES
filename ASCII description of antenna. filename.out binary file
SEE ALSO yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5).
AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov).
Yagi version 1.16 24th October 2000 INPUT(5)
12-09-2012
