Post reply

Two delimiters in Schema.ini

  • February 10, 2009 at 1:25 am

    #155256

    Recently, it's ok for me to define a Schema.ini with one delimiter, however, I'd like to deal with two delimiters at the same file. I wonder if it is possible for tackling this issue? I actually wwant o have Format=TabDelimited and Format=Delimited(/) at the same time. Thanks.

    My schema.ini

    [Test.csv]

    ColNameHeader=False

    MaxScanRows=0

    DateTimeFormat=d/m/yyyy

    Format=TabDelimited

    Col1=A1 CHAR WIDTH 255

    Col2=A2 CHAR WIDTH 255

    Col3=A3 CHAR WIDTH 255

    Col4=A4 CHAR WIDTH 255

    Test.csv

    ABCCDE/E/E

    ABCCDE/E/E

  • February 10, 2009 at 2:44 am

    #941031

    One way could be to edit the .csv file with a text editor and replace the slashes with at tab or vice versa in order to maintain one delimiter only.

    brgds

    Philipp Post

    brgds

    Philipp Post

  • February 10, 2009 at 2:47 am

    #941033

    ohh.... Thanks anyway. I shall make my own script to do it in the file system level. 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply