General :: How To Ignore Rows With Specific Character In Csv File?

Mar 11, 2010

I have a csv file that has around 3 million rows. I want to process this file so that it creates a new file that contains only the rows that have 2 characters or less in the first column column.At the moment i am using SQL Loader but its taking too long so im wondering whether this would be easier if done in Unix?

View 8 Replies


ADVERTISEMENT

Programming :: Replace Specific Character After Specific Line By Awk?

Jul 19, 2010

I want to replace specific character in a file after every specific line. example as follows.

O 000000000000000000
A 111111111111111111
C 222222222222222222

[code]...

View 2 Replies View Related

General :: Producing A Specific ASCII Character In Ubuntu?

Oct 6, 2010

I'm used to holding the left Alt and entering the ASCII character whenever I'm using an unknown keyboard configuration and want to type a special character. For example, Alt-092 makes a backslash (). That's on Windows. Is there a way to do this in Ubuntu ?

Note : I also want to be able to use this in console mode. That means I don't want a solution involving a software with a GUI.

View 3 Replies View Related

General :: Script To Kill Process With Specific Character

Feb 11, 2011

I have a command that outputs as follows:

# lostjobs
user1 12983 1 0 Feb04 ? 00:00:00 dbr UT:msmenu
user1 18253 1 0 Feb09 ? 00:00:00 dbr UT:msmenu

[code]....

I know I can grab the ones with what I want to kill (which are the ones with question marks) with:

# lostjobs | grep ?

what I need to know is how can I loop through the results of the second one and kill them by id (the second column).

View 2 Replies View Related

General :: Use The Man / Info / Apropos Pages - Character Instructed The Shell To Interpret A Special Character As An Ordinary Character?

Mar 27, 2010

1.What character instructd the shell to interpret a special character as an ordinary character?

2.What directory contains some of the utilities available on the system in the form of binary files?

3. What command is used to search the location of a utility?

4. What command is used to instruct the editor to write the file and quit the editor?

5. What key quits the more utility and displays the shell prompt?

6. What command starts a child shell as the super user, taking on root's identity and environment?

7. Which wildcard characters can be used for searching all the files in the system that start with "A"?

8. The user name or login name of the super user is????

[Code]....

View 10 Replies View Related

Ubuntu :: Force Grub To Ignore Specific Kernel Version?

Feb 7, 2011

I just upgraded my storage server to maverick and it seems the 2.6.35-25 kernel doestn like the hardware im using
since im pretty sure its a hardware related problem and the previous kernel hastn the issue im currently booting this old kernel everytime i need the server by hand (using Shift during boot for the grub menu to appear)

well, it narrows down to the following question:
how can i exclude a specific grub entry - in my case the current kernel 2.6.35-25 - so only previous kernels OR future kernels from the next updates will have a chance to boot?

View 4 Replies View Related

Ubuntu :: Update Manager To Ignore Future Specific Updates Deselected?

Dec 4, 2010

When I installed 10.10 I uninstalled gwibber, empathy and ubuntuone. Twice now in Update Manager I've subsequently found gwibber on the list of possible updates. Is there a way to tell Update Manager not to include in future some programs, which I've uninstalled and don't want?

View 4 Replies View Related

General :: Determine Number Of Rows And Columns Of File In Shell?

Mar 4, 2010

if there's a tab-delimited file under /usr/desktop, how can I determine the number of rows and columns of the file in shell?And, if told the the 3rd column of the file contains only numerical values and all values in the 5th column are unique, how can I verify these in shell?

View 13 Replies View Related

General :: Windows - Make Emacs Ignore Changes To File On Disk?

Jul 2, 2010

I'm using andLinux and for whatever reason, emacs seems to think that the file I'm editing has been changed every time I try to edit/save and keeps reprompting me. Very annoying. Is there a way to make emacs stop checking the file on the disk?

View 1 Replies View Related

Programming :: Counting To A Specific Character?

Feb 12, 2010

I am loading variables for cXtXdXsX disk names into a script, and at present I have only accounted for there being 3 characters from c to t. I need to change it to a variable recognition so that it can count any number of charcters such as c1t , c10t , or c100t.

I can then take that information and use it with the following string to strip off the lead characters so as to make the 3 in $substr either a variable or redirect to multiple occurrences of raw based on the count returned.

sub raw {
$substr = substr ($_, 3);
$raw1 = substr ($substr, 0, -4);
$raw = lc($raw1);
}

how to count from the c to the t inclusive so I get 3, 4, 5, etc ...

View 9 Replies View Related

General :: File Management - Create Mirror Of Directory But Ignore Deletions?

Feb 7, 2011

I would like to create a directory public_html/archive that is a mirror of public_html/images, except that deletions in the images directory don't cause corresponding deletions in archive.

I was going to manage all of this in code, but then I figured, maybe the system can handle it for me in a robust way.

Note that the website will reference archive in real time, so it has to be an instant mirror and not something done nightly, etc.

View 2 Replies View Related

General :: Change File Character Set?

Aug 9, 2010

I would like to know how I can change a file so it has the same character encoding as files saved as comma separated csv files from Microsoft Excel.

I have tried using iconv to do this. code...

View 5 Replies View Related

General :: Remove Abnormal Character DEL From A File Name?

Jul 22, 2011

I have got certain files which somehow contain abnormal character "Del" "0x7f" or 177 which represents Del. And this is causing SVN to reject these files and abruptly end the process. I need to remove those characters from the file names but am not able to. find or grep do not search the files. This is how the file looks like with ls or find code...

View 3 Replies View Related

General :: Tool To Convert A File Of HEX To ASCII Character Set?

Feb 10, 2011

Is there a known tool to convert a file consisting of 2 byte Hex into ascii?

Note: - Maintain file offset listing in bytes code...

View 3 Replies View Related

Programming :: Deleting Rows From Text File In Perl?

Jun 21, 2010

How can I delete rows into text file in perl?

View 4 Replies View Related

General :: Find Folders With ONLY One Specific File In And Delete File And Folde

Oct 21, 2009

Many folders within a subdirectory some of which have lots of data in and some of which have only one specific file called produkt.fil inside.I need a command to find and delete those folders that contain ONLY the file produkt.fil - if other files exist (doesnt matter what they are) then they should be left alone. Note: produkt.fil exists in all of the folders always.

View 5 Replies View Related

OpenSUSE :: Openoffice - Will Not Import A Simple Csv File Of 684k Rows In My 64 Bit

Nov 24, 2010

This suite contains a database which is pure ****; it will not import a simple csv file of 684k rows in my 64 bit linux laptop, but the same file loads flawlessly in windows 32 bit access 2002.

View 9 Replies View Related

General :: Rename A File By Replacing Specific Letters In The File?

May 11, 2010

I used a script that renamed my file eg 'echo webutil.olb | tr [A-Z] [a-z]' i wanted to rename it back to webutil.olb. How do i do this for many other files that i have

View 3 Replies View Related

Ubuntu :: Default 10.04 File Explorer Ignore Capitals?

Aug 14, 2010

Is there a way to have the default 10.04 file explorer ignore capitals?

eg: If i have the files

BOB_1
BOB_2
BOB_3
bob_4
bob_5
bob_6

Ubuntu by default lists them in order starting with the lowercase letters 4-6, followed by the upper-case letters 1-3. I want them to be displayed in the order listed above.

If this isn't possible, can I rename every single file in a folder to be made up of only caps?

View 3 Replies View Related

Ubuntu :: Nautilus File Manager Ignore Files (e.g. *.pyc)?

Apr 16, 2011

I would like to have Nautilus not display the *.pyc files, is there a way to obtain this result?

View 4 Replies View Related

General :: RPM - Writing Script In Specific File

Apr 11, 2011

Is it possible to write ksh script in the spec file? The target is after I perform
rpm -i my_rpm.rpm
According to the spec file, ksh script will do some installation & configuration. For example run other script and edit some files.

View 1 Replies View Related

General :: Write File To A Specific Sector?

Jun 28, 2010

I need to copy a file into a Flash memory which is connected to my computer via USB. The file must start at a specific sector.
Can anyone guide me how to do this? (it can be through a C program, a line command, or any other way)

View 8 Replies View Related

General :: File Permission To Specific User?

Jan 13, 2011

i have created a file (by root user) called test.txt. Then i created a user bob. Now i want only bob to read/write/execute this file and no other user shall have any permission on it.

View 3 Replies View Related

General :: Specific File Name Renaming In All Sub Directories?

Apr 4, 2011

I have a dir (pub_html) with 45 sub dirsand in each there is a file with name file123.html) what command can I use to rename all files with this name in all sub dirs to file456.html ? I'm on opensuse 11.3

View 14 Replies View Related

General :: Can Get Version Number Of Tar Used To Create Specific Tar File?

May 19, 2010

I need to know the version number of tar used to create a specific tar file. How can I do that?

View 1 Replies View Related

General :: Showing The Line Count Of A Specific File

Mar 30, 2011

Is this the correct way to show the line count of a specific file?

cat file | grep * -c

View 3 Replies View Related

General :: Recursively Find A .doc File That Contains A Specific Word?

Aug 31, 2011

I'm using bash under Ubuntu.Currently this works well for the current directory:catdoc *.doc | grep "specificword" But I have lots of subdirectories with .doc files.How can I search for, let's say, "specificword" recursively?

View 2 Replies View Related

General :: Command For Finding Specific File Types?

Oct 15, 2009

If there is a command I can use to find specific file types? Say if I want to find all the jpg's in my home folder, but they don't have the .jpg extension in the name, how would I do it? Or can I set some kind of size parameter to find them? The ones I want are all from my digicam and roughly the same size.

View 7 Replies View Related

General :: Cannot Find Specific Glibc Tar File For Editing?

Feb 3, 2011

I have the tar file of glibc-2.12.1, but now I want to edit the SPEC file. I can't find it. For those that want a "why", I'm trying to make it smaller. So simply, where is the SPEC file for glibc? (rpmbuild cannot find it in the *.tar.gz file).

View 4 Replies View Related

General :: How To Find A File With Specific String Inside It

May 7, 2010

Is there any way i can find a file with specific word inside it.For example if i want to find a file which has some text written inside it.How would i form a command to search them?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved