I have a text file in the following format:
615835520110131262000000 000000 000000 000000 000000 000000 000000 000000 000000 615835520110726262000000 000000 000000 000000 000000 000000 000000 000000 000000 615835520110727262-99999M-99999M-99999M-99999M-99999M-99999M-99999M-99999M-99999M615835520110201262000000 000000 000000 000000 000000 000000 000000 000000 000000 615835520110202262000000 000014 000011 000007 000009 000008 000019 000007 000000 615835520110203262000000 000000 000000 000000 000000 000000 000000 000000 000000 615835520110204262000000 000000 000000 000000 000000 000000 000000 000000 000000
I wish to convert it into an n x n vector (e.g. A), in the format above, however, the first column should not contain 61583552011XXX262. Also, for the the -99999 values, no M should be present, yet it sperates the vales. Any suggestions?
Best Answer