Building on Franklin52's example... I found a syntax error as well :
Produces
with the output you provided above. But note that the column numbers 65-70 you specified do not match your example. CONTRA begins in column 67.
will produce
from the second example you provided - note again CONTRA is NOT in the columns you specified, but starts in Column 61.
This
will work as long as CONTRA is at the end of the 4th column. It works with both examples.
This line will cause it to break because CONTRA is in the 5th Column
works with all examples
You can send the output to a file by adding >outfile.txt to the end of the commnd
Hope that helps. If that doesn't solve the problem, please be a bit more specific about the actual format of the data and post some examples that I can test against.
Hope that helps.
Last edited by Franklin52; 08-10-2012 at 04:45 AM..
Reason: Please use code tags for data and code samples, thanks
I have a file with the below lines
1521
1522
1523
1524
1525
1526
...
174 lines all numbers like above. I want the above file to appear as below.
1521,1522,1523,1524.....
All the numbers should be separated by comma.
Pls tell me how to do this ....
Thanks in advance. (8 Replies)
Hi
I have to do the following.I have to format a file test.t
The contents are
# Header 1231
xyz
asdf
asdapsdcsd
//string1 = "pqrs"
//string1 = "abcd"; //info
//string1 = "*pqrs"; //add
string1 = "#123"; //sub
//string1 = "#1234567890"
data = check(string1)
//string1 = "#1234567890"... (12 Replies)
How to add the filename to end of each line with | as seperator, except first and last line of the file(s) in directories(with diff tree structure) using shell script?. And also how to replace a list of strings with another set of strings, which is present in a file?.
Kindly help out on... (1 Reply)
Hi,
I am writing a script and I need to calculate last weeks date.
I get the current date as;
today=`date '+%Y%m%d'`
and I need last week inthe same format.
Thanks, (2 Replies)
I have a file with contents something similar to as below :
SVCNAME,12m-1a,1a-2a,2a-3a,3a-4a,5a-6a,6a-7a,7a-8a,8a-9a,9a-10a,10a-11a,11a-12n,12n-1p,13p-14p,14p-15p,15p-16p,16p-17p,17p-18p,18p-19p,19p-20p,20p-21p,21p-22p,22p-23p,11p-12m, TOTALS... (5 Replies)
Hello,
I'm having trouble with formatting some text via the terminal. I can get it perfectly formatted, but when I try and copy paste the text from the output file it loses it's formatting. Very frustrating!
Basically I have 7 files (data data2 data3 data4 data5 data6 data7) containing a... (13 Replies)
there is one shell which calls for different sql scripts.
output of different are formatted in frame like structure.i want columnar wise formatting to be done in such a manner that output of one sql may be comon input of rest sqls .
ERC DML
Closure Date
ER DML
SAP Transfer Date
... (0 Replies)
Hi All,
Need an urgent help to convert a unix file in to a particular format:
**source file:**
1111111
2d2f2h2
3dfgsd3
...........
1111111 <-- repeats in every nth line. remaining all lines will be different
123ss41
432ff45
...........
1111111 <-- repetition
qwe1234
123weq3... (1 Reply)
Dear all,
I am new to shell scripting and have tried to make a small program for fun sake that tells age from the last number of cell phone and birth year.
At the end we get a final 3 digit number and the first digit represents the last digit of cell phone and rest 2 numbers shows age. eg. 423... (4 Replies)