I'm creating a table with labels, but my CSV data is separated by semicolons (;), how do I make everything work?


EXAMPLE:
a;1;cat;X\n
b;2;dog;Y\n
c;3;pig;Z\n
d;4;cow;0

You need to replace the ; with , for this to work in AI2

Use the text replace block

image

(assumes you do not have any , in your fields....)

2 Likes