11-22-2018
If your field delimiter is sometimes a field delimiter and sometimes data, you need to be able to very clearly identify each occurrence of that character as either data or delimiter. If you can't specify a clear rule that unambiguously determines whether a given character is a delimiter or data, there is no way to identify field boundaries.
And when you have field delimiters that are sometimes data AND record delimiters that are sometimes data, you have a real mess.
Your best choice would be to choose a different field delimiter that cannot ever appear as data.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
How to replace any character in a file with a newline character using sed ..
Ex:
To replace ',' with newline
Input:
abcd,efgh,ijkl,mnop
Output:
abcd
efgh
ijkl
mnop
Thnx in advance.
Regards,
Sasidhar (5 Replies)
Discussion started by: mightysam
5 Replies
2. Shell Programming and Scripting
in vi editor I want to replace next line char by space
help me
eg:
input:
123
123
123
output:
123 123 123 (5 Replies)
Discussion started by: RahulJoshi
5 Replies
3. Shell Programming and Scripting
Hi ,
I have problem on replace char on text file
#!/bin/bash
echo "Enter Third value : "
read a
sed '2 s/192.160.1.1/cut -d"." -f3/$a/g' tcpip.txt > a.txt
I want replace line 2 on tcpip.txt with value a that I input but it's not run
Please help me (2 Replies)
Discussion started by: phillipss
2 Replies
4. Programming
Hi guys, I asked for help on programming forums and no one didn't helped me so I ask for help here. I am playing with some tasks from my book and I can't figure where did I get wrong.
From the first program I get a blank screen, program won't generate 10*10 matrix.
And second problem is I... (6 Replies)
Discussion started by: solaris_user
6 Replies
5. Shell Programming and Scripting
Hi Guys,
I wand find and replace all Extended ASCII Codes from all my log files.
My Log files:
/home/Kalr/PPool/Output
i have logs file in sub dir.
/home/Kalr/PPool/Output/X
/home/Kalr/PPool/Output/Y
/home/Kalr/PPool/Output/Z
My Abc.log file input:
Extended ASCII Codes :–
... (4 Replies)
Discussion started by: asavaliya
4 Replies
6. Shell Programming and Scripting
Hello,
I have a csv file with "^" as text delimiters and "|" as field delimiters. It's converted from a xls file. One record looks like this:
^Tablete Internet^|Archos|501838|^Tableta Internet ARCHOS 80 G9
...| ...
(more lines)
... "501|838"^|330.00|USD|sl|12|0|Link|^router wireless 150... (10 Replies)
Discussion started by: go0ogl3
10 Replies
7. Shell Programming and Scripting
hi,
i having a file with | seperated in which i need to search char in 3rd column and replace with null. i need to replace only the coulmn where character occurs in 3rd field
for eg:
file1.txt
xx|yy|xx|12
output file:
xx|yy||12 (5 Replies)
Discussion started by: rohit_shinez
5 Replies
8. Shell Programming and Scripting
HI All
Here is my Input file A.
I want to add extra char in the line base on below condition.
1> if Below second line is <xn:vsDataType>vsDataEUtranCellFDD</xn:vsDataType>
then <xn:VsDataContainer id= will be
<xn:VsDataContainer_id_1=
2 > if Below second line is... (4 Replies)
Discussion started by: asavaliya
4 Replies
9. Shell Programming and Scripting
Hi,
i have a huge file that need to check for a pattern that occur more than once in a line like below:-
#lkk>cd-m>A0DV0>192.134.1.1 blablabladsdjsk
jshdfskfslfs
#lqk>cd-m>A1SV0>192.14.11.1 blalalbnalablab
balablablajakjakjakja
#pldqw>sf-w>PH67FR>168.55.1.1 balablabala... (5 Replies)
Discussion started by: redse171
5 Replies
10. UNIX for Advanced & Expert Users
Unix File is pipe delimited with 17 fields. We may get extra pipes in data also.
We may get \n char (1 or more \n in one field or multi fileds) in data in any field.
Need to replace \n true ( line separator) with 'space and bell char space' chars (' \a ') Not data \n.
Input:... (1 Reply)
Discussion started by: rajeshkumare
1 Replies
LEARN ABOUT REDHAT
replace
REPLACE(1) General Commands Manual REPLACE(1)
NAME
replace - A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place
in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings.
USAGE
replace [-?svIV] from to from to ... -- [files]
or
replace [-?svIV] from to from to ... < fromfile > tofile
SYNOPSIS
replace [-?|-I] [-s] [-v]
DESCRIPTION
replace
-?|-I info
-s silent
-v verbose
EXTRA INFO
Special characters in from string:
^ Match start of line.
$ Match end of line.
Match space-character, start of line or end of line. For a end the next replace starts locking at the end space-character. A
alone in a string matches only a space-character.
EXAMPLE
this command swaps a and b in the given files:
shell> replace a b b a -- file1 file2 ...
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with
no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mer-
curmedia.com)
20 December 2000 REPLACE(1)