Using CR11...have a text field that I need to extract a section of data out of. Below is an example of the text field as well as an example of the data I need to extract.
Text Field Example 1
CONVERTED Part Sale... Yard# 1 Store# 1 U 601-58797 Retl$ 50.00 Qty 1 Stock# 5895 Core$ 0.00
Text Field Example 2
CONVERTED Part Sale... Yard# 1 Store# 1 U 601-58829B Retl$ 50.00 Qty 1 Stock# 6105 Core$ 0.00
Text Field Example 3
CONVERTED Part Sale... Yard# 1 Store# 1 U 617-00002BR Retl$ 40.00 Qty 1 Stock# NOF Core$ 0.00
What I need to extract is the three numbers before the hyphen and anything after the hyphen up to the first space so my results will look like...
Extracted Example 1
601-58797
Extracted Example 2
601-58829B
Extracted Example 3
617-00002BR
Thanks in advance for any assistance.
Text Field Example 1
CONVERTED Part Sale... Yard# 1 Store# 1 U 601-58797 Retl$ 50.00 Qty 1 Stock# 5895 Core$ 0.00
Text Field Example 2
CONVERTED Part Sale... Yard# 1 Store# 1 U 601-58829B Retl$ 50.00 Qty 1 Stock# 6105 Core$ 0.00
Text Field Example 3
CONVERTED Part Sale... Yard# 1 Store# 1 U 617-00002BR Retl$ 40.00 Qty 1 Stock# NOF Core$ 0.00
What I need to extract is the three numbers before the hyphen and anything after the hyphen up to the first space so my results will look like...
Extracted Example 1
601-58797
Extracted Example 2
601-58829B
Extracted Example 3
617-00002BR
Thanks in advance for any assistance.