擅长:python、mysql、java
<p>谢谢你,凯德拉克,他的回答恰到好处,让我到达了我需要去的地方。我想我不需要为我的孩子安顿那么多。对于未来的谷歌用户:</p>
<pre><code>import re
sfname='C:\python_Script\Testmain.txt'
Var1='AS'
Var2=''
Var3=''
with open(sfname) as file_in:
for line in file_in:
line = line.strip()
if line.startswith('create view [dbo].'):
print(line)
else:
line = line.replace("_", " ")
# replaces the word 'ID' with 'Key'
line = re.sub(r"\bid","key",line)
Var2 = line
# if) Var2 ends with 'Key' replace with the word 'Dimension'.
if Var2.endswith("key"):
Var2 = line.replace("key","Dimension")
else:
Var2 = 'Fact Table'
Var3 = line + " " + Var1 + " " + Var2
print(Var3)
</code></pre>