Hello wise ones!
I have a question regarding *.csv files. As you are all aware, the European *.csv files use the 'semicolon' and the US or India uses 'comma' delimited file. So basically, i have a Perl script with my own set of modules to run it. I use the European format but it has to be compatible for my end users in India as well. In VBA, i could add for example a macro like this to change the format:
Private Sub loadFile(measurementFile As String)
Dim query As QueryTable
If (FileOrDirExists(measurementFile)) Then
Set query = mSheet.QueryTables.add( _
Connection:="TEXT;" + measurementFile, _
.TextFileParseType = xlDelimited
.TextFileSpaceDelimiter = True
.TextFileTabDelimiter = True
.TextFileDecimalSeparator = ","
I was wondering if there is something similar in Perl using OLE. I do not wish to use any extra libraries like Text::CSV etc. Is there some way where i can define the 'List separtor' as a comma and the 'Decimal separator' as point!!
Any answers or help is much appreciated folks :) And oh yes! I use Win32::OLE and i was hoping there was some way to define the List separator (I noticed that Win32::OLE::Variant allows for decimal separator but i could not spot anything for List separator)