I am having trouble excluding empty lines when selecting (SQL)
lines from a CCID(1208) file.
SQL functions Trim, Length etc. fail to identify empty field
for instance: Length(Trim(EmptyField)) returns 540
where clause with EmptyField <> ' ' does not cut it as well.
the job CCID is 424
I guess that CCID 1208 needs some special functions but it eludes me
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.