Import/export data from csv with custom separator

Hi, quick question. Is it possible to Import data from csv using custom separator. Here is an example of the problem with standard import which uses “,” as separator. The idea is to import whole “Point(X= , Y= , Z= )” as one item, not 3 separate items. Same question with export to csv.CSV import-export with custom separator

Read: File.ReadText and String.Split (first using a perhaps using your various parameter names as the splitting value(s)?).

Write: FileSystem.WriteText will allow the use of what ever values you might want - just be sure to concatenate the strings correctly (String.Join with a new line character as the separation).

This post I made a while ago may help you. Here is the code contained in the Python node:

import sys
sys.path.append('C:\Program Files (x86)\IronPython 2.7\Lib')
import csv
import StringIO

csv_in = IN[0]
output = []

source = StringIO.StringIO(csv_in)
csv_out = csv.reader(source, dialect=csv.excel)

OUT = [line for line in csv_out]
1 Like

I am trying to make out = data from csv not just read its path