When I say all types of blanks, I mean a blank or a whitespace blank. So this string can be empty, or it can have a blank space, or two blank spaces, etc. I would consider those all blanks and I need them removed from my dataframe. So far I have:
Dataset<Row> dayCustAcctCardJoinCustDF = dayCustAcctCard
.filter(dayCustAcctCard.col(custJoinKey).isNotNull())
.select(acctJoinKey, custJoinKey);
This is just removing nulls from the original dataframe. I'm looking to enhance that filter to remove and records who have a custJoinKey value of a blank value or a 1 character length white space, 2 character length blank space, etc.