On 29/01/13 23:36, Wjhonson wrote:
> Just use the NUM function in an I-Descript.
> Any external format, has to have at least one non-numeric in it.
>
I was thinking that. Just set field 2 to
NUM( @RECORD( x))
where x is your field number (provided it's not multi-value of course)
and then select
How about:
SELECT fname WITH MPAR.STATUS.DATE CONV "" = "[/]"
Since you seem to know exactly the kind of erroneous data you want to find.
On Tue, Jan 29, 2013 at 3:38 PM, Greg Coelho wrote:
> All,
>
> Can anyone help me with a query to find instances where an external date
> has been written
Just use the NUM function in an I-Descript.
Any external format, has to have at least one non-numeric in it.
-Original Message-
From: Bill Haskett
To: U2 Users List
Sent: Tue, Jan 29, 2013 3:01 pm
Subject: Re: [U2] Searching for 'Bad' Dates
Greg:
Can you do some
> From: Peter Cheney
> How about a DICT item that performs a match like "2n'/'2n'/'2n" on
> that field?
Better to simply look for anything non-numeric.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2
ll
need to get better at flushing these out.
Thanks,
Greg
From: Bill Haskett
To: U2 Users List
Date: 01/29/2013 06:17 PM
Subject: Re: [U2] Searching for 'Bad' Dates
Sent by:u2-users-boun...@listserver.u2ug.org
Greg:
That was the point. What happens is an
external format. In UniData I need UDT.OPTIONS 56 ON.
Bill
- Original Message -
*From:* coe...@american.edu
*To:* U2 Users List
*Date:* 1/29/2013 3:09 PM
*Subject:* Re: [U2] Searching for 'Bad' Dates
Bill,
This is only returning tho
:Re: [U2] Searching for 'Bad' Dates
Sent by:u2-users-boun...@listserver.u2ug.org
Greg:
Can you do something like:
:select {FileName} WITH EVAL "OCONV(MPAR.STATUS.DATE, 'D')" = ""
This works fine on UniData in PICK mode, where an invalid con
an empty string).
HTH,
Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates
: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates
All,
Can anyone help me with a query to find instances where an external date has
been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE
LIKE "..
./..." (the dates would be in the fomat
Write a new dict w/o the conversion code and select on it.
John Israel
Sent from my iPhone
On Jan 29, 2013, at 5:38 PM, "Greg Coelho" wrote:
> All,
>
> Can anyone help me with a query to find instances where an external date
> has been written to a date field? I would like to use ...WITH
: Tuesday, January 29, 2013 2:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates
All,
Can anyone help me with a query to find instances where an external date
has been written to a date field? I would like to use ...WITH
MPAR.STATUS.DATE LIKE "..
./...&qu
All,
Can anyone help me with a query to find instances where an external date
has been written to a date field? I would like to use ...WITH
MPAR.STATUS.DATE LIKE "..
./..." (the dates would be in the fomat: '12/16/12', but this field is set
with external formatting so I end up bringing back e
12 matches
Mail list logo