parse

  1. A

    Parsing

    Hello! I have a column that has a lot of rows with different text, but the logic of it is always the same. I need to parse this data to columns. Every element should be splitted after "," . And this {} shouldn't be included. So the destination column name are like Key1, Number 1, Meaning 1...
  2. S

    Parse JSON into Excel

    Hi I have been using the Jsonconverter vba parser available via https://github.com/VBA-tools/VBA-JSON to extract the data from json files such as https://stats.europeantour.com/v1/season/2019/players/strokes-gained/off-the-tee. This has been very easy to set up and it works. However, the...
  3. E

    Parsing Data / Advanced Text to Columns for Non Uniform Data

    I was hoping someone would be able to assist me with a question I have regarding a text-to-columns type scenario. I have copied names, number, address and titles from a website but when i past it into excel it all goes into column A. Normally, if the data was uniform and consistent, you could...
  4. A

    Parse email address from long strong

    Hello I have a long string of email addresses - in the hundreds that are all in one line. They are bracketed by <> and separated by ;. How do I parse them into their own cell? Example: Fred Johnson<fred.johnshon@bla.com>;Jaime Post<jpost@yahoo.com>'......... I want to turn into...
  5. P

    Using this barcode to split data into columns (pharmacy related)

    Hello everyone! I'm a pharmacy student working on how to extract numbers from medication QR codes into individualized columns in Excel. For example, this code <tbody> 010030093552606517201130101040951182110091947809740 needs to put into 3 columns: GTIN, Lot, and Expiry date. GTIN is donated...
  6. E

    Parsing Key Value pairs from inconsistent and incomplete data

    Hey all, I have a CSV file with the following data in rows: <tbody> {'gender': 'male', 'age': '35', 'hometown': 'Chicago', 'car': 'Civic', 'occupation': 'actor', 'salary': '80000'} {'gender': 'male', 'age': '32', 'hometown': 'New York', 'occupation': 'banker', 'salary': '130000'}...
  7. M

    Looping through a string value based on occurrences of a value and parsing out values into new rows

    Hello all, So I'm trying to do something a little bit complex but am not sure how to tackle it as I'm very new to VBA coding syntax (but intermediately experienced in other programming languages) Basically, I am trying to parse through this text: <Start> <Step> <Description>...
  8. bfreescott

    Need a quick way to parse the contents of a cell

    I have a cell with thousands of values and I need to parse the values into separate cells after every third value. Text to columns only wants to separate every value, but I need to keep the values in groups of three.
  9. R

    parse data from text file

    Trying to extract data from the following repeating prompts based on voice-port <colgroup><col></colgroup><tbody> voice-port no snmp trap cptone timeouts description station-id name station-id number caller-id corlist incoming </tbody> Have tried multiple approaches and all...
  10. R

    parse data from text file

    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: ...
  11. A

    UDF for Last One in List in Cell

    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.
  12. A

    VBA COde To Parse Text to Column trouble

    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...
  13. J

    Parse text with a keyword "else"

    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...
  14. I

    parse cell data

    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...
  15. S

    VBA Parse out the 3 digit numbers

    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>...
  16. S

    Convert JSON data to time series data in excel

    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/ {...
  17. G

    Parse cell using patterns

    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...
  18. TryingToLearn

    Parse and match opposite numbers in a cell

    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...
  19. C

    How to parse this URL

    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 :)
  20. D

    parse 7 digits after (, but only if numeric

    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...

Some videos you may like

This Week's Hot Topics

Top