01-14-2009
Finding & Replacing specific Fields
All
I have a very large file (aproximately 150,000) as shown below separated by pipe "|". I need to replace data in 2, 16, 17, 23 fields that are of time stamp format. My goal is to look in those fields and it ends with "000000|" then replace it with "000|". In other words, make it as 6 digit micro second value. Some of the records may not end with "000000|". In that case, I shouldn't replace that value. I am enclosing couple of sample records.
Record 1)
154842|2007-11-15 09:33:28.540000000|126074|||02|ALLEN|
DEBORAH|G||2006-06-19 00:00:00|U78BA5|||T|2007-11-15 09:33:28.540000000|2007-11-14 00:00:00|O|O|O|O| |19
00-01-01 00:00:00|2|N/A|DEALLEN
Record 2)
72421|2005-10-07 11:24:00|114307| N/A|Z125A|02|HOLLIS|MENDEZ|D||2005-10-08 00:00:00|U20AWX||64602|A|2005-10-08 00:00:00|2005-11-16 00:00:00|A|A|A|A| |2005-10-0
8 00:00:00|1|Z125|MEHOLLIS
Thanks a lot,
Sekhar
10 More Discussions You Might Find Interesting
1. Solaris
Can anyone help me find and replace blank rows in a file with a numeric value (ie blankrow=someTxtOrNumValue), the file is over 500,000 rows long so it would need to be the quickest way as I'll need to do this for multiple files...I would be greatfull for any suggestions....thanks
sample file:... (2 Replies)
Discussion started by: Gerry405
2 Replies
2. Shell Programming and Scripting
Hi All,
Could anyone help me out in the below requirement:
I have a text(XML) file like this:
- <Dim2>
<Properties Name="" State="2" ShowHir="-1" ApplyFilter="-1" ExpandToLevel="1" BreakHierType="1" MaxDepth="1" SlicerSelectOptions="1" ShowLeaf="0" HasGroup="0" />
<Expanded... (1 Reply)
Discussion started by: vivekshady
1 Replies
3. Shell Programming and Scripting
Hi everyone.
Could u be so kind and help me with on "simple" shell script?
1. i need to search a file line by line for a pattern.
example of a lines in that file
2947 domain = feD,id = 00 0A 02 48 17 1E 1D 39 DE 00 0E 00,Name
Values:snNo = f10
Add AttFlag = 0
2. i need to find... (0 Replies)
Discussion started by: dusoo
0 Replies
4. Shell Programming and Scripting
#cat BATCH007.TXT
01,661060052,061000104,081118,0915,07,80,1,2/
99,,,2/
I have this file called BATCH007.TXT. I am trying to change fields 2 and 3 on line 2 to have zeroes. Like this:
01,661060052,061000104,081118,0915,07,80,1,2/
99,0,0,2/
I can use these commands to print identify the... (2 Replies)
Discussion started by: ddurden7
2 Replies
5. Shell Programming and Scripting
Hi!
I have a file somefile.txt:
12, 1, a, b, c, d, e, f
12, 1, a, b, c, d, e, f
17, 51, a, b, c, d, e, f
...
I've made this script to read two fields from a line and output a third:
cat somefile.txt | awk -F, '{if ($1 == "12" && $2== "1")
print "19";
else if ($1 == "17" && $2== "51")... (8 Replies)
Discussion started by: Tr0cken
8 Replies
6. Shell Programming and Scripting
Hi all,
say for example i have the next input file
30
Au 7.500000 7.500000 5.774000
Au 7.500000 8.995000 8.363000
Au 7.500000 6.005000 8.363000
Au 20.633000 7.500000 9.226000
Au 20.632000 6.005000 6.637000
Au 20.632000 ... (4 Replies)
Discussion started by: ezitoc
4 Replies
7. Shell Programming and Scripting
Hello;
I have the output data set from:
egrep -i 'warning| error| fail' /var/adm/syslog/syslog.log
Jan 31 12:02:18 fidsrv vmunix: LVM: WARNING: VG 128 0x001000: LV 5: Some I/O requests to this LV are waiting
Jan 31 12:02:23 fidsrv vmunix: Asynchronous write failed on LUN (dev=0x100000f)... (3 Replies)
Discussion started by: delphys
3 Replies
8. Shell Programming and Scripting
Hallo Everyone.
I have to admit I'm shell scripting illiterate . I need to find certain strings in several text files and replace each of the string by unique & corresponding text.
I prepared a csv file with 3 columns: <filename>;<old_pattern>;<new_pattern>
... (5 Replies)
Discussion started by: gordom
5 Replies
9. Shell Programming and Scripting
Hallo Team,
I would like to replace filed 4 and 7 with filed 39 how can i achieve this ?
-bash-3.2$ cat dip1.csv| cut -f4,7,24,36,39 -d","|sort -u
+27113996891,+27113996891,196.35.130.52,828854047,+27873500077
+27116452690,+27825702918,10.0.109.13:5060,+27116452690,+27116452690... (2 Replies)
Discussion started by: kekanap
2 Replies
10. Shell Programming and Scripting
Greetings.
I've got a csv file with data along these lines:
Spumoni's Pizza Place, Placemats n Things, Just Lamps
Counterfeit Dollars by Vinnie, Just Shades, Dollar StoreI want to replace the entire comma-delimited field if it matches something ending in "Place" or beginning with "Dollar",... (2 Replies)
Discussion started by: palmfrond
2 Replies
LEARN ABOUT DEBIAN
html::formhandler::fields
HTML::FormHandler::Fields(3pm) User Contributed Perl Documentation HTML::FormHandler::Fields(3pm)
NAME
HTML::FormHandler::Fields - internal role for form and compound fields
VERSION
version 0.40013
SYNOPSIS
A role to implement field attributes, accessors, etc. To be applied to HTML::FormHandler and HTML::FormHandler::Field::Compound.
fields
The field definitions as built from the field_list and the 'has_field' declarations. This provides clear_fields, add_field,
remove_last_field, num_fields, has_fields, and set_field_at methods.
field( $full_name )
Return the field objct with the full_name passed. Will return undef if the field is not found, or will die if passed a second parameter.
field_index
Convenience function for use with 'set_field_at'. Pass in 'name' of field (not full_name)
sorted_fields
Calls fields and returns them in sorted order by their "order" value. Non-sorted fields are retrieved with 'fields'.
clear methods
clear_data
clear_fields
clear_error_fields
Dump information
dump - turn verbose flag on to get this output
dump_validated - shorter version
AUTHOR
FormHandler Contributors - see HTML::FormHandler
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Gerda Shank.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-25 HTML::FormHandler::Fields(3pm)