More homework !by (no login)I want to "tamper" (?) this sort of line (CSV), for 4 characters in each cell, without any separation. All leading zeros should be replaced by spaces, if any... CSV : 99;5,44;5,95;38,00;8,31;0,70;0,28;0,36;11,37;1,28;28,31 Since formating here doesn't deal with space, i can't post the result.. example: 0099 is the firts "cell", replacing 0 with " " DIM Cell AS STRING * 4 i just wondering if there is a classic way for doing that. It seems to me i have read about this here before here. L |
| Response Title | Author and Date |
| *Of course i do it myself :) | on Apr 26 |
| * t$=str$(n): t$=space$(4-len(t$))+t$ | on Apr 26 |
| Thanks, correct word was "padded" | on Apr 26 |
| * t$=string$(10-len(t$), 0)+t$ | on Apr 26 |
| *VAL() only returns integer part of string ? | on Apr 26 |
| no... | on Apr 26 |
| Val(0) | on Apr 26 |