I found a solution.
With this I tell AppSheet to change the Item separator from “,” to “#”, but only for the 1513.00.000 Numbers.
After that I use INDEX() to add one by one and to truncate each Number to 12 digits.
I start with INDEX(…,2) because the first one is unwanted Text.
I go up till INDEX(…,20) because I think there will be not more than that.
Finally I delete empty entries with LIST("")
.
This is the result:
1513.56.338, 1513.56.350, 1513.56.351, 1513.51.310, 1513.56.358, 1513.56.344, 1513.56.360, 1513.56.424, 1513.56.426, 1513.56.425
And this is my expression:
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,2)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,3)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,4)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,5)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,6)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,7)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,8)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,9)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,10)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,11)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,12)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,13)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,14)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,15)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,16)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,17)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,18)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,19)
,12)
)
+
LIST(
LEFT(
INDEX(
SPLIT(
SUBSTITUTE([OCRTEXT],", 1513.","# 1513.")
,"#")
,20)
,12)
)

LIST("")