extract concatenated data part 2

[jellyroll]

This is a fun one. Have a text file with 500k of records so too big to separate tabs in excel. And when I import into FM7 i get something like 24 concatenated fields:

ACLCPIC acllink 0001 &_PP_ALL F-41 Enter Vendor Credit Memo 0001 &_PP_ALL F_BGGF_BUK ACTVG * 0003 0002 0002 &_PP_ALL F-30 Post with Clearing 0001 &_PP_ALL F_BKPF_BUK ACTVT * 0012 0009

I figured calculations would work to filter, and the only constant between the fields is the spacing as a separator. Number of words may vary.

Viewing some related threads saw:

Trim (Substitute(Left( OrigText; Position( Substitute( Substitute(OrigText; " "; ",");";";","); ","; 0; 1)); ","; ""))

which looks like it wil work for the Left side since I vary the OrigText; " " spacing. However how do I further restrict to include middle or left than right for the second field surrounded by 5 spaces to the left and 25 to the right??

thanks in advance,

Jelly

[jellyroll]

Please note: when posting the concatenated data was trimmed, they are actually separated by spacing unique to the fields. Something like 5, 25, 15, 10, 6, 8,3, etc

[RalphL]

I don't like to trim or substitute until the data is separated. I don't see enough data to establish a pattern. Is there any significance to the "&_PP_ALL" that appears several times in your example. Also are you say the fields are of fixed length. You say trimmed but I think that the data was expanded to fill a set number of characters. If this is the case and you know the length of each field this is a piece of cake.

[jellyroll]

Thanks. ralphl you are correct, it was pretty simple from there.