Can some one explain what this part of the code is actually doing?

**Jenkins27** · 03-02-2015, 06:36 PM

Please Login or Register  to view this content.

**mikerickson** · 03-02-2015, 06:44 PM

I looks like it is given a delimited string, Records

Which it then splits into Lines (vbCrLf & vbCrLf delimited)
Each line is then split into Fields( | delimited) and the first field and last field are put into an array called Data.

**Jenkins27** · 03-02-2015, 06:50 PM

thank youV do you know hiw I could change this code so it only takes the the array data for the portion in red... cause right now is is taking the whole text file and I don't want it to

Please Login or Register  to view this content.

**TMS** · 03-02-2015, 06:52 PM

Please Login or Register  to view this content.

Regards, TMS

**Jenkins27** · 03-02-2015, 07:00 PM

and the last line not in red is not a mistake

**Jenkins27** · 03-02-2015, 07:04 PM

thank you guys

**TMS** · 03-02-2015, 07:06 PM

The code was an explanation, not a modification.

I think you need to provide an actual text file, not transcribe the text into the thread. The Cr and Lf characters are not present in the text in the thread. It is, therefore, difficult to test the code in order to determine a) if it works, b) how it works and c) what to look for.

Regards, TMS