topic Re: [resolved] Case sensitive issue in primary key in Talend Studio

[resolved] Case sensitive issue in primary key

Anonymous — Mon, 14 Dec 2015 10:25:58 GMT

Hi ,
File1.csv
name;
vinoth

File2.csv
name1;type2
VINOTH;In-house
ANTONY;External
if name field of file1.csv matches with name1 of file2.csv , type2 value should be assigned to a variable

if vinoth == VINOTH , i should get the value of "In-house"

We have case sensitive issue , one field is in small case and another field is in upper case
Please help me
Thanks & Regards,
Vinoth Kumar K

Re: [resolved] Case sensitive issue in primary key

Anonymous — Mon, 14 Dec 2015 11:11:22 GMT

In your comparison use something like the following.....

row1.field.trim().compareToIgnoreCase(row2.field.trim())==0

The above will check that the values held by the fields hold the same values ignoring case and extra spaces at the beginning or end of the String.

Re: [resolved] Case sensitive issue in primary key

yashwanth1 — Mon, 14 Dec 2015 11:21:49 GMT

connect a tmap component before file2 and convert name column to lowercase.
its temporary solution.

Re: [resolved] Case sensitive issue in primary key

Anonymous — Tue, 15 Dec 2015 04:51:42 GMT

Thank you very much Rhall_2.0 and yashwanth for the suggestions.

Got solution for it

Regards,
Vinoth Kumar K

Re: [resolved] Case sensitive issue in primary key

Anonymous — Tue, 15 Dec 2015 08:51:56 GMT

Also, you can set this post as resolved for other forum members to know that they need not try and help you out anymore.