How can i stop this?
Every time I record a cell below even though i tell it to record to cell 2 for example in the file it will record to that cell but also put an extra ; in the file.
So since Im record line by line each subsequent line gets an extra ; so by the end the final one could look like A;b;c;;;;;;;;;;;
This si screwing things up cos Ill do another run and want to base it off of the column count but column count is all wrong cos of extra ;;;
I have also tried using both trim and replace but for some reaosn they won;t delete these extras bits.
Ok so replace does remove some but i have to do a loop to keep removing them
wondering how i could prevent it form happening in the first place.
Every time I record a cell below even though i tell it to record to cell 2 for example in the file it will record to that cell but also put an extra ; in the file.
So since Im record line by line each subsequent line gets an extra ; so by the end the final one could look like A;b;c;;;;;;;;;;;
This si screwing things up cos Ill do another run and want to base it off of the column count but column count is all wrong cos of extra ;;;
I have also tried using both trim and replace but for some reaosn they won;t delete these extras bits.
Ok so replace does remove some but i have to do a loop to keep removing them
wondering how i could prevent it form happening in the first place.
Последнее редактирование: