Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling Previous Data

Status
Not open for further replies.

JasonKaufman

Programmer
Apr 13, 2006
46
US
I am using CR XI
working with 816 EDI data

My data looks like:
B.HL.HL: HL<07>3<07>1<07>25
B.HL.N1.N1: N1<07>WH<07><07>93<07>00806
B.HL.HL: HL<07>4<07>3<07>26
B.HL.N1.N1: N1<07>SN<07><07>93<07>00809
B.HL.HL: HL<07>5<07>1<07>25
B.HL.N1.N1: N1<07>WH<07><07>93<07>00810
B.HL.HL: HL<07>6<07>5<07>26
B.HL.N1.N1: N1<07>SN<07><07>93<07>00007
B.HL.N1.N1: N1<07>SN<07><07>93<07>00008
B.HL.N1.N1: N1<07>SN<07><07>93<07>00009

The idea of the data is that for each "B.HL.N1.N1" line of data, where the 2nd segment = 'WH' (Delimiter = <07>)
there are stores 'SN' (also using "B.HL.N1.N1") that are associated with each WH (warehouse).

I can create a formula to pull out the WH or SN number for each row based on the 2nd segment of the line, This # is the last 5 characters of the line

What I want to be able to do is to have the associated WH value appear on the same line as each SN value.
So if I run my report for the above data, it would appear on my report as:

WH SN
806
806 00809
810
810 00007
810 00008
810 00009
.
.
.

Appreciate any help you can give!
 
the EDI data is copied from the 816 file and put into a CSV file and opened in excel.

[apparently the edit function is not working, thus the added post]
 
I'd suggest you have another go at explaining this. Telling us it is EDI data from a 816 file means nothing to me - we need some sample data, an explanation of what you want the result to look like and the logic behind it.

Cheers
Pete
 
I have been able to get some of what I needed worked out but not all of it.
I will submit a new post to deal with what I am looking for now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top