Fastest way to parse a string of numbers

[jonjilla]

I was wondering more about a mixed string like in this question which hasn’t been answered yet

Help with string mapping from input

Hello I’m trying to import a custom text file that isn’t well aligned and a mixture of data types. The input data looks something like this inputtext = ["ABC=1,2,3,cats,dogs","DEF=1,apples,oranges,4,5,6.78,bananas","XYZ=Julia,R,Python,9.9999"] Currently, my code is very brute force manual and I was hoping that there was a better way to generate this, perhaps with some sort of mapping function ABC = DataFrame(a=Int64[],b=Int64[],c=Int64[],animal=String[],put=String[]) DEF = DataFrame(a=Int64…

For exampe, a string of mixed types like “1,apples,oranges,4,5,6.78,bananas”. Is there a way to map it into

Int,String,String,Int,Int,Float,String