Populate empty cells to use for conversion

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

Hi -
I have a file of transactions, and the first line of the transaction
contains the transaction number, type and date (and a few other
fields). The following lines (there could be 1 to as many as 100 or
even more) have only some of the fields filled in - it's not
consistent - it all depends on the transaction.

I would like to get some sort of unique identifier - like the
Transaction number - on every line related to that transaction, so I
can ulitimately import the data into another system (probably have to
go through Access first.

I cannot think of how to do this! Can someone help? Here's an
example. Below are 3 transactions. I split them up and repeated the
header here, so it would display in a way it would make sense. I do
not need the TOTAL line - and that line is not indicated with the word
"Total". (No help there).

Trans # Type Date Num Name Memo Item Item Desc
413209 Bill 10/01/2011 100111 Jones
Jones Coffee
Account Qty Debit Credit
A/P - Trade 210.02
Other 210.02
210.02 210.02

Trans # Type Date Num Name Memo Item Item Desc
419986 Payment 10/03/2011 12221 CC Smith
Smith
Account Qty Debit Credit
UndepFunds 682.11
A/R - Trade 682.11
682.11 682.11

Trans # Type Date Num Name Memo Item Item Desc
486672 Invoice 10/22/2011 202513 Grady
Grady Unit 1 West 11 descr West
West Non-Tax Non-Tax
Account Qty Debit Credit
A/R - Trade 275.00
South 2 -5.00 275.00
Sales Tax Pay 0.00
275.00 275.00

Thanks -
Sara
 
Hi -
I have a file of transactions, and the first line of the transaction
contains the transaction number, type and date (and a few other
fields).  The following lines (there could be 1 to as many as 100 or
even more) have only some of the fields filled in - it's not
consistent - it all depends on the transaction.

I would like to get some sort of unique identifier - like the
Transaction number - on every line related to that transaction, so I
can ulitimately import the data into another system (probably have to
go through Access first.

I cannot think of how to do this!  Can someone help?  Here's an
example.  Below are 3 transactions. I split them up and repeated the
header here, so it would display in a way it would make sense.  I do
not need the TOTAL line - and that line is not indicated with the word
"Total". (No help there).

Trans # Type    Date     Num    Name    Memo    Item    Item Desc
413209  Bill    10/01/2011 100111       Jones
                                Jones  Coffee
Account Qty     Debit   Credit
A/P - Trade             210.02
Other           210.02
                210.02  210.02

Trans # Type    Date    Num     Name    Memo    Item    Item Desc
419986  Payment 10/03/2011 12221        CC      Smith
                                Smith
Account Qty     Debit   Credit
UndepFunds      682.11
A/R - Trade              682.11
                682.11  682.11

Trans # Type    Date    Num     Name    Memo    Item    Item Desc
486672  Invoice 10/22/2011 202513       Grady
                                Grady  Unit 1  West 11 descr West
                                West    Non-Tax Non-Tax
Account      Qty        Debit   Credit
A/R - Trade     275.00
South 2    -5.00                275.00
Sales Tax Pay   0.00
                275.00  275.00

Thanks -
Sara

So that I don't have to re-create your data for testing, send me a
file with an explanatiion to dguillett1
@gmail.com
 
Back
Top