Extraction gets CVS or #NEXT# separated fields ?

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.
Forum rules
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
ZeT
Posts: 1
Joined: Sat Dec 10, 2005 7:19 pm

Extraction gets CVS or #NEXT# separated fields ?

Post by ZeT » Sat Dec 10, 2005 7:26 pm

Hello,

I just found IIM and i am planing to use it for data extraction if it meets my needs.
I am testing data extraction by combining 3 macros.
1°) Login, 2°) Data page access, 3°) Table extraction.

If I play this 3 macros manually in IIMBrowser I get CVS fields : "data1","data2". but if i use a vbs script i get #NEXT# marker separated field (data1#NEXT#data2#NEWLINE# for exemple).

Why ?, Does scripting changes data extraction format ?
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Post by Tech Support » Sun Dec 11, 2005 4:17 pm

The Scripting Interface returns #NEXT# and #NEWLINE# to allow an easier parsing of the data. If you need the original "," and line break, simply add this code to your script:

Code: Select all

sExtract = replace (sExtract , "#NEXT", " "","" ")
sExtract = replace (sExtract , "#NEWLINE", vbCrLf)
Post Reply