Complex Loop Pipe-Delimited Data Export

Hello,

I have a complicated excel sheet I am trying to pull data from and export in a pipe delimited format required for some software to understand. I have attached 5 lines from an example sheet Please _HELP.csv but the total number of rows will vary every time. I have also attached an example of what the end result needs to be formatted as Format_Example.txt with my attempt at what code would produce the correct value. The values between the "||" in quotes are my code attempts. I don't know how to create a loop that will work to convert these sheets to the pipe delimited format required. We have to manually do this for every sheet we get as of now. I would greatly appreciate help with figuring this out and can answer any questions if I wasn't clear enough with what I am trying to accomplish.

Thank you VERY much

Impressively concise! I have a couple other things I would like the code to do and I am trying to fully understand your loop and how it works to see if I can make the modifications. Your code did exactly what I asked and I am truly impressed with how simply you achieved the end result with such a short script. Should I change the thread to answered now or wait so I can post some additional questions this next week or so if I am unable to figure things out on my own?

The software is unable to process the file with the blank cells. Some cells in the H column on, don't have a value and therefore leaves the space between the pipes blank. I am not sure where to add an if statement to go to the next value when the cell in columns H to the last column are blank. I m not sure if I am explaining this clearly. Basically, if the referenced cell is blank then the SO and the LD lines aren't written to the file and it goes on to the next column and continues the loop.

I think I may have got it. Would you mind checking if what I did is correct and if it is the simplest method? I tried to just increment by 1 if the column value was blank.

Please Login or Register  to view this content.

I cant seem to get this script modification to work appropriately. I am trying to set a variable "Offset" based on whether column E is increasing or decreasing. If it is increasing than the second CStr term in C$ is -H:1+.Cells(1,B). If decreasing the term is H:1-.Cells(1,B). I also added in a round feature and needed to change values from meters to feet. Can you look over what I did to ma any suggestions and please help me figure out how to get my "Offset issue resolved.

Please Login or Register  to view this content.