Search code examples
findedi

EDI X12 EO810 Data Extract with a space as ending position.

I have an EDI document field that I am attempting to extract data from. The Customer part number is listed in PID05 after a #. I am trying to pull out the data between "#" and " " and return it to var_ITNO. However, my var_EP isn't necessarily stopping at the first space. Any help on how to correct this issue?

var_PID05 = SOURCE.EO810H01.EO810D01.EO810D12.PID05 
var_SP = Find(var_PID05, "#") + 1
var_EP = find( var_PID05, " ",var_SP) 
var_ITNO = MID( var_PID05 , var_SP , var_EP )
Solution

  • The following code was specifying the space position for the Length. 

    `var_ITNO = MID( var_PID05 , var_SP , var_EP )`

    I reworked it to read as follows:

    `var_PID05 = SOURCE.EO810H01.EO810D01.EO810D12.PID05 
var_SP = InStr(var_PID05, "#") + 1
var_EP = InStr( var_PID05, " ",var_SP) 
var_LEN = var_EP - var_SP
var_ITNO = MID( var_PID05 , var_SP , var_LEN )`