bombadillio
New Member
- Joined
- Jan 20, 2011
- Messages
- 2
Greetings,
I have 500 .csv files that I need to edit as they are a backup of a database which at the end is being moved to a new device. In this process I need to:
- Take column A and format them as numbers(currently set as text) with 0 decimal places
- Take Column E and any text in there needs to be cut and copied to the end of the text in column C
I was able to use notepadd++ for the other tasks which was a simple find and replace for all 500 workbooks but I do not think I can use it for the rest. In notepad++ I did a find for a 10 digit character which is on every other line and replaced it with the new number. I then did a search for any other text (,,,,) and had it deleted. The only thing it would not do was delete all the extra columns and rows which had no text.
Can you help?
Thanks!
I have 500 .csv files that I need to edit as they are a backup of a database which at the end is being moved to a new device. In this process I need to:
- Take column A and format them as numbers(currently set as text) with 0 decimal places
- Take Column E and any text in there needs to be cut and copied to the end of the text in column C
I was able to use notepadd++ for the other tasks which was a simple find and replace for all 500 workbooks but I do not think I can use it for the rest. In notepad++ I did a find for a 10 digit character which is on every other line and replaced it with the new number. I then did a search for any other text (,,,,) and had it deleted. The only thing it would not do was delete all the extra columns and rows which had no text.
Can you help?
Thanks!