If Not IsNull(rs!permaddr1) Then
mpaddr1 = Mid(rs!permaddr1, 1, 500)
mpaddr1 = " "
where permaddr1 is a field type of varchar(1500).
permaddr1 = "No:11/19 , Anna Salai , Chennai-1"(from sql server retriving the values)
This value is now is stored in mpaddr1.
Now, My main problem is :
when i generating the output in the notepad,i want the view like this
Anna Salai Anna Salai
My code look like this :
astrSplitItems = Split(mpaddr1, ",")
For intX = 0 To UBound(astrSplitItems)
Print #1, Tab(1); astrSplitItems(intX); Tab(42); astrSplitItems(intX)
but in this code , i facing a problem that when there was an empty space
only after the comma in the mpaddr1(note:not problem ,if there was an empty space before the comma) ,the output which i was expecting not proper .In notepad view will be
One more thing,if there was an no empty space after the comma the output is coming correctly.But i don't want like this ,i want the output correctly if there was an empty space before and after the comma .
Please let me know.its very urgent...................