Tersus: Re: Separator character

Re: Separator character - Load CSV TableDate: Dec 29, 2008Hi David,Currently, there is no option to change the separator. This is something we plan to add in the next few weeks.In the meantime, you can use the new "Parse" pluing under "Miscellaneous", in the following way:

Create a data structure with the fields you need to extract from each row (the order of the elements should match the order of fields in the row)

Add a property format.separator to the data structure and add your chosen separator character/s

Use "Split" to split your file into rows, and then "Parse" to convert each row into a data structure

For number, date and date and time elements in your structure, you can add a property 'format' and specify the number or date format for the conversion (the format should go into the local property value)Regards,YouvalSee Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...