list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From
(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From
the column to NULL.
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jason Miller
Sent: Friday, April 16, 2010 3:29 AM
To: arslist@ARSLIST.ORG
Subject: OT: Extracting digits from a character field
** This might start a whole new debate
*To:* arslist@ARSLIST.ORG
*Subject:* OT: Extracting digits from a character field
** This might start a whole new debate (and kind of what I am looking to
do)... I remember learning that train of though (use an AL to run on the
client and use their resources when you can and built filters
)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Joe
a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 13:25:31
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You
]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Joe D'Souza jdso...@shyle.net
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 13:25:31
To: arslist@ARSLIST.ORG
Subject: Re: Extracting
I have a free form character field and need to extract digits from that field -
may be in a filter? Am on v7.1, oracle.
Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.
Help please
Atul
Hi,
I would probably loop through the whole string.
There are several ways to do this, and if the text is not too big, this
could be a way to do it using three filters in a filter-guide.
run-if()
set-fields
tmpStr = $string$
tmpStrDigits = $NULL$
#loop
runif('tmpStr' LIKE [0-9]%) #
/regexp.html
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field
I have a free form character field
it a shot if
MS-SQL is your underlying database.
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field
On MS-SQL, trying to replace one character with Null is not a good idea.
Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from
: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
On MS-SQL, trying to replace one character with Null is not a good idea.
Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList
(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
On MS-SQL, trying to replace one character with Null is not a good idea.
Fluxman
--Original Message--
From: Joe
11:42:21
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
Jim,
Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??
Joe
-Original Message-
From: Action Request
...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 1:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
Replaciing a character with Null is an oxymoron in MS-SQL. You would replace
a character with a zero-length string. Null and are not the same
You mean works incorrectly. LOL.
F
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 13:25:31
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You are right, I just tried
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field
You mean works incorrectly. LOL.
F
Sent from my
20 matches
Mail list logo