E
Eric
The data below is an example of a much larger database. I am trying to find
a way to bring all lines of the description onto the same row as the date and
amount. The problem I'm havinng is that the space between Date/Amt are of
varying lengths.
Thanks in advance for your help.
Date Amt Desc
7/25 200,000 FUNDS TRANSFER (ADVICE 2008072500018226)
SENT TO JPMORGAN CHASE /
BNF=DREIER LLP OPERATING
OBI=
RFB=080725400069 07/25/08 09:53AM ET
7/28 3,000 AUTOMATED DEBIT NEOPOST POSTAGE
CO. ID. 1942388882 080728 PPD
MISC 46872331
7/29 5,000 TRNSFR 2000030910634 07/29
ONLINE TRNSFR CONFIRMATION # VY114369378
a way to bring all lines of the description onto the same row as the date and
amount. The problem I'm havinng is that the space between Date/Amt are of
varying lengths.
Thanks in advance for your help.
Date Amt Desc
7/25 200,000 FUNDS TRANSFER (ADVICE 2008072500018226)
SENT TO JPMORGAN CHASE /
BNF=DREIER LLP OPERATING
OBI=
RFB=080725400069 07/25/08 09:53AM ET
7/28 3,000 AUTOMATED DEBIT NEOPOST POSTAGE
CO. ID. 1942388882 080728 PPD
MISC 46872331
7/29 5,000 TRNSFR 2000030910634 07/29
ONLINE TRNSFR CONFIRMATION # VY114369378