This example appears to definitely rearrange the name, but i'm still having issues with my AWK script.
I'm writing this in a script, rather than simply trying to perform it in one line. How can I tell my AWK script to take say field 3 and split it into two usable fields? Because then i'm needing to print those two fields, much like you did.
Edit: Also, please keep in mind that these are fields with a colon delimiter.
I figured I would help clarify my question a little bit..
Input:
Desired Output:
I'm printing the new headers of First Name / Last Name using a formatted printf statement. I want to then print the names (which I need to separate the field into two separate usable fields first) using the same formatted printf statement.
In my begin block, I have:
And in my action block, I have:
My action block seems to be where i'm running into a problem at.
I have a tab delimitted dataset with 4 fields. I like to split the second field into two, and have 5 fields. I like to remove the "-" sign when I get a new fiel. would you help?
It is like:
1223 100-5 rr dd
I need it like:
1223 100 5 rr dd (2 Replies)
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
Hello,
For the input file, I am trying to split those records which have multiple values seperated by '|' in the last input field, into multiple records and each record corresponds to the common input fields + one of the value from the last field.
I was trying with an example on this forum... (4 Replies)
I am trying to update an older program on a small cluster. It uses individual files to send jobs to each node. However the newer database comes as one large file, containing over 10,000 records. I therefore need to split this file. It looks like this:
HMMER3/b
NAME 1-cysPrx_C
ACC ... (2 Replies)
Hi experts,
I've used several solutions from this forum to delete nonsense and rearrange data in the project file I'm working on. I'm hoping you guys can give me some tips on further rearranging the data (I've seen a few solutions by searching, but one specific item has me stumped, which is only... (5 Replies)
Filename1.xml NO 2012-11-16 02:00:27 20121115/pathname/ asia
Filename1.rec YES 2012-11-16 01:20:24 20121115/pathname asia
FIleName2.xml YES 2012-11-16 01:20:25 20121115/pathaname asia
if the file content are... (6 Replies)
Hi All,
We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1" position in the 3rd field and from 4th field need to extract the information from the same position.
... (4 Replies)
I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines.
If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
In the awk below I am trying to set/update the value of $14 in file2 in
bold, using the matching NM_ in $12 or $9 in file2
with the NM_ in $2 of file1.
The lengths of $9 and $12 can be variable but what is consistent is the start pattern
will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT PHP
mongoexception
MONGOEXCEPTION(3) 1 MONGOEXCEPTION(3)The MongoException classINTRODUCTION
Default Mongo exception.
This covers a bunch of different error conditions that may eventually be moved to more specific exceptions, but will always extend Mon-
goException.
o The MongoSomething object has not been correctly initialized by its constructor Code: 0 Probably your Mongo object is not con-
nected to a database server.
o zero-length keys are not allowed, did you use $ with double quotes? Code: 1 You tried to save "" as a key. You generally should
not do this. "" can mess up subobject access and is used by MongoDB internally. However, if you really want, you can set
mongo.allow_empty_keys to true in your php.ini file to override this sanity check. If you override this, it is highly recommended
that you set error checking to strict to avoid string interpolation errors.
o '.' not allowed in key: <key> Code: 2 You attempted to write a key with '.' in it, which is prohibited.
o insert too large: <size>, max: <max> Code: 3 You're attempting to send too much data to the database at once: the database will
only accept inserts up to a certain size (currently 16 MB).
o no elements in doc Code: 4 You're attempting to save a document with no fields.
o size of BSON doc is <size> bytes, max <max>MB Code: 5 You're attempting to save a document that is larger than MongoDB can save.
o no documents given Code: 6 You're attempting to batch insert an empty array of documents.
o MongoCollection::group takes an array, object, or MongoCode key Code: 7 Wrong type parameter send to MongoCollection.group(3).
o field names must be strings Code: 8 You should format field selectors as array("field1" => 1, "field2" => 1, ..., "fieldN" => 1).
o invalid regex Code: 9 The regex passed to MongoRegex is not of the correct form.
o MongoDBRef::get: $ref field must be a string Code: 10
o MongoDBRef::get: $db field must be a string Code: 11
o non-utf8 string: <str> Code: 12 This error occurs if you attempt to send a non-utf8 string to the database. All strings going
into the database should be UTF8. See php.ini options for the transition option of quieting this exception.
o mutex error: <err> Code: 13 The driver uses mutexes for synchronizing requests and responses in multithreaded environments. This
is a fairly serious error and may not have a stack trace. It's unusual and should be reported to maintainers with any system
information and steps to reproduce that you can provide.
o index name too long: <len>, max <max> characters Code: 14 Indexes with names longer than 128 characters cannot be created. If you
get this error, you should use MongoCollection.ensureIndex(3)'s "name" option to create a shorter name for your index.
CLASS SYNOPSIS
MongoException
MongoExceptionextends
Exception
PHP Documentation Group MONGOEXCEPTION(3)