Data Conversion Error

[Chris Sharman]

>I am attempting to use QTP to initialize a numeric data item that contains
>non-numeric data. Some of the records contain valid numeric data in the
>field where others (1000's) do not. How do I initialize only the fields
>that are not numeric? I keep getting a data conversion error.

Nasty thing to do.
You should put a redefinition in your dictionary for that item, so that you can
refer to it as text:

Eg:

 my-number	zoned*4
_my-not-number	char*4

Then in your QTP:

select <infile> if matchpattern(my-not-number,"(#| )*")

This should exclude all the unwanted records before any data conversion gets
tried, and therefore before any errors get generated.
______________________________________________________________________
Chris Sharman			Chris.Sharman@CCAgroup.co.uk
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.