02-21-2008
How to change a specific character in a file
Hi,
I have a data file with following structure:
a|b|c|d|3|f1|f2|f3
a|b|c|d|5|f1|f2|f3|f4|f5
I want to change this data to:
a|b|c|d|3|f1;f2;f3
a|b|c|d|5|f1;f2;f3;f4;f5
Data in column 5 tells the number of following fields. All fields delimiter after the 5th column needs to be changed to ";"
Please help how can this be done in any scripting language sed, awk or perl?
Regards
Sandeep
10 More Discussions You Might Find Interesting
1. HP-UX
For counting the occurences of specific character in the file
I am issuing the command
grep -o 'character' filename | wc -w
It works in other shells but not in HP-UX as there is no option -o for grep.
What do I do now? (9 Replies)
Discussion started by: superprogrammer
9 Replies
2. Shell Programming and Scripting
I'm trying to count the number of 2 specific characters in a very large file. I'd like to avoid using gsub because its taking too long.
I was thinking something like:
awk '-F' { t += NF - 1 } END {print t}' infile > outfile
which isn't working
Any ideas would be great. (3 Replies)
Discussion started by: dcfargo
3 Replies
3. Shell Programming and Scripting
Hi,
I need to add Pipe (|) at 5th and 18th position of all records a file. How can I do this?
I tried to add it at 5th position using the below code. It didnt work. Please help!!!
awk '{substr($0,5,1) ~ /|/}{print}' $input_file > $temp_file (1 Reply)
Discussion started by: gpaulose
1 Replies
4. Shell Programming and Scripting
Hi All, I'm struggling with a problem.
Data file example:
Brown|32 inches|apple|monkey
Green|12 feet|grape|cat
Blue|32 inches|banana|dog
Black|23 inches|pear|horse
I need to change the value '32 inches' in the third line, and only the third line, while keeping the rest of the file the... (7 Replies)
Discussion started by: jsmith_4242
7 Replies
5. 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
6. UNIX for Advanced & Expert Users
hi,
I want to store from 102 character to 128 character to a variable of header record which can be identified as 'HDR' which is the first 3 characters in the same line of a same.txt file.
Please advise.
Thanks (4 Replies)
Discussion started by: techmoris
4 Replies
7. Shell Programming and Scripting
i have a reqirement to adjust the data in a file based on a perticular character
the sample data is as below
483PDEAN CORRIGAN 52304037528955WAGES 50000
89BP ABCD MASTER352 5434604223735428 4200
58BP SOUTHERN WA848 ... (1 Reply)
Discussion started by: pema.yozer
1 Replies
8. Shell Programming and Scripting
Hello guys,
I would need to remove the last character ")" of a specific line. This can be from any line. Your help is appreciated. Below is the line.
HOSTNAME=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP))
Please help. (6 Replies)
Discussion started by: sang8g
6 Replies
9. Shell Programming and Scripting
Hi,
I am writing a shell script where I want that # should be added in all those lines as the first character where the pattern matches.
file has lot of functions defined
a.sh
#!/bin/bash
fn a {
beautiful evening
sunny day
}
fn b {
}
fn c {
hello world .its a beautiful day
... (12 Replies)
Discussion started by: ashima jain
12 Replies
10. Shell Programming and Scripting
I will appreciate if you help me here in this script in Solaris Enviroment.
Scenario:
i have 2 files :
1) /tmp/TRANSACTIONS_DAILY_20180730.txt:
201807300000000004
201807300000000005
201807300000000006
201807300000000007
201807300000000008
2)... (10 Replies)
Discussion started by: teokon90
10 Replies
LEARN ABOUT DEBIAN
tangram::type::dump::storable
Tangram::Type::Dump::Storable(3pm) User Contributed Perl Documentation Tangram::Type::Dump::Storable(3pm)
NAME
Tangram::Type::Dump::Storable - map any Perl object as scalar dump via Storable
SYNOPSIS
use Tangram::Core;
use Tangram::Type::Dump::Storable; # always
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
storable =>
{
diary => # diary is a perl hash
{
col => 'diarydata',
sql => 'BLOB',
indent => 0,
terse => 1,
purity => 0
},
lucky_numbers => 'int', # use defaults
}
DESCRIPTION
Maps arbitrary Perl data structures by serializing to a string representation. The persistent fields are grouped in a hash under the
"storable" key in the field hash.
Serialization is done by Storable::freeze, which traverses the Perl data structure and creates a binary representation of it. The resulting
string will be mapped to the DBMS as a scalar value. During restore, the scalar value will be restored with Storable::thaw to reconstruct
the original data structure.
The structure should be able to contain pretty much anything that may be safely dumped by Storable. However, be aware that Tan-
gram::Type::Dump::flatten() must be able to find the persistent objects in the field. Unless you're using classes that are implemented in
C and contain other objects, you should be fine (Set::Object has a special work-around).
The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a
string. The hash uses the following fields:
* col
* sql
* indent
* terse
* purity
The optional fields "col" and "sql" specify the column name and the column type for the scalar value in the database. If not present, "col"
defaults to the field name and "sql" defaults to VARCHAR(255). Values will be always quoted as they are passed to the database.
The remaining optional fields control the serialization process. They will be passed down to Data::Dumper as values to the corresponding
Data::Dumper options. The default settings are: no indentation ("indent=0"), compact format ("terse=1"), and quick dump ("purity=0").
AUTHOR
This mapping was contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de>
perl v5.8.8 2006-03-29 Tangram::Type::Dump::Storable(3pm)