管道定界功能 [英] Pipe delimitating function
问题描述
我创建了一个文件
c; /temp/test.txt
000 | 23102007
001 | 21102007 | 23102007 | GB11223344
001 | 20102007 | 22102007 | GB11223345
001 | 19102007 | 22102007 | GB11223346
999 | 3
突出显示的文字是开始日期和结束日期以及帐号。
假设我想通过使用以下代码将日期插入到test.txt中的am_test中
我不想在我的代码中使用硬编码值
IF(LENGTH(vNewLine)> 13)然后......就像这样
我想在表格中插入''|''分隔值。
cud u请告诉我该怎么做。
Thnaks
感谢您的解决方案..它的工作...:)
感谢您的解决方案..它的工作.. 。:)
欢迎你! :)
我希望你通过发布指南,这将有助于您了解如何使用CODE TAGS以及在此论坛发帖时需要遵循的许多其他论坛指南!!
MODERATOR
I have created one file
c;/temp/test.txt
000|23102007
001|21102007|23102007|GB11223344
001|20102007|22102007|GB11223345
001|19102007|22102007|GB11223346
999|3
The highlighted text are started date and end date and account number .
Suppose I wanted to insert the date into am_test the from the test.txt by using following code
I dont wanted to use hardcoded values in my code means
IF(LENGTH(vNewLine) > 13) THEN ... like this
I wanted to insert ''|'' seperated values in my table .
cud u please tell me how to to it .
Thnaks
Try this:
Expand|Select|Wrap|Line Numbers
Thanks for ur solution .. its working ...:)
Thanks for ur solution .. its working ...:)
You are welcome!! :)
I would like you to go through the POSTING GUIDELINES which would help you understand how to make use of CODE TAGS and many other forum guidelines which needs to be followed while posting in this forum!!
MODERATOR
这篇关于管道定界功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文