Home > database >  How to use PB converts text files in the comma separator TAB separators
How to use PB converts text files in the comma separator TAB separators

Time:09-24

1, 2, 3, 4
5,6,7,8
How will the middle comma through code into a TAB delimited text, thank you!

CodePudding user response:

String ls_string, ls_string2
String ls_words
The integer li_i, li_len
,2,3,4,5,6,7,8 ls_string='1'
Li_len=len (ls_string)
For li_i=1 to li_len
Ls_words=mid (li_i ls_string, 1)
If ls_words=', 'then'
Ls_string2 +='~ t'
The else
Ls_string2 +=ls_words
End the if
End for
Messagebox (' ', ls_string2)

CodePudding user response:

A replacement text file of PB data window import example
http://download.csdn.net/detail/hanker1314520/2210159

CodePudding user response:

If your file is bigger, also can have a try, open the text file in excel first, and then save for delimiter is the TAB to remind TXT file to go,

CodePudding user response:

Oh, I'm sorry, just not answer because you want to use PB,

CodePudding user response:

Bumps!!!!!!!!!!!!!!!!

CodePudding user response:

Check the Pos and Repalce function

CodePudding user response:

Pb to quickly replace text document (TXT file) specified in the method of the characters, http://blog.csdn.net/yyoinge/article/details/6927791

CodePudding user response:

Check the Pos and Repalce function
This note...
  • Related