|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
|
|||
|
|||
|
removing characters from txt file or during/before export
I was wondering if there is way to remove characters from a txt file using vb code.
For example, "data1", "data2", "data3" I need data1data2data3 That is my data. I want to remove the commas and quotes. I am doing an export of an access database. By default, it is coming out with thse quotes and commas. Let me know if there is any way to fix this! Thanks guys. |
|
#2
|
|||
|
|||
|
There are two statements you can use to write information to a file: Write# and Print#.
Write# automatically includes comma/quote delimits. Print# outputs only the exact values you tell it to output. To use your example: txtField1 = "text1" txtField2 = "text2" txtField3 = "text3" Write #1, txtField1, txtField2, txtField3 would result in a file with: "text1","text2","text3" Replace the Write# with Print# as follows: Print #1, txtField1 ; txtField2 ; txtField3 would result in a file with: text1text2text3 |
|
#3
|
|||
|
|||
|
That worked perfectly! Thanks so much!
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > removing characters from txt file or during/before export |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|