How do I filter out rows where a column contains a quote symbol (")

Six Stars

How do I filter out rows where a column contains a quote symbol (")

Hi folks,

 

I'm trying to set up a filter in tMap input that removes rows where a string column contains a quote symbol in the string (").  And also removes rows where the email is blank.

 

My attempt at this expression looks like this:

row1.UMB_Student_Email != null && !row1.Permanent_Street.contains("\"")

But I keep getting an error that says "Exception in thread "main" java.lang.Error: Unresolved compilation problems:"

 

And I can't tell where I'm going wrong.

 

Can you help?


Accepted Solutions
Five Stars

Re: How do I filter out rows where a column contains a quote symbol (")

The source value may be a blank instead of null. tweak your statement like below and should work.

!("").equals(row1.UMB_Student_Email) && !row1.Permanent_Street.contains("\"")

Thanks & Regards

Naveen

Thanks & Regards
Naveen

All Replies
Five Stars

Re: How do I filter out rows where a column contains a quote symbol (")

The source value may be a blank instead of null. tweak your statement like below and should work.

!("").equals(row1.UMB_Student_Email) && !row1.Permanent_Street.contains("\"")

Thanks & Regards

Naveen

Thanks & Regards
Naveen
Six Stars

Re: How do I filter out rows where a column contains a quote symbol (")

My apologies it took so long to test and reply.

 

I tried the code and still get the error.

 

I agree that the email should have been checked as a string, but I think the Permanent_Street (address field) is the culprit, where I'm trying to check whether the string in that field contains a quote (") in the string itself.

 

I'm not confident my code that is checking for the quote (") is right but I cant find what is the right combination no matter how hard I google.

Highlighted
Six Stars

Re: How do I filter out rows where a column contains a quote symbol (")

Actually.. I'm sorry Naveen.  The code seems to work when I add test variables, but without the variables it still produces the error in the test window. And the red box error at the end of the expression scroll-bar is always there. I'm not sure whats going on, but I'm rolling with it.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read