Mathematica Stack Exchange is a question and answer site for users of Wolfram Mathematica. It only takes a minute to sign up.
Sign up to join this community
I have a list of numbers separated by semicolon in text file and I would like to import the data and work with them. If I use
data = ReadList["file",Word,WordSeparators -> ";"] /. Word -> Number
it gives me word or string instead of number. What can I do?
file = StringToStream["1;2;3;4.5;5.5;6.5"];
ReadList[file, Number, RecordSeparators -> {";"}]
{1, 2, 3, 4.5, 5.5, 6.5}
ToExpression@ ReadList["file",Word,WordSeparators -> ";"]? $\endgroup$ – kglr Jun 1 '17 at 21:26ReadList["file", "Number", "RecordSeparators" -> {";"}]? $\endgroup$ – kglr Jun 1 '17 at 21:30ImportString[ StringReplace[Import[ file , "Text"] , ";" -> ","] , "CSV"]maybe. (also cautionToExpressionwont work if any of the numbers are in E exponent form ) $\endgroup$ – george2079 Jun 1 '17 at 22:08