Bablosoft

Need help in BAS > Excel

Support
  • MrXM

    I've a database of customer's address which is not in good format. I want to make a bot which checks on google for it and get element text and replace with the address it's using (It shouldn't change or do anything with the existing details other then Addresses). I just want a guidance about all this.
    Any help will be appreciated.
    THanks

    0
  • ediczrE

    Good evening. I do not know what data you have in Excel and how it is corrupted. You can export data from excel to text format and already work with them in BAS.
    Exporting data to a text file by saving it
    An Excel sheet can be converted to a text file using the Save As command.

    1. Select a File > Save as.
    2. Click the Browser button.
    3. In the Save As dialog box, in the File Type field, select the text file format for this document. For example, click Text (with taboo wife) or CSV (with comma).
    MrXM 1 Reply
    0
  • MrXM

    @ediczr Thanks for the reply.
    I'm using it already in CSV format. But It's difficult to maintain data in Text. I've to make in Text and again I've use in excel and do all formulas for them again.
    I saw option in BAS for List and Exel. So I wanted to use it for my ease.

    ediczrE 1 Reply
    0
  • ediczrE

    @MrX
    Good afternoon. Yes, you can use the excel module built into BAS. There I don't see any difficulties in implementing this in my projects. Keep in mind that this module is not designed to work with a very large array of data. I tested this when writing data into blocks of 5000 rows of positions in the amount of 900,000 row, the scripts work is time-delayed and significantly. I had to use another solution unrelated to BAS

    MrXM 1 Reply
    0
  • MrXM

    @ediczr Thanks a lot.

    0
  • E

    Hey there,

    I have related question:

    I'm trying to write a date from *csv file into web input form. The date in *csv file is in MM/DD/YYYY format, but my BAS inputs it as YYYY-DD-MMT00:00:00:00... i need it to fill out the webform in MM-DD-YYYY format. what ami doing wrong?

    0