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
Current CSV Delimiter can be unusable
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
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
- Tech Support
- Posts: 4948
- Joined: Tue Sep 20, 2005 7:25 pm
- Contact:
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
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
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
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
Code: Select all
Format=Delimited(custom character)
Regards
---
Lasse Clausen, iOpus Support
Re: Current CSV Delimiter can be unusable
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}}.
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}}.