05-22-2008
How to extract first column with a specific character
Hi All,
Below is the sample data of my files:
O|A|571000689|D|S|PNH|S|SI
sadm|ibscml1x|
I|A|571000689|P|S|PNH|S|SI
sadm|ibscml1x|
O|A|571000689|V|S|PNH|S|SI
sadm|ibscml1x|
S|C|CAM|D|S|PNH|R|ZOA|2004
bscml1x|
I|C|CAM|P|S|PNH|R|ZOA|2004
bscml1x|
O|C|CAM|V|S|PNH|R|ZOA|2004
bscml1x|
I need to extract the first column that only contain "I" only?
Please assists
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all!
I need to change the final e every time when it is present in any word in column 1 to a; moreover, to change the final i again to a in any word in column 1, but just if word in column 2 begins with ha or si.
Here below you can see a sample of my data:
achwa ungeliachwa ungeli 1... (3 Replies)
Discussion started by: mjomba
3 Replies
2. Shell Programming and Scripting
Hi guys,
I have txt file and I would need to extract all the contents between specific line numbers.
Line 1: apple
Line 2: orange
Line 3: mango
Line 4: grapes
Line 5: pine apple
I need to extract the content between line 2 and 4, including the contents of Line 2 and 4 so the ouput... (2 Replies)
Discussion started by: gowrishankar05
2 Replies
3. Shell Programming and Scripting
Hello ,
i have a text file like this :
A123 c12AB c32DD aaaa
B123 23DS 12QW bbbb
C123 2GR 3RG cccccc
i want to remove the numbers from second and third column only.
i tried this :
perl -pe 's///g' file.txt > newfile.txt
but it will remove the number from... (7 Replies)
Discussion started by: shelladdict
7 Replies
4. Shell Programming and Scripting
This is a file that I have
test line 1 (55)
)
test line 2 (45)
)
I would like to change all the parens in position 1 of this file to a );
i only want to check position 1 in every line of the file. I have tried different varations of sed, but cannot seem to be able to limit it to... (1 Reply)
Discussion started by: JoeG
1 Replies
5. Shell Programming and Scripting
Hi there,
I need a help with extracting data from tab delimited file which look like this
#CHROM POS ID REF ALT Human Cow Dog Mouse Lizard
chr2 3033 . G C 0/0 0/0 0/0 1/1 0/0
chr3 35040 . G T 0/0 0/0 ./. 1/1 0/1
chr4 60584 . T G 1/1 1/1 0/1 1/1 0/0
chr10 7147815 . G A 0/0 1/1 0/0 0/0... (9 Replies)
Discussion started by: houkto
9 Replies
6. Shell Programming and Scripting
Hello friends,
I have a text file with many columns (no. columns vary from row to row) separated by space. I need to collect all the values from 18th column to the end from each line and group them as pairs and then numbering like below..
1. 18th-col-value 19th-col-value 2. 20th-col-value ... (5 Replies)
Discussion started by: prvnrk
5 Replies
7. Shell Programming and Scripting
Hi Experts,
I am new to UNIX. One of my file records are like below
220 IN C/A 515013 NULL NULL
220 IN C/A 515017 NULL NULL
225 IN C/A 333701 NULL NULL
225 IN C/A 515034 NULL NULL
225 IN C/A 499201 NULL NULL
225 IN C/A 499202 NULL NULL
The above mentioned records delimiter is... (4 Replies)
Discussion started by: suresh_target
4 Replies
8. Shell Programming and Scripting
Hi,
I need to extract the first character of second column of my file. If the condition matches, then I need to print the 2nd and 3rd column as my output
I tried below mentioned query but it was not working
awk -F'|' '$2~/^5/' Sgn_group.txt
File Name : Sgn_group.txt
country... (2 Replies)
Discussion started by: suresh_target
2 Replies
9. Linux
Hi,
I have a file like this (about 8 columns in total, this being the 2nd column)
gi_49482297_ref_YP_039521.1_
gi_49482297_ref_YP_039521.1_
gi_49482315_ref_YP_039539.1_
gi_49482315_ref_YP_039539.1_I want to remove the _ at the end of the line.
And at later stages I would want to replace the... (5 Replies)
Discussion started by: Syeda Sumayya
5 Replies
10. UNIX for Beginners Questions & Answers
file1:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,47
GETregistry,100,21592,0.00%,13
GEThomeLayout,100,30466,0.00%,17
file2:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,33
GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
XPT(4) BSD Kernel Interfaces Manual XPT(4)
NAME
xpt -- CAM transport layer interface
SYNOPSIS
None.
DESCRIPTION
The xpt driver provides a way for userland applications to issue certain CAM CCBs to the kernel.
Since the xpt driver allows direct access to the CAM subsystem, system administrators should exercise caution when granting access to this
driver. If used improperly, this driver can allow userland applications to crash a machine or cause data loss.
KERNEL CONFIGURATION
There is no kernel configuration required for the xpt driver. It is enabled when SCSI support is enabled in the kernel. There is one
instance of the xpt driver per CAM transport layer instance. Since there is currently only one CAM transport layer, there will only be one
instance of this driver.
IOCTLS
CAMIOCOMMAND This ioctl takes certain kinds of CAM CCBs and passes them through to the CAM transport layer for action. Only the following
CCB types are supported:
XPT_SCAN_BUS
XPT_RESET_BUS
XPT_SCAN_LUN
XPT_ENG_INQ
XPT_ENG_EXEC
XPT_DEBUG
XPT_DEV_MATCH
XPT_PATH_INQ
The above CCBs are the only ones supported since it makes more sense to send them through a generic passthrough device rather
than a passthrough device tied to a particular underlying SCSI device.
CAMGETPASSTHRU This ioctl takes an XPT_GDEVLIST CCB, and returns the passthrough device corresponding to the device in question.
FILES
/dev/xpt0 Character device node for the xpt driver.
DIAGNOSTICS
None.
SEE ALSO
cam(3), cam_cdbparse(3), pass(4), camcontrol(8)
HISTORY
The CAM transport layer driver first appeared in FreeBSD 3.0.
AUTHORS
Kenneth Merry <ken@FreeBSD.org>
BSD October 10, 1998 BSD