In the attached .zip the text file is the input and the .xls is the desired output.
The green highlight comes from the text fie and will have S1 - AP1 as row headers. It will also have data in those columns ... A1 - R1 (headers only) and AQ1-AX1 (headers only). No data is needed for those columns (only the headers). I have a SQL import that is expecting all those columns in one file.
Hi ,
i have one file like :
APP101A
APP103B
MSG307A
MSG308B
XADM002A
and so on , and i expect to replace the last character A by B and B by A
the result would be :
APP101B
APP103A
MSG307B
MSG308A
XADM002B
how can i do that ? (3 Replies)
Hi,
I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it.
Here is how the text file looks:
_______________________________________________________
DEVICE STATUS INFORMATION FOR LOCATION 1:
OPER STATES: Disabled E:Enabled ... (5 Replies)
Hi All,
I am tring to insert a newline with "/" in a text file whenever there is the text "end;"
right now I have inside file:
.
.
end;
I want to have:
.
.
end;
/
I tried doing the following within the file
:g/^end;/s//end; \/ / (4 Replies)
There is file named .htaccess. It is located in many directories on my web server. Instead of manually editing each file to add specific text, i thought there is possibly a command which will allow me to do that.
What i need to be done exactly?
In all .htaccess files i need to add/append the... (2 Replies)
Hello
i have a text file like this:
1 AB AC AD EE
2 WE TR YT WW
3 AS UY RF YT
the file is bigger , but that's an example of the data
what i want to do is to merge all columns together except the first one,
it will become like this :
1 ABACADEE
2 WETRYTWW
3 ASUYRFYT (8 Replies)
I have a space delimited text file with 1,000,000+ columns? I would only like to view specific ones (let's say through 1:10), how can I do that? Thanks! (3 Replies)
Hi,
I would like to use sed to replace NA to x ('s/NA/x/g'), but only in the 5th column of the space delimited text file, nowhere else. How do I go about doing that? Thanks! (1 Reply)
hi guys,
im trying to add the following line in my xml file
<dbrollbacksegs <oa_var="s_db_rollback_segs">NOROLLBACK</dbrollbacksegs>
when ever i find the following line
<dbsharedpool oa_var="s_dbsharedpool_size">300000000</dbsharedpool>
I have succedded till adding a new line... (1 Reply)
Hello All,
this is my first post so I don't know if I am doing this right.
I would like to append entries from a series of strings (contained in a text file) consecutively at the end of specifically labeled lines in another file.
As an example:
- the file that contains the values to be... (3 Replies)
Hi,
I am writing a shell script where I want that # should be added in all those lines as the first character where the pattern matches.
file has lot of functions defined
a.sh
#!/bin/bash
fn a {
beautiful evening
sunny day
}
fn b {
}
fn c {
hello world .its a beautiful day
... (12 Replies)
Discussion started by: ashima jain
12 Replies
LEARN ABOUT NETBSD
fmt
FMT(1) BSD General Commands Manual FMT(1)NAME
fmt -- simple text formatter
SYNOPSIS
fmt [-Cr] [goal [maximum]] [name ...]
fmt [-Cr] [-g goal] [-m maximum] [name ...]
DESCRIPTION
fmt is a simple text formatter which reads the concatenation of input files (or standard input if none are given) and produces on standard
output a version of its input with lines as close to the goal length as possible without exceeding the maximum. The goal length defaults to
65 and the maximum to 75. The spacing at the beginning of the input lines is preserved in the output, as are blank lines and interword spac-
ing. In non raw mode, lines that look like mail headers or begin with a period are not formatted.
-C instructs fmt to center the text.
-g goal New way to set the goal length.
-m maximum New way to set the maximum length.
-r Raw mode; formats all lines and does not make exceptions for lines that start with a period or look like mail headers.
fmt is meant to format mail messages prior to sending, but may also be useful for other simple tasks. For instance, within visual mode of
the ex(1) editor (e.g., vi(1)) the command
!}fmt
will reformat a paragraph, evening the lines.
SEE ALSO mail(1), nroff(1)HISTORY
The fmt command appeared in 3BSD.
BUGS
The program was designed to be simple and fast - for more complex operations, the standard text processors are likely to be more appropriate.
BSD May 29, 2007 BSD