parse

  1. J

    ParseJson error, "Object doesn't support this property or method"

    Hey all, I'm having some issues with parsing data. One of my coworkers sent me a macro (with one module), when I ran that macro in the workbook he sent all worked well and no errors. But when I copied and pasted the module into my workbook it breaks in the "set parse = .parsejson" I'm unsure how...
  2. airforceone

    String Parsing

    ABCD1Copied EntryExpected Result2Dog*Brown,White,Black,Dragon*Golden,Green,Red,Black,Panda*Red,Black,GreenDog*Brown,White,BlackDragon*Golden,Green,Red,BlackPanda*Red,Black,Green As shown above I would like to parse the cell value for every "*" entry to arrive at the expected result, below is my...
  3. C

    VBA Code to Find Value then Parse Data in Selected Cell

    I need to have a macro that parses the data in the selected cells that contains the "=" value. Currently, I have two VBA codes. 1. The first (VBA code) works to find all cells with "=" value and is supposed to then parse all data, separated by spaces, in the selected cells into their own...
  4. S

    Excel - Parse Data and Categorize Based On Criteria

    Hello. I am trying to do the following: I have a part numbers listed in Column A. Based on how the part number starts, I want to categorize it appropriately. Based on the following: A1 = has part # (PLM123-ABC) I want B1 to return 1 (for the category) A2 = has part # (ABC-123-XYZ) I...
  5. S

    Excel - Parsing Data

    Hi . I am trying to parse the following. Column H is my source that I am trying to parse. Part Description Column I is the first sub part (always starting on the left hand side and continuing until the first space in the text) various lengths and various starting text (HKL vs E, etc..) Column...
  6. D

    Parsing a word document into a csv or other machine readable format

    Hi all, I have a non-delimited text file of health data called "2013_data.txt". This text file doesn't have any structure to it and the only way to structure it into columns and rows is to use the specified fixed length positions for each variable as indicated by the data dictionary...
  7. moshea

    Formula to Parse text for menu items ordered?

    Greetings all, I hope someone can help me. In Column A, I have Orders (lots). And I want to parse the text into individual items ordered in the columns next to each other. Any suggestions? Thanks in advance! Example: From this Green Man Draft 4.98 Infusion ****tail 7.01 PREMO CAN COCTAIL...
  8. E

    how to separate HTML tables from one cell into multiple cells?

    Hi, I have a complicated situation with an unwieldy amount of data. The situation is I have data from my website in excel, each row is a profile (around 100k profiles), that all biographical data is crammed into one data field (or in this case, a cell, since in Excel) in HTML format. The HTML...
  9. K

    Parsing data into columns

    I was hoping someone would be able to assist me with a question regarding parsing data. I have some information that I want to parse to columns. However, the data is inconsistent. Normally, if the data was uniform and consistent, I could have easily used text to columns. Here's a sample of...
  10. S

    Application.ScreenUpdating AND Application.EnableEvents in Python ?

    I am processing over Excel files in Python, and opening it as a part of it. I suspect my code doesn't execute fully because it doesn't recognize warning messages In my VBA code I use the following: Application.EnableEvents = False Application.ScreenUpdating = False But I am not sure how I...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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'}...
  17. 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>...
  18. 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.
  19. 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...
  20. 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: ...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top