Current CSV Delimiter can be unusable

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Alistair
Posts: 4
Joined: Tue Nov 01, 2005 11:05 pm

Current CSV Delimiter can be unusable

Post by Alistair » Thu Feb 23, 2006 11:29 pm

I think that only having CSV as a datafile limiter is restrictive. I have several cases where I have text with both commas and quotes in the text and IM cannot handle it via csv because of the delimiter - I think the addition of semi-colon, tab or user defined character as a delimiter would solve the problem. My current options have to use complex connections to databases where a error free delimited file would suffice.

Do you have plan to change the delimiters in the future?

Alistair
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Post by Tech Support » Fri Feb 24, 2006 10:24 am

Hi,

you can use the Microsoft Text File Driver to read text files and specify the delimiter within the Schema.ini file. An example for using the driver is provided in the Examples\Windows Scripting Host\file-2-web-method2.vbs

Code: Select all

set rs = createobject("ador.recordset")
sDir =  Replace(WScript.ScriptFullName, WScript.ScriptName, "")
strConnect = _
   "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
   "DefaultDir=" & sDir & ";"

Const adOpenStatic = 3
rs.open "select * from iimsubmit.csv", strConnect, adOpenStatic

do until rs.eof
  here you can access the rows by rs.fields(column_number) of each row
  rs.movenext
loop
The file which controls the format of the input text file is called Schema.ini. With it the driver provides powerful measures to customize the input format. For example, the Format= attribute can be set to

Code: Select all

Format=Delimited(custom character)
For a description of the full capabilities of the Schema.ini file see http://msdn.microsoft.com/library/defau ... i_file.asp

Regards
---
Lasse Clausen, iOpus Support
gmatch
Posts: 11
Joined: Mon Jan 19, 2009 2:29 am

Re: Current CSV Delimiter can be unusable

Post by gmatch » Mon Jan 19, 2009 2:49 am

I really need to find a way to change the delimiter and am not understanding how to make this work.

I want to use the schema.ini to choose the delimiter(|) for me since imacros doesn't have that functionality yet. I have my schema.ini in the folder of the text file I want to read from.

How do I tell imacros:

1.) To use the schema.ini
2.) Load the | delimited file into imacros as the file to input data from.
3.) Input a column of data into my current script. I previously used CONTENT={{!COL1}}.
Post Reply