UNIX for Dummies Questions & Answers

I have a very similar problem, so I post my question in thsi thread...

I would like to replace two characters ("CR" and ";") by a star symbol "*".

I tried this like you can see here:

tr '\013\073' '*' < filea.tab > fileb.tab

But as a result I got stars where ever a "CR" or a ";" existed, not only where they both were next to each other...

Does anybody see which mistake I make???

Thanks a lot,

Martin

The % is a wild card telling s ( the substitute command ) to apply the substitution to all lines of the file. If you only wanted to do certain lines the command would be something like:
:10,35s/^M//g

where 10 is the starting line number and 35 is the ending line number.

to turn on line numbers in vi use the command:
:set nu

to turn off :
:set nonu

Thanks ohagar

Hi,

I have one text file(that file file has pipe line (|) seperate file), i want to cut the 16th and 81st column from the text file using the below commands

Input file is:
==========
file_header|GEES-EU|343|2007-08-29T07:10:51|SSPF|12|2008|0|0|SSS||

invoice_header|39478-198192-2|250489|BRIDGEWATER108|2007-08-28T00:00:00|1|STANDARD|Receipt Invoice automatically created on 29-AUG-07|ERS|USD|USD|1|0|0|1|1613314|0|0|01 75 2.00/15|2007-08-28T00:00:00|75|2007-11-11T00:00:00|.02|2|15|2007-09-12T00:00:00|CHECK||30.391998.00000.000.00.00.000000.00000.000|N|||N|2007-08-28T00:00:00|2007-08-29T00:00:00|||1||||||||SSPF|||||||||||||DAT|||||||||||||||||||||343|GEES-EU||N||2007-08-28T00:00:00|1||||||2007-08-28T00:00:00|||||Y||NOT REQUIRED|Validated||manjunath.nagasomasundaram@ge.com|||||||||||||SSPF|SSPF|0||||||||||||||
invoice_detail|39478-198192-2|2|ITEM|1|1|1|AUG-07|17.121504.45820.000.00.00.000000.00000.000|Advertising campaign services|1613314|1|11456689|4796888||236029302|0|1|1|1|2007-08-28T00:00:00|N|U|N|N|||||||A|N||||||||||||||||ERS-SSPF|||||10512|||||||||E||||||||||||||||||343|GEES-EU||N|N||||||||||||||||||||||||||||||||||||||ITEM_TO_PO|||||5938078||||N|N|Y|N|||||||||||Each||27663 13||||||N|||||501456183||ERS-SSPF||||||Nagasomasundaram, Manjunath||||||||||manjunath.nagasomasundaram@ge.com|manjunath.nagasomasundaram@ge.com|GE Hungary ZRt. - Engine Service|H-2112 HU|VERESEGYHAZ|HU||US||8210180100|SSPF

po_number=`echo $text_file|cut -d"|" -f16`
echo $po_number
orgid=`echo $text_file|cut -d"|" -f81`
echo $orgid

But my script is not giving any outputs. i have tried with above commands its cut upto 10 column.

what is the problem? any one help me.

Regards,
Siva.P
Bangalore

If you are using vi, the [CTRL][V] tells the computer NOT to execute the next command ([CTRL][M] - which is a new line) but to write it or in this case to replace it. If you are using vim in Windows, you have to use [CTRL][Q] instead of [CTRL][V] since [CTRL][V] in windows is mapped to paste.
The [CTRL] appears as '^' in the file. Window's programs end each line with two characters: <new-line><carriage-return>, whereas unix ends a line with only one character <new-line>.
I believe a new-line character is [CTRL][L] and the carriage return is [CTRL[M].

Try:

po_number=`cat text_file | cut -d"|" -f16` ...

Am not sure of this but I doubt this. !

Does that mean,

for a file with 10 bytes in first line
and 8 bytes in second line.

Then is the total size of the file : 10 + ( 1 + 1 ) ( 1 CR + 1 NL )
+
8 + ( 1 ) ( 1 NL )