Redian新闻
>
文章分2栏,现在如何把公式、图片横跨2栏
avatar
文章分2栏,现在如何把公式、图片横跨2栏# TeX - TeX电子排版系统
i*i
1
I got a csv file from vedor with only Emails.
There is a blank line on top of each email address. I tried to remove the
blank lines in SQL server. I imported the CSV file to dbtemp.
I tried to write a SQL query
SELECT *
FROM table
WHERE (EmailAddress IS NOT NULL)
but it still pulls out every lines including the blank lines. Not sure what
is the problem.
example:
EmailAddress
0*********[email protected]
0*********[email protected]
1********[email protected]
1******[email protected]
avatar
w*h
2
文章分2栏,现在如何把公式、图片横跨2栏,占用整个页面那块?
avatar
a9
3
and trim(emailaddress) <> '' ?

what

【在 i****i 的大作中提到】
: I got a csv file from vedor with only Emails.
: There is a blank line on top of each email address. I tried to remove the
: blank lines in SQL server. I imported the CSV file to dbtemp.
: I tried to write a SQL query
: SELECT *
: FROM table
: WHERE (EmailAddress IS NOT NULL)
: but it still pulls out every lines including the blank lines. Not sure what
: is the problem.
: example:

avatar
r*u
4
\begin{figure*}
\end{figure*}

【在 w****h 的大作中提到】
: 文章分2栏,现在如何把公式、图片横跨2栏,占用整个页面那块?
avatar
g*l
5
delete from table where rtrim(ltrim(emailaddress))=''
delete from table where emailaddress not like '%@%'
avatar
i*i
6
Thank you very much A9 and gejkl
Both work well.
WHERE ltrim(rtrim(EmailAddress)) <> ''
WHERE ltrim(rtrim(EmailAddress)) LIKE '%@%'
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。