ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I break down a string with data divided by commas (https://www.excelbanter.com/excel-programming/351864-how-can-i-break-down-string-data-divided-commas.html)

WannaBeExceller

How can I break down a string with data divided by commas
 
I have a file that is CSV and I want to move those lines after splitting them
in the the groups of data. I have about 360,000 lines and want to do some
calculations and input some zeros. Is there a way to concat the string at the
point commas show?

Tim Williams

How can I break down a string with data divided by commas
 
dim arrVals
arrVals=Split(sLine, ",")
'etc

Tim

--
Tim Williams
Palo Alto, CA


"WannaBeExceller" wrote in
message ...
I have a file that is CSV and I want to move those lines after splitting

them
in the the groups of data. I have about 360,000 lines and want to do some
calculations and input some zeros. Is there a way to concat the string at

the
point commas show?





All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com