Data comparison with Mix Case alphabets
Moderators: chulett, rschirm, roy
Data comparison with Mix Case alphabets
Hi,
I have data coming from the source with words having Mix case(e.g MiKe)...I need to compare the word with a hash file lookup that contains a word(e.g MIKE)...with a normal match i am not able to do that...how do i achieve the same using DS.?
Regards,
SM
I have data coming from the source with words having Mix case(e.g MiKe)...I need to compare the word with a hash file lookup that contains a word(e.g MIKE)...with a normal match i am not able to do that...how do i achieve the same using DS.?
Regards,
SM
The UPCASE() function will convert to uppercase pretty efficiently, do that with both strings and you are in production
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Could you explain? Your post states you want to do a match with one uppercase string to a mixed case string, the UPCASE() function lets you do that. So you now have the original string , an uppercased string and a true/false result on a match - what more do you need?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Make the acutal key to your Hash file an uppercase name, create a temporary column in your job with the uppercase lookup name and use that as the lookup key to your hash file.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom