Hi
I have a file which have say about 100,000 records..
the records in it look like
Some kind of text 1234567891 abcd February 14, 2008 03:58:54 AM lmnop
This is how it looks.. if u notice there is a 2byte space between each column.. and im planning to replace that with '|' ..
... (11 Replies)
Hi,
I need to append the data in to a file by using tab delimiter.
eg:
echo "Data1" >> filename.txt
echo "\t" >> filename.txt (its not working)
echo "Data2" >> filename.txt.
the result sould be like this.
Data1 Data2 (6 Replies)
OK I will do my best to explain what I need help with.
I am trying to format an ldif file so I can import it into Oracle oid.
I need the file to look like this example. Keep in mind there are 3000 of these in the file.
changetype: modify
replace: userpassword
dn:... (0 Replies)
Hi All,
I have two files one of which having some mobile numbers and corresponding value whose sample content as follows:
9058629605,8.0
9122828964,30.0
And in second file complete details of all mobile numbers and sample content as follows and delimeter used is comma(,):
... (8 Replies)
I’m new to Linux script and not sure how to filter out bad records from huge flat files (over 1.3GB each). The delimiter is a semi colon “;”
Here is the sample of 5 lines in the file:
Name1;phone1;address1;city1;state1;zipcode1
Name2;phone2;address2;city2;state2;zipcode2;comment... (7 Replies)
Dears,
I'm new to shell scripting and i was wondering if you can help me with following matter.
I have a file containing 400,000 records. The file contains two columns like:
00611291,0270404000005453
25262597,1580401000016155
25779812,1700403000001786
00388934,1200408000000880... (1 Reply)
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Required No.of field = 12
Let say you got a “~” delimited input file and this file has 6 input fields and now I want to add 12-5=7 number of “~” into this input file in order to make it 12 fields
datafile can have n number of records
ex.,
a~b~c~d~12~r
a~b~c~d~12~r
a~b~c~d~12~r... (19 Replies)
My file has data that looks like below:
more data.txt
I wish to display each string seperated by a delimiter :
Expected output:
I tried the below but I m not getting every split string on a new line.
#!/bin/bash
for i in `sed 's/:/\\n/g' data.txt`;
do
echo -n... (2 Replies)
I have an input file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
Output :
1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000
OR
1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
LEARN ABOUT OSF1
trbsd
trbsd(1) General Commands Manual trbsd(1)NAME
trbsd - Translates characters
SYNOPSIS
trbsd [-Acs] string1 string2
trbsd -d [-Ac] string1
The trbsd command copies characters from the standard input to the standard output with substitution or deletion of selected characters.
OPTIONS
Translates on a byte-by-byte basis. When you specify this option, trbsd does not support extended characters. Complements (inverts) the
set of characters in string1 with respect to the universe of characters whose codes are 001 through 377 octal if you specify -A, and all
characters if you do not specify -A. Deletes all characters in string1 from output. Changes characters that are repeated output charac-
ters in string2 into single characters.
DESCRIPTION
Input characters from string1 are replaced with the corresponding characters in string2. The trbsd command cannot handle an ASCII NUL
( 00) in string1 or string2; it always deletes NUL from the input.
The tr command is a System V compatible version of trbsd.
Abbreviations such as a-z, standing for a string of characters whose ASCII codes run from character a to character z, inclusive, can be
used to introduce ranges of characters. Note that brackets are not special characters.
Use the escape character (backslash) to remove the special meaning from any character in a string. Use the followed by 1, 2, or 3
octal digits for the code of a character.
If a given character appears more than once in string1, the character in string2 corresponding to its last appearance in string1 will be
used in the translation.
EXAMPLES
To translate braces into parentheses, enter: trbsd '{}' '()' <textfile >newfile
This translates each { (left brace) to a ( (left parenthesis) and each } (right brace) to a ) (right parenthesis). All other char-
acters remain unchanged. To translate lowercase ASCII characters to uppercase, enter: trbsd a-z A-Z <textfile >newfile The two
strings can be of different lengths: trbsd 0-9 # <textfile >newfile
This translates each digit to a # (number sign); if string2 is too short, it is padded to the length of string1 by duplicating its
last character. To translate each string of digits to a single # (number sign), enter: trbsd -s 0-9 # <textfile >newfile To trans-
late all ASCII characters that are not specified, enter: trbsd -c ' -~' 'A-_' <textfile >newfile
This translates each nonprinting ASCII character to the corresponding control key letter ( 01 translates to A, 02 to B, and so
on). ASCII DEL (177), the character that follows ~ (tilde), translates to a ? (question mark).
SEE ALSO
Commands: ed(1), sh(1), tr(1)
Files: ascii(5)trbsd(1)