parse

Need to parse parts of a raw text file and convert it to an Excel file. Seems simple, and have tried multiple approaches, but none have been successful. Any assistance would be greatly appreciated. I would provide actual files, but do not have permissions to post attachments. sample data: ...

I have a lot of cells in this format: <tbody> Inquire | Compare | Compare Files </tbody> but the number of items in the cell vary. I only want the last one "Compare Files" While this list uses |, I would also like to tell the function what divider to use.

Have code that parses the text in a cell to columns (see below) It works well when the text is in one continual string. example: "July","September","October","November" But when the data has a crlf separating each item, it does not work right. In such case, I only get the first result...

Hi, I am trying to parse a string beginning at the word "else" and ending at a number. if(LowIncomeSubsidyLevel = 1) then 27.00 else (if(LowIncomeSubsidyLevel=0.75) then 33.40 else (if( LowIncomeSubsidyLevel=0.50) then 39.80 else (if(LowIncomeSubsidyLevel=0.25) then 46.30 else 52.70))) The...

Hi, I have over 3000 rows of data similar to "MAYALB93.0106.04.39" in column E1. I want to parse it so that ... A1 = MAYALB93 B1 = 0106 C1 = 04 D1 = 39 so far i was able to come up with this formula below , but i really feel lost in A1 i did this: =LEFT(E1,FIND(".",E1)-1) in B1 i did this...

Good evening I have a pretty large data set. with certifications. I need to parse the numbers out (the 3 digit ones) <table class="tableizer-table"> <thead><tr class="tableizer-firstrow"><th>Certification</th></tr></thead><tbody> <tr><td>Intermediate Administrator (092)</td></tr>...

For the last 10 years or so I have wanted to convert JSON data to time series data in Excel. I never found an easy solution. This has irritated me. Coinmarketcap has an API for crypto currencies and JSON data https://api.coinmarketcap.com/v2/ticker/ https://api.coinmarketcap.com/v2/ticker/ {...

I have a series of patterns that I am searching for in a cell. For each pattern I find in the cell, I want to parse the matching string and write it to a new row in a new worksheet, along with a key value in a separate cell. I am writing a function in a module. I am able to use the like...

I'm trying to "consolidate" the values in a cell through vba. Over the course of a month, any number of entries can be made to this cell as a + or a -. End of month I'm just looking for the "leftover" values that don't have a matching opposite, so the following entry...

hi Experts.. how can i parse the data from this website into excel? :confused: https://api.binance.com/api/v1/ticker/allPrices into 2 columns Symbol and Price really appreciate the help :)

access 2010 I need to parse the data for the 7digit numbers within a string. The digits will always be 7 in length. Some data in () are not numbers. Some do not have ending ). example data: Park smith (sam) Park miller 23 WT 456 Bisa Keepan (2345678) Ington (3456789) Untom (3245678 I...

Hi - I'm using this code to parse data from another sheet and it's working perfectly. However, I want to also add a total of each column from H to AM on each newly created worksheet. Is this possible? My issue with other codes I've found is that you have to specify the names of worksheets or...

Access 2013 I need to parse the field called Description to only contain 7 characters after the (. Can you help?

Hi, I'm looking for a way to parse a REST API in JSON format without any external modules (like from GitHub). Similar to libraries "Microsoft WinHTTP Services, version 5.1" or "Microsoft XML, v6.0" to parse an XML response, what library contains methods to parse JSON format? And what would be a...

Dear all, I have an excel-file with in cells B1, C1, ... , LastColumn1 the name of certain stocks. <tbody> Details BTC ETH NEO LTC ... "LastColum" USD 50 </tbody> Next, I want to send a JSON request to get the Open, High, Low and Close price of these assets. An example can...

Hi, I have a 2013 access db that is pulling info from a 2013 excel sheet that is updated frequently. I had to do some digging to find out how to parse and convert data from one cell into multiple cells so that I could properly query the info in access - all date and time info is in one cell...

Access 2010 I have a field called Description and need to parse a 12 space word that begins with A9B. i.e. A9B123456789012 It could have words before and after A9B123456789012. like A9B123456789012 oil mount A9B123456789012 fire missing A9B123456789012 washer A9B123456789012 I need to have...

Hello everyone i hope i find solution. I am trying to parse a table with web query and external data in excel from this location Κουπόνι Ποδοσφαίρου ΟΠΑΠ - online στοίχημα | KingBet but the table never show up. Do anyone know how to do it? ********...

Hi Experts, I have data in the format below(only show 2 'rows' but there are many more): https://drive.google.com/open?id=0B1j1jydhw0GhNzhBdTJaTWhwUDA I would like to parse it into format below: https://drive.google.com/open?id=0B1j1jydhw0GhelpYNGlqZEVFMUE Anybody can guide me on the macro...

Hi i have problem to get data with this site http://cdn.tsetmc.com/Loader.aspx?ParTree=15131P&i=57875847776839336&d=20170606 In this website we have a lot of data what i need to get is tagged by "//script[contains(text(), 'BestLimitData')]" and "var IntraTradeData" what is the vb code to get...