Usage: importfile function in addition to using the TAB text characters segmentation, how to support-CodePudding

Importfile import efficiency is very good, but only support by splitting the TAB text, I have all the message file is to use a whitespace-delimited field and field, is there anyone similar function or method can quickly into the dw?

CodePudding user response:

Add: use the replace function to convert Spaces to tabs way doesn't conform to the requirements, because there are a lot of space is the meaning of the message, not directly replace,

CodePudding user response:

refer to the original poster jiang396 response:

importfile import efficiency is very good, but only support by splitting the TAB text, I have all the message file is to use a whitespace-delimited field and field, is there a similar function or method can quickly into the dw?

Using importfile only support TAB text segmentation, it is recommended that the text into a TAB delimited themselves or other formats, such as XML or CSV,

CodePudding user response:

refer to the second floor lzp_lrp response:

Quote: refer to the original poster jiang396 response:

Importfile import efficiency is very good, but only support by splitting the TAB text, I have all the message file is to use a whitespace-delimited field and field, is there anyone similar function or method can quickly into the dw?

Using importfile only support TAB text segmentation, suggest themselves into a TAB delimited text or other formats, such as XML or CSV,

The moderator, I TXT format as shown in figure, this kind of format text, can use pb program is converted into a CSV? And automatically separate each column (like a hand in the excel through [data] - [from text] - [] fixed width) way to import CSV form the columns? Do you have any good Suggestions?

CodePudding user response:

After import into this:

CodePudding user response:

If can be imported into excel, you can call the automatic import excel vba function, and then to copy, and then use ImportClipboard, imported directly from the clipboard

CodePudding user response:

reference 5 floor lzp_lrp reply:

if can be imported into excel, you can call the automatic import excel vba function, and then to copy, and then use ImportClipboard, imported directly from the clipboard

Thanks for the boss, can you give an example of code, thanks a lot

CodePudding user response:

Consult the

PB to the operation of the excel

http://wenku.baidu.com/link? Url=4 fxtwn0itrsqttpknusplffnwdwweclpaibbgjjmoxv_vgc9gjgloc3moywcqhwwl79l3qgvl0phznaijzkvopgoa3axm_xu46_4idlt7so