07-07-2010
Hi Guru
Actually i took output of a MySql query (the result had 2 columns) into a file. There is white space between the values of two separate columns.
I tried saving it as a CSV file but it did not work. And the sed command u have given or the ones i have tried do not work either.
---------- Post updated at 04:42 PM ---------- Previous update was at 04:39 PM ----------
Hi,
The data within the file is like :
2000020354 Testing
2000020351 Sagar
2000020342 Hello
2000020334 asdsadsda
2000020329 Hello
2000020328 samir
2000020328 sameer
Its not multiple spaces but a single tab. and yet no sed command is working. Is it due to the reason that i saveed the result from a Mysql Query??
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Anybody can help me
How can I replace only four first white spaces with , or any other characters
aaaa 08/31/2004 08/31/2009 permanent Logical Processors in System: 64
bedad 08/16/2001 08/15/2011 permanent Logical Processors in System: 64
badnv14 05/31/2008 05/30/2013 permanent Logical... (5 Replies)
Discussion started by: pareshan
5 Replies
2. Shell Programming and Scripting
Dear all,
I am in a bit of a quandary. I have 400 text files which I need to edit and output in a very specific way.
Here is a sample text file copied from gedit ... The columns will come out a bit messed up but when I cat <file>, it gives a table with six columns (0-28, tot lob vol, vcsf,... (6 Replies)
Discussion started by: antonz
6 Replies
3. Shell Programming and Scripting
Hi
I tried to extract 19 characters (default) enclosed with in tag from a file using cut command. If the characters comprises of double space, the cut command gives the output with a single spacing.
file 1
<name>Kumar Rajasekaran</name>
cut -c7-26 "file1"
the out put i received is ... (48 Replies)
Discussion started by: Sekar1
48 Replies
4. AIX
Dear Gurus
Can you please advise me on how to Replace all TAB characters with white spaces in a text file in AIX?
Either using vi or any utilities (2 Replies)
Discussion started by: tenderfoot
2 Replies
5. Shell Programming and Scripting
How to rename multiple files by replacing the white spaces with underscore
for ex:
293TrexFH\ \ \ GSM855007RINGB_lhb11_binary.txt
293TrexFH\ \ \ GSM855007RINGB_lhb12_binary.txt
293TrexFH\ \ \ GSM855007RINGB_lhb13_binary.txt
293TrexFH_GSM855007RINGB_lhb11_binary.txt... (1 Reply)
Discussion started by: quincyjones
1 Replies
6. UNIX for Dummies Questions & Answers
I'm using sh on hp-ux. I've got a file that looks like this.
-5.65 175
-16.17 160
-13.57 270
-51.72 260
-8.30 360
-42.71 460
-.38 375
-.20 375
-4.15 170
-21.53 560
-18.84 360
I'd like to replace all the whitespace between the columns with one comma. I can't... (4 Replies)
Discussion started by: Scottie1954
4 Replies
7. Shell Programming and Scripting
Hi ,
I have a huge file with following records and I want to replace the last comma with ',NULL'. I try using SED but could not create a correct script .
In my opinion I need a script which can convert ,/n with ,NULL/n
1,CHANGE_MEMBER,2010-12-28 00:05:00,
2,CHANGE_MEMBER,2012-09-02... (8 Replies)
Discussion started by: Ajaypal
8 Replies
8. Shell Programming and Scripting
Hello,
I have a Comma separated input file with one of the sample records as below:
-9223372036854477528,"834","834003325515BXNI00101012013C","5","PLAN_VALUE","PPO, General
Cable","C",20130101,99991231,"A","2012-12-25-13.58.14.434000","ZPL2 ","2012-12-25-13.58.14.434000","ZPL2 ... (4 Replies)
Discussion started by: Praveenkulkarni
4 Replies
9. Shell Programming and Scripting
I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file:
EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies
10. UNIX for Beginners Questions & Answers
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies
LEARN ABOUT CENTOS
git-replace
GIT-REPLACE(1) Git Manual GIT-REPLACE(1)
NAME
git-replace - Create, list, delete refs to replace objects
SYNOPSIS
git replace [-f] <object> <replacement>
git replace -d <object>...
git replace -l [<pattern>]
DESCRIPTION
Adds a replace reference in refs/replace/ namespace.
The name of the replace reference is the SHA-1 of the object that is replaced. The content of the replace reference is the SHA-1 of the
replacement object.
Unless -f is given, the replace reference must not yet exist.
Replacement references will be used by default by all Git commands except those doing reachability traversal (prune, pack transfer and
fsck).
It is possible to disable use of replacement references for any command using the --no-replace-objects option just after git.
For example if commit foo has been replaced by commit bar:
$ git --no-replace-objects cat-file commit foo
shows information about commit foo, while:
$ git cat-file commit foo
shows information about commit bar.
The GIT_NO_REPLACE_OBJECTS environment variable can be set to achieve the same effect as the --no-replace-objects option.
OPTIONS
-f
If an existing replace ref for the same object exists, it will be overwritten (instead of failing).
-d
Delete existing replace refs for the given objects.
-l <pattern>
List replace refs for objects that match the given pattern (or all if no pattern is given). Typing "git replace" without arguments,
also lists all replace refs.
BUGS
Comparing blobs or trees that have been replaced with those that replace them will not work properly. And using git reset --hard to go back
to a replaced commit will move the branch to the replacement commit instead of the replaced commit.
There may be other problems when using git rev-list related to pending objects. And of course things may break if an object of one type is
replaced by an object of another type (for example a blob replaced by a commit).
SEE ALSO
git-tag(1) git-branch(1) git(1)
GIT
Part of the git(1) suite
Git 1.8.3.1 06/10/2014 GIT-REPLACE(1)