Data separation

agpt · Post by **agpt** » Fri Sep 10, 2010 1:32 pm

Hi,
I have Numerical+Characters data in the source in the same column. Data type is varchar and it has values like 19, 'ABC'. How will I load only Character data to the target?

chulett · Post by **chulett** » Fri Sep 10, 2010 1:44 pm

What's your business rule?

agpt · Post by **agpt** » Fri Sep 10, 2010 1:49 pm

I need only alphabetic data out.

anbu · Post by **anbu** » Fri Sep 10, 2010 2:01 pm

Code: Select all

Convert(Convert("ABC...Zabc..z","",Str),"",Str)

vinothkumar · Post by **vinothkumar** » Fri Sep 10, 2010 2:12 pm

Your column has values like ABCD123FGVH. In that you want to load only ABCDFGVH. Is that you mean in your post.

If Yes, use Convert('0123456789','',String).

agpt · Post by **agpt** » Sat Sep 11, 2010 12:26 am

no no
what i meant
suppose i have 5 records like
abc
123
efg
rst
345

Then in put put i need only 3 records from above which would be
abc
efg
rst

how can I implement that?

ray.wurlod · Post by **ray.wurlod** » Sat Sep 11, 2010 3:15 am

Use a constraint something like Not(Num(Inlink.TheString))

agpt · Post by **agpt** » Sat Sep 11, 2010 5:52 am

ray.wurlod wrote:Use a constraint something like Not(Num(Inlink.TheString)) ...

Ray, but it's varchar column type so not(num()) is going to be true even for 123 value. right?

chulett · Post by **chulett** » Sat Sep 11, 2010 6:41 am

Nope, it is testing the contents not the data type specifically. Give it a shot.