PING: Visual Basic question

hoosiergoody · 07-10-2007, 08:58 AM

Hi all- I hope someone can help... I have data in excel that I am copying into a IBM Mainframe via VB. To keep the original formatting of the data, I had to add an ' to each cell, and it is saved in .csv format. what is the best way to remove the ' when putting the data back in to the mainframe? On some cells I can use " .TransmitANSI Right$(BrandCode, 8), but if there are more or less than 8 digits plus the ', that doesn't work. Any thoughts?

lighthousekeeper · 07-10-2007, 09:19 AM

Would this work?

Replace(txt,"'",""))

hoosiergoody · 07-10-2007, 09:28 AM

i'll try it out. still learning vb on the fly... thanks for your response.

hoosiergoody · 07-10-2007, 11:40 AM

lighthousekeeper- that did it. thanks for your timely response!

07-10-2007, 09:19 AM	#2
lighthousekeeper College Starter Join Date: Oct 2000	Would this work? Replace(txt,"'","")) __________________ ...

07-10-2007, 09:28 AM	#3
hoosiergoody Mascot Join Date: Nov 2005	i'll try it out. still learning vb on the fly... thanks for your response.

07-10-2007, 11:40 AM	#4
hoosiergoody Mascot Join Date: Nov 2005	lighthousekeeper- that did it. thanks for your timely response!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)