04-23-2007
Extracting part of a string
Hi all,
I have to extract only the second part of a database column (VARCHAR) and the value is seperated by a "~"
xyz~
chxyz36r~
abder~000082685
mnops~000083554
fulfil302~00026
Above are some examples of the values and for each record I have to extract the value after "~" , if there is a value by using shell scripts. As you can see they are multiple lenghts and in multiple formats and the only way to seperate them is by a "~".
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to extract the uncommon (better say incremental) part from 2 files say file_1 and file_2.
file_2 contains everything that is in file_1. That is file_2 has been created internally somehow :
cat file_1 temp_file > file_2
My objective is to extract the temp_file part from... (2 Replies)
Discussion started by: sabyasm
2 Replies
2. Shell Programming and Scripting
Hi,
I was wondering if there is an easy way to strip off the required basename. I have a script called apb0110021.sh and the contents of the script are
typeset -u MScript=`basename $0 | cut -d. -f1`
scriptname=sys.Audit.ksh
parms="PROJECT1 dsAudit $MScript 1 BEGIN"
$SCRIPTS/$scriptname... (3 Replies)
Discussion started by: madhunk
3 Replies
3. Shell Programming and Scripting
JADE TRADER 143W MYPEN 40 HC M X10 28 7 1 0
MYPEN 20 GP X X10 15 2 1 0
MYPEN 40 GP X X10 28 7 1 0
MYPEN 20... (6 Replies)
Discussion started by: finalight
6 Replies
4. Shell Programming and Scripting
Hi,
I am trying to extract part of a line using "awk". My requirement is to extract the value $6 (which is the last parameter) from a line. As the sixth value contains some space, i am getting only part of the string. so i am trying to extract from $6 to the end of the buffer.
How to do it... (7 Replies)
Discussion started by: venkat_k
7 Replies
5. Shell Programming and Scripting
Hi Guys,
I have a very large XML feed (2.7 MB) which crashes the server at the time of parsing. Now to reduce the load on the server I have a cron job running every 5 min.'s. This job will get the file from the feed host and keep it in the local machine.
This does not solve the problem as... (9 Replies)
Discussion started by: shridhard
9 Replies
6. Shell Programming and Scripting
Hi,
I have a file few hundred MB's with text like one below in single line.
20091117 abc xyg 20091117 def ghi 20091118 ppp ttt 20091118 zzz zzz xxx
I need to extract part of line from 1st occurence of pattern 20091117
till first occurence of another pattern 20091118.
I tried... (3 Replies)
Discussion started by: artistic94555
3 Replies
7. UNIX for Dummies Questions & Answers
I have the code
message={TP=2012:09:23:00:00:00:GMT,SD=2012:09:23:00:00:00:GMT,SP=2,FT=CCGT,FG=3605}
I want to extract the FG=3605 parts of this. Please help. I am trying to do this using awk or unix. (5 Replies)
Discussion started by: JenniferTopham
5 Replies
8. Shell Programming and Scripting
Hi,
I needed to extract some specific characters from a string based on user input. For example: After the script executes the user enters the following details:
Please enter the string: This is a shell script
Please enter the starting position: 11
Please enter the number of characters to be... (4 Replies)
Discussion started by: ChandanN
4 Replies
9. Shell Programming and Scripting
I have a string:
2015-04-16 07:30:05,625000 +0900 xxxx.com
I just want to extract the time from the above line I am using the below syntax
x=~ /(.*) (\d+)\:(\d+)\:(\d+),(.*)\.com/
$time = $2 . ':' . $3 . ':' . $4;
print $time
But it is not working. Can some1 please help (2 Replies)
Discussion started by: karan8810
2 Replies
10. Shell Programming and Scripting
Hi All,
I have log files as below.
log1.txt
<table name="content_analyzer" primary-key="id">
<type="global" />
</table>
<table name="content_analyzer2" primary-key="id">
<type="global" />
</table>
Time taken: 1.008 seconds
ID = gd54321bbvbvbcvb
<table name="content_analyzer"... (7 Replies)
Discussion started by: ROCK_PLSQL
7 Replies
LEARN ABOUT DEBIAN
tangram::type::scalar
Tangram::Type::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Scalar(3pm)
NAME
Tangram::Type::Scalar - map scalar fields
SYNOPSIS
use Tangram;
Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string => [ qw( name firstName gender ) ],
int => [ qw( age ) ],
real => [ qw( height weight ) ],
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string =>
{
name => { sql => 'VARCHAR(100)' },
1stname => {
col => 'firstName',
sql => 'VARCHAR(100) NULL' },
gender => undef()
},
DESCRIPTION
Classes Tangram::Type::String, ::Int and ::Real and ::Ref are responsible for mapping the various subtypes of scalars. The first three map-
pings are documented here since they differ very little. See Tangram::Type::Ref::FromMany for information on mapping references.
Tangram::Type::String uses DBI's quote() method to quote strings if that method is available, thus making it possible to store binary
objects or multiline text in databases that support it (thanks to Marian Kelc <marian.kelc@ruhr-uni-bochum.de> for suggesting this improve-
ment).
The three predefined typetags "string", "int" and "real" are for the corresponding Perl scalar subtypes.
Each scalar field is stored in a single column of the table associated to the class.
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
* col
* sql
* automatic
"col" sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Over-
ride if the field name is not an acceptable SQL column name.
"sql" sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings,
'INT NULL' for ints and 'REAL NULL' for reals.
"automatic", if set to true, tells Tangram not to save the field to storage. This is useful for auto-increment or timestamp columns.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.
perl v5.8.8 2006-03-29 Tangram::Type::Scalar(3pm)