Lekha Mohanty wrote: ↑Mon Oct 25, 2021 4:43 pm
Hello sir,
Thanks for your response.
I have tried code
Code: Select all
VERSION BUILD=8970419 RECORDER=FX
TAB T=1
SET !EXTRACT_TEST_POPUP NO
TAG POS=1 TYPE=TABLE ATTR=ID:"optionChainTable-indices" EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
Code: Select all
VERSION BUILD=8970419 RECORDER=FX
TAB T=1
SET !EXTRACT_TEST_POPUP NO
TAG POS=1 TYPE=TABLE ATTR=TXT:CALLS*PUTS* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
With these codes I tried to save the data in CSV format but all the data placed in a single cell, I want it in Excel format or in Google sheet. is there any solution available ?
nse.png
Hum, you don't need to call me "Sir", we have Ladies working for @TechSup and sometimes answering Threads on the Forum, they won't be "very happy" if you call them "Sir", ah-ah...! Keep it Gender-Neutral...
>>>
Hum, "Excel format" doesn't mean anything btw, 'CSV' is a "Format", `Excel` is just
one Software Program/Application able to open that kind of File "trying" to interpret that Format, because you/most Users have associated the '.csv' File Extension with that Program (at the OS Level), to display like "it" thinks Users want to have the Content of that file displayed, with some limited Control from the "CSV Import Options"...
>>>
Hum..., whole Data (= whole Table) "saved in a single Cell", => hum-hum, yep indeed, that's FF and iMacros for FF that saves the Data with Double Quotes around each Cell, + also some extra Double Quotes
at the complete beginning + complete end of the Table, => the 'SAVEAS=EXTRACT' in your '.csv' File if the '!EXTRACT' only contains your Table...
=> Before opening your '.csv' in `Excel`, you'll need to open that File in `Notepad` (as you are on OS = Win10_x64) (and I reckon/suppose you've associated the '.csv' Windows File Extension to be associated (to be automatically opened) with `Excel` (...?, like most People do...) ... at the OS Level...), => to remove those 2 Double Quotes... (the very first + the very last ones...!).
(Could be (automatically) removed also from some '.bat' File... And as you are using v8.9.7 for FF, that "Post-Processing" '.bat' File can even be launched from iMacros, at the end of your "normal"/current Script...)
=> Other Option: => Is from `Excel`, you need to "play" with the "Excel CSV Import Options", especially with the "Delimiter" Setting, => not selecting 'Double Quotes', => 'Single Quotes' for example should do "the Trick", I would think...
"... I would think..." => I'm not completely sure, you'll need to "experiment" what works (best)..., I haven't used `Excel` in many-many years
, (8 or 10 maybe, I think...), and didn't need to extract Full Table(s) for myself for "a very long time", ah-ah...!
(All my "Knowledge and Expertise" come from "Situations" I have personally "encountered" and had "to solve for myself", sometimes from Cases/Threads on the Forum (very good btw that you posted the URL to your Site, or I wouldn't have been able to test..., ... and you would only have gotten some "Generic" Advice from me then, ah-ah...!
), but I don't do any Data Extraction at the 'TABLE' Level for myself, so I only use (and know and test) that Func for the Forum, ah-ah...!
)
>>>
Maybe "useful" to know, if you noticed my "
yep indeed, that's FF and iMacros for FF that saves the Data with Double Quotes around each Cell, + also some extra Double Quotes at the complete beginning + complete end of the Table,", => then yep, this is bit "typical" FF + iMacros for FF Behaviour..., other Browsers (and their corresponding iMacros Version(s)) behave(d) differently and don't/didn't save the extra Double Quotes causing the "Table EXTRACT in One Cell" Behaviour...
But v8.9.7 for FF that you are using is "now" the last "fully functional" Version left which is 'FREE', there is no more any other Version to use with as much Func supported coming "close" to v8.9.7 for FF, ah-ah...! then, tja...!, you'll have to "live" with the "little" Limitations/Bugs from that Version, ah-ah...!
>>>
=> Not sure what "Bug" means...!?
=> Simply run this mini-Script... (on the Page you posted):
Code: Select all
TAG POS=2 TYPE=DIV ATTR=TXT:CALLSPUTS<SP>OI<SP>Chng<SP>in<SP>OI<SP>Volume<SP>IV<SP>LTP* EXTRACT=HTM
... Let it run..., your Browser will eventually "come back", ... after 5 minutes, ah-ah...!
Workaround:
Use '!EXTRACT_TEST_POPUP' (=> "=NO"...!), + 'PROMPT' to display the '!EXTRACT' Content...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...