>PMFJI
>TRANSFORM() doesn't transform character strings, so this always returns .T.
>
>>Nadya -
>>
>>I haven't tried this but I think it should work. The expression:
>>(lcMyAPN = TRANSFORM(lcMyAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
>>should return .T. if the APN matches the format string.
>>
Strange, but these are my tests:
lcAPN = "123456A-B789012C-D345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcAPN = "a123456A-B789012C-D345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcAPN = "a123456A-B789012C-D345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcAPN = "123456AA-B789012C-D345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcAPN = "123456AB789012C-D345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcAPN = "123456A-B789012CD345678EF-GH901234I-KLMNOP"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
lcApn="999999X-X999999X-X999999XX-XX999999X-XXXXXX"
?(lcApn= TRANSFORM(lcAPN, "999999X-X999999X-X999999XX-XX999999X-XXXXXX"))
Undocumented feature?
If it's not broken, fix it until it is.
My Blog