Sponsored Content
Full Discussion: blank spaces getting deleted
Top Forums Shell Programming and Scripting blank spaces getting deleted Post 302117507 by gander_ss on Tuesday 15th of May 2007 04:59:20 AM
Old 05-15-2007
Java blank spaces getting deleted

I have to filter out data from a file based on the value of first three characters of each record I have used the following logic

FIN=$LOC/TEST2.TXT

FEEDFILE=$LOC/TEST1.TXT

while read FDROW
do

FEEDROW=$FDROW;

DTYPE=`echo $FEEDROW |cut -c 1-3`
if [ $DTYPE -eq 300 ] ; then

echo $FEEDROW >> $FIN
fi
done < $FEEDFILE

However there is one problem thats occuring in this caseRecords are shrinking as while reading the file when the data (record) is getting stored in $FDROW variable blank spaces within record are being truncated and this is creating problems as the base file/output file, that I am using is a flat file and hence field positions are getting disturbed in the output file TEST2.txt, is there a way to prevent this or is there any other way this can be done?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

howtodelete blank spaces

sry im new to this...another qns.. if i have a line in the normal shell the file is email.scp. it contains a txt file eg hello.txt that contain this infomation. k@hotmail.com j@jotm.com how do i delete away the blank spaces after the k@hotmail.com..i dun wan any blank spaces after the... (2 Replies)
Discussion started by: forevercalz
2 Replies

2. UNIX for Dummies Questions & Answers

string with blank spaces

I have a file that has dates like this: date FINAL_RESULT; 7 date FINAL_RESULT; 2 date FINAL_RESULT; 5 With this command: seira=`cut -f2 -d\; tes.txt` i take the date FINAL RESULTs and i store them on variable seira.then seira look like this: 6 3 8 I want to read seira and make a sum of all... (4 Replies)
Discussion started by: psalas
4 Replies

3. Shell Programming and Scripting

Handling blank spaces

Hi, I am trying to replace a specific column values in a csv file with double quotes when I am find embedded spaces with in the fields. Example: SNO,NAME,ZIPCODE,RANK,SEX,ADDRESS 1,Robert,74538,12,34, M,Robert Street, NY 2,Sam,07564,13,M,12 Main Ave, CA 3,Kim, Ed,12345,14,M,123D ,... (1 Reply)
Discussion started by: techmoris
1 Replies

4. Shell Programming and Scripting

Removing blank spaces, tab spaces from file

Hello All, I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out. My file is like this (<b> means one blank space, <t> means one tab space)- $ cat file NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Discussion started by: NARESH1302
3 Replies

5. Shell Programming and Scripting

Problems with Blank Spaces

Hi to all. How can I pass to the stat command a file path with blank spaces? And another question, if I use stat command like this: stat / -name "*.sh" -user $user_name -exec stat -c %n%x {} \; How can I get the result with a ":" into the name of the file and the time of the last... (4 Replies)
Discussion started by: daniel.gbaena
4 Replies

6. Shell Programming and Scripting

how to read blank spaces

hi i have a file which store some data.the contents of my file is data1:data2 data3:data4 i have a script which read this file correct="$(cat /root/sh | cut -d: -f1)" i used this syntax..please help me which syntax is used to read blank spaces.and then remove it and after that how to read... (1 Reply)
Discussion started by: shubhig15
1 Replies

7. Solaris

Removing blank spaces

Hi , I want to go out of vi editor temporarily and execute a command in command prompt and again going back to the editor . Is it possible . Any help on this is really helpful. 1. Need to open vi 2. Temporarily come out and execute a command and go back to vi editor (6 Replies)
Discussion started by: rogerben
6 Replies

8. Shell Programming and Scripting

Remove blank spaces

Gents, Please can you help me.. to remove blank spaces :) Input ABSOLUTE , ,FALSE ,1035 ,28 ,669 ,1817.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ,1035 ,28 ,686 ,1817.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ,1035 ,28 ,670 ,1819.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ... (4 Replies)
Discussion started by: jiam912
4 Replies

9. UNIX for Dummies Questions & Answers

Remove blank spaces

Dear Masters, I want to remove all lines with blank spaces input file: a|abc|0|1 a|abc|2|3 b||3|5 c|def||7 d|def|0|1 Expected: a|abc|0|1 a|abc|2|3 d|def|0|1 I did this awk -F'|' '!/^$/' input (4 Replies)
Discussion started by: radius
4 Replies

10. UNIX for Advanced & Expert Users

Delete blank spaces and blank lines in a file

Hi Gurus, Somebody can say me how to delete blank spaces and blank lines in a file unix, please. Thank you for advanced. (10 Replies)
Discussion started by: systemoper
10 Replies
CSV2_TXT(5)							 MaraDNS reference						       CSV2_TXT(5)

NAME
csv2_txt - Description of txt and raw resource records in the csv2 zone file DESCRIPTION
Due to the complexity of TXT and RAW records, this man page is dedicated to describing the csv2 format of this RR. TXT and RAW rrs in MaraDNS' csv2 zone files can store any arbitrary binary data. Additionally, it is possible to arbitrarily divide up TXT records in to chunks (chunks, which RFC1035 call "character-string"s, are described below). ASCII AND UTF-8 DATA If a given TXT field or RAW record contains only ASCII data, creating a record is easy: Place the full data between single quotes, like this: a.example.com. TXT 'This is some text' ~ It is also possible, to place almost any printable ASCII characters between quotes. The '~' (tilde) character is not allowed unless csv2_tilde_handling has a value of 0; the '|' (pipe), '#' (hash) and non-printable ASCII control characters are not allowed in TXT data if the ~ is used to separate records. If there are any bytes with a value of 0x80 or more, the data must be UTF-8 encoded Unicode. The printable ASCII characters not allowed in quotes are the ' character, the '|' character, the '~' (tilde) character, and the '#' character. See BACKSLASH ESCAPE SEQUENCES below for information on adding these characters to TXT or RAW fields. UNQUOTED DATA Note that the record does not have to be quoted. As long as the record only contains ASCII alphanumeric data, and/or the characters '-', '_', '+', '%', '!', '^', and '=', the data can be unquoted as follows: c.example.com. TXT This_is_100%_unquoted_text_+symbols! It is also possible to mix quoted and unquoted text, such as this: d.example.com. TXT This' is a mix 'of_unquoted' and quoted 'text! Which will have its data look like this: This is a mix of_unquoted and quoted text! When mixing quoted and unquoted data, it is important to have all whitespace inside quotes. BACKSLASH ESCAPE SEQUENCES In order to accommodate storing non-UTF-8 high bit characters, the single quote character, non-printable ASCII control codes, the '|', '~', and '#' characters, and to permit multi-line TXT/RAW records (with comments allowed mid-record), the TXT/RAW RR allows backslashes. These backslashes only have significance outside of quoted text; if they are placed inside single quotes, they are not interpreted and result in a literal backslash being added to the resource record data. The following characters can be backslashed: ' When backslashed, the adds a literal quote to the resource record. whitespace When any whitespace is backslashed (space, newline, cr, and tab), this indicates that the record has not ended, and that more data for this resource will follow. This also allows comments to be placed in TXT and RAW resource records. What happens is that the backslash indicates that any whitespace characters (space, tab, carriage return, and line feed) are to be ignored until the next non-whitespace character that is not a # (hash). If a # is seen, this indicates that we ignore any and all characters until the next carriage return or line feed, and continue to ignore everything until the next non-whitespace character. See the section on multi-line and commented records for examples. 0123 When a number between 0 and 3 is backslashed, this indicates the beginning of a three-digit octal number. x When an x is backslashed, this indicates the beginning of a two-digit hexadecimal number. Note that, with the exception of the single quote, the backslash character is not used to remove the meta-significance of a given character. In particular, unlike other environments, it is not possible to backslash spaces. Spaces can be represented either as ' ' in quotes, x20, or as 40. Here are some examples of backslashed data. In this example, we see backslash sequences being used to store non-UTF-8 hi-bit data: e.example.com. TXT x80x81x82x83 ~ This same data can also be created as follows: f.example.com. TXT 200201202203 ~ Octal and hex information can be mixed: g.example.com. TXT 200x81202x83 ~ Literal single quotes can be placed in resource records: h.example.com. TXT 'perl -e '''print "A Perl of a TXT record! "'' ~ The above example produces this record: perl -e 'print "A Perl of a TXT record! "' ~ To render the '~' character, use the escape sequence x7e (outside of quotes). For example: h1.example.com. TXT 'http://ocf.berkeley.edu/'x7e'set' ~ Produces this record: http://ocf.berkeley.edu/~set To render the '|' character, use the escape sequence x7c: h2.example.com. TXT 'ls 'x7c' more' ~ Produces this record: ls | more To render the '#' character, use the escape sequence x23: h3.example.com. TXT 'Press 'x23' for customer service' ~ Produces this record: Press # for customer service MULTI-LINE AND COMMENTED RECORDS By utilizing backslashes followed by comments, it is possible to have multi-line and commented TXT and RAW records. The following resource record will span more than one line on an 80-column display: i.example.com. TXT 'Not only did the quick brown fox jump over the lazy dog, but the lazy dog jumped over the cat.' ~ Without affecting this resource record, the same data can be split over multiple lines: j.example.com. TXT 'Not only did the quick brown fox jump ' 'over the lazy dog, but the lazy dog' ' jumped over the cat.' ~ Some points: * The backslash must be outsize of the quotes (or a literal backslash will be added to the record) * The backslash must be present before any unquoted white space. Usually, the backslash is placed immediately after the quote character. * Unlike other environments, it does not matter whether or not there is invisible whitespace after the backslash. It is also possible to add comments after such a backslash as follows: k.example.com. TXT 'Not only did the quick brown fox jump ' # The fox 'over the lazy dog, but the lazy dog' # The dog ' jumped over the cat.' ~ # The cat Note that, since the third comment is not preceded by a backslash, this indicates the end of the resource record. There can also be multiple lines dedicated to comments (and, optionally, even blank lines) in the middle of TXT and RAW record data: k2.example.com. TXT 'This is some data ' # Here we have some comments followed by a blank line # Now we have some more comments, # followed by the rest of the data 'and this is the rest of the data' ~ MULTIPLE TXT CHUNKS TXT RRs may be divided up in to multiple "chunks" (RFC1035 calls these "character-string"s). A single chunk can be anywhere from zero to 255 bytes long. The default is to have one chunk, as follows: o.example.com. TXT 'TXT record with only one chunk' ~ It is also possible to have a record with multiple chunks. Chunks are delimited by an unquoted ';' character: p.example.com. TXT 'This is chunk one';'This is chunk two' ~ Or: q.example.com. TXT 'This is chunk one'; # Our first chunk This_is_chunk_two; # Our second chunk 'This is chunk three' ~ # Our final chunk Quoted ; characters simply add a ; to the record data. If a single TXT chunk is longer than 255 bytes long, the csv2 parser will report an error in the zone file: Single TXT chunk too long In order to resolve this, place unquoted ; characters in the record data so that each chunk is under 255 octets (bytes or characters) in length. It is possible to have zero length chunks: r.example.com. TXT 'chunk one';;'chunk three' ~ # Chunk two zero-length In particular, is is possible to have zero length chunks at the beginning and end of a TXT record: s.example.com. TXT ;'chunk two'; ~ # Chunks one and three zero-length Do not place semicolons at the beginning nor end of TXT records unless you wish to have these zero-length chunks. Chunk support only exists for TXT records. An unquoted ; character will cause a syntax error in a RAW record. RAW RECORDS With the exception of no support for chunk delimiters, and the addition of a numeric record type before the record data, the format for RAW records is identical to text records. For example, if we wish to have a "Kitchen Sink" RR record, which has the 8-bit binary numbers "16", "1", and "2", followed by the ASCII string "Kitchen sink+ data", we can specify this in any of the following manners: t1.example.com. RAW 40 x10x01x02'Kitchen sink'x2b' data' ~ t.example.com. RAW 40 200102Kitchen' sink+ data' ~ u.example.com. RAW 40 x10x01x02Kitchenx20sink+x20data ~ v.example.com. RAW 40 x1001x02 'Kitchen sink+ data' ~ w.example.com. RAW 40 x10 # Meaning: 16 x01 # Coding: 1 x02 # Sub-coding: 2 'Kitchen sink+ data' ~ # Data: 'Kitchen sink+ data' LEGAL DISCLAIMER
THIS SOFTWARE IS PROVIDED BY THE AUTHORS ''AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHORS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. AUTHOR
Sam Trenholme http://www.samiam.org/ MARADNS
January 2007 CSV2_TXT(5)
All times are GMT -4. The time now is 04:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy