Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

Formatting Index

Hi Experts,

  I have one file which download data from web and format that data. need to add few more step in existing button "Index" after all process done.

  Step 1 In  .csv file - cell P1 past this text "<TICKER>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>"
 Step 2 in cell P2 past this formula till end =A2&","&TEXT(B2,"YYYYMMDD")&","&C2&","&D2&","&E2&","&F2&","&I2"
  Step 3 Copy column P and past to new open .txt file and save as .csv file name
  Step 4 Delete original .csv file
  Step 5 Next .csv
  END

  Version 22 File

  Thanks
iNDEX-CSV.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Naresh Patel

ASKER

Working Perfect As Expected.

Thanks
May I ask last request on this WB?
yes pls
May Now Post Link?
yes go ahead.
gowflow