How to remove alphabets/special characters/space in the 5th field of a tab delimited file? Post: 302900745

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting Space delimited file to Tab delimited file

Hi all, I have a file with single white space delimited values, I want to convert them to a tab delimited file. I tried sed, tr ... but nothing is working. Thanks, Rajeevan D

2. Shell Programming and Scripting

insert a field into a tab delimited file

Hello, Can someone help me to do this with awk or sed? I have a file with multiple lines, each line has many fields separated with a tab. I would like to add one more field holding 'na' in between the first and second fields. old file looks like, 1, field1 field2 field3 ... 2, field1...

3. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Hello, I have about 100 files in a directory with fields which are tab delimited. I would like to append the file name as the first field and it has to be done as many times as the total lines in the file. For example, myFile1.txt has the following data: 1 x y z 2 a b ...

4. Shell Programming and Scripting

Merging files into a single tab delimited file with a space separating

I have a folder that contains say 50 files in a sequential order: cdf_1.txt cdf_2.txt cdf_3.txt cdf_3.txt . . . cdf_50.txt. I need to merge these files in the same order into a single tab delimited file. I used the following shell script: for x in {1..50}; do cat cdf_${x}.txt >>...

5. Shell Programming and Scripting

Remove the special characters from field

Hi, In source data few of columns are having special charates(like *) due to this i am not able to display the data into flat file.it's displaying the some of junk data into the flat file. source dataExample: Address1="XDERFTG * HYJUYTG" how to remove the special charates in a string

6. UNIX for Dummies Questions & Answers

Changing only the first space to a tab in a space delimited text file

Hi, I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks!

7. Shell Programming and Scripting

How to make tab delimited file to space delimited?

Hi How to make tab delimited file to space delimited? in put file: ABC kgy jkh ghj ash kjl o/p file: ABC kgy jkh ghj ash kjl Use code tags, thanks.

8. Shell Programming and Scripting

How to convert space&tab delimited file to CSV?

Hello, I have a text file with space and tab (mixed) delimited file and need to convert into CSV. # cat test.txt /dev/rmt/tsmmt32 HP Ultrium 6-SCSI J3LZ 50:03:08:c0:02:72:c0:b5 F00272C0B5 0/0/6/1/1.145.17.255.0.0.0 /dev/rmt/c102t0d0BEST /dev/rmt/tsmmt37 ...

9. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples...

10. Shell Programming and Scripting

Output file with <Tab> or <Space> Delimited

Input file: xyz,pqrs.lmno,NA,NA,NA,NA,NA,NA,NA abcd,pqrs.xyz,NA,NA,NA,NA,NA,NA,NA Expected Output: xyz pqrs.lmno NA NA NA NA NA NA NA abcd pqrs.xyz NA NA NA NA NA NA NA Command Tried so far: awk -F"," 'BEGIN{OFS=" ";} {print}' $File_Path/File_Name.csv Issue:...

LEARN ABOUT SUSE

fortune

FORTUNE(6)							 BSD Games Manual							FORTUNE(6)

NAME

     fortune -- print a random, hopefully interesting, adage

SYNOPSIS

     fortune [-aefilosw] [-m pattern] [[N%] file/dir/all]

DESCRIPTION

     When fortune is run with no arguments it prints out a random epigram.  Epigrams are divided into several categories, where each category is
     subdivided into those which are potentially offensive and those which are not.  The options are as follows:

     -a    Choose from all lists of maxims, both offensive and not.  (See the -o option for more information on offensive fortunes.)

     -e    Consider all fortune files to be of equal size (see discussion below on multiple files).

     -f    Print out the list of files which would be searched, but don't print a fortune.

     -l    Long dictums only.

     -m    Print out all fortunes which match the regular expression pattern.  See regex(3) for a description of patterns.

     -o    Choose only from potentially offensive aphorisms.  Please, please, please request a potentially offensive fortune if and only if you
	   believe, deep down in your heart, that you are willing to be offended.  (And that if you are, you'll just quit using -o rather than
	   give us grief about it, okay?)

		 ... let us keep in mind the basic governing philosophy of The Brotherhood, as handsomely summarized in these words: we believe in
		 healthy, hearty laughter -- at the expense of the whole human race, if needs be.  Needs be.
			     --H. Allen Smith, "Rude Jokes"

     -s    Short apothegms only.

     -i    Ignore case for -m patterns.

     -w    Wait before termination for an amount of time calculated from the number of characters in the message.  This is useful if it is exe-
	   cuted as part of the logout procedure to guarantee that the message can be read before the screen is cleared.

     The user may specify alternate sayings.  You can specify a specific file, a directory which contains one or more files, or the special word
     all which says to use all the standard databases.	Any of these may be preceded by a percentage, which is a number N between 0 and 100 inclu-
     sive, followed by a %.  If it is, there will be a N percent probability that an adage will be picked from that file or directory.	If the
     percentages do not sum to 100, and there are specifications without percentages, the remaining percent will apply to those files and/or
     directories, in which case the probability of selecting from one of them will be based on their relative sizes.

     As an example, given two databases funny and not-funny, with funny twice as big, saying

	   fortune funny not-funny

     will get you fortunes out of funny two-thirds of the time.  The command

	   fortune 90% funny 10% not-funny

     will pick out 90% of its fortunes from funny (the ``10% not-funny'' is unnecessary, since 10% is all that's left).  The -e option says to
     consider all files equal; thus

	   fortune -e

     is equivalent to

	   fortune 50% funny 50% not
	   -funny

FILES

     /usr/share/fortune

SEE ALSO

     regex(3), regcmp(3),

BSD
								  April 19, 1994							       BSD

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting Space delimited file to Tab delimited file

Discussion started by: jeevs81

2. Shell Programming and Scripting

insert a field into a tab delimited file

Discussion started by: ssshen

3. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Discussion started by: Gussifinknottle

4. Shell Programming and Scripting

Merging files into a single tab delimited file with a space separating

Discussion started by: Lucky Ali