Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need Help Splitting a string
#1
Solved: 11 Years, 3 Months, 1 Week ago
I have a string of data that I need to split into individual components. I'm trying to use Split but it doesn't seem to be working.
Here is a sample string of data from my datatable "TranLine". contained here in '
' 0817102 30 A 1,464.49 1.15778-'
Here is my code I'm trying to do this with.
Code:
myTranLine = DataTable("TranLine", dtGlobalSheet)
mySplit = Split(myTranLine, " ")
myNewTranLine = mySplit(0) & mySplit(1) & mySplit(2) & mySplit(3) & mySplit(4)
mySplit(0) = TranDate
mySplit(1) = TranCode1
mySplit(2) = TranCode2
mySplit(3) = TranAmnt
mySplit(4) = IntAdj
DataTable("TRANTYPE", dtGlobalSheet) = TranCode1 + TranCode2
DataTable("DATE", dtGlobalSheet) = TranDate
DataTable("TRAN1", dtGlobalSheet) = TranCode1
DataTable("TRAN2", dtGlobalSheet) = TranCode2
DataTable("AMT", dtGlobalSheet) = TranAmnt

Another note: sometimes the string is all spaces with no data, sometimes the last peice of data is missing.
Reply


Messages In This Thread
Need Help Splitting a string - by Brian.Osborne - 03-10-2011, 09:05 PM
RE: Need Help Splitting a string - by tdevick - 03-10-2011, 10:45 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Replace a string in a word document with another string rekha.naik 8 15,440 11-14-2013, 12:58 PM
Last Post: pranikgarg
  Splitting a text which starts with " joe.alex 3 2,472 11-23-2012, 12:01 PM
Last Post: Saleel Prabhu
  Splitting value of cell in Excel sheet janriis 2 4,461 02-02-2011, 11:33 PM
Last Post: sreekanth chilam

Forum Jump:


Users browsing this thread: 1 Guest(s)