Questions tagged [text-to-column]
The text-to-column tag has no usage guidance.
text-to-column
77
questions
1
vote
1
answer
36
views
How to parse pdf in r and then correctly convert or extract spaced/tabbed pieces of text into columns of dataframe?
I am reading a pdf in r using library(pdftools)
library(tidyverse)
library(pdftools)
library(lubridate)
pdf_rowwise <- strsplit(pdf_text("V://path//sample.pdf"), split = "\n")
...
3
votes
4
answers
63
views
In an Excel file, extract separate lines of information in one cell as multiple rows
I have an Excel file of records where one field is meant to track historical events. The file is unique by a specific Id, but this Id may have many events associated with it, up to 30 or 40. These ...
0
votes
1
answer
45
views
Delete records based intervals date in text format
In mysql table we have one column intervals type text
select intervals from scheduled_jobs_v2 where job_id='agg-c902817b-90fc-4396-a61b-57f0b1169d21-PM-5G-huawei_dc-1hour-cell-11233806883185660' limit ...
0
votes
0
answers
24
views
KeyError: 'What is Included'
"C:\Users\manoj\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\core\indexes\base.py", line 3797, in get_loc raise KeyError(key) from err
I have data is in excel below is ...
0
votes
2
answers
158
views
VBA Text To Columns not fully applying 24hr format to time
Morning all,
I've got the below section of code which doesn't seem to want to convert the time element of column A into 24hr. The data is in original format dd/mm/yyyy hh:mm:ss. Every time after ...
0
votes
1
answer
85
views
Fastest way to parse a Word document containing Transcript text into Excel columns
I have multiple word document files, each containing transcript text like below (paragraph marks not shown):
Some Title1 ' <--- Some title ending with paragraph mark
(Apr 3, 2023 - 9:...
-3
votes
2
answers
98
views
Extract multiple strings between brackets or two different delimiters
I'm trying to extract data between these two delimiters [,]
for two cases: Beginning with #CB or CR:
Input data:
Scenario,Order_ID,Review
1,1234,<Order No. 10><Remark>Food was good</...
0
votes
2
answers
72
views
Manipulate text to column function in Excel and separate text with variable number of delimiters
I download data from a vendor and the identifying data, (the first column), has an individual's name and their participant number in the same column separated by commas.
The info is not in general ...
1
vote
1
answer
717
views
Convert Text to columns in Excel using VBA for dynamic columns and Rows
I have a report wherein i need to do Text to columns for dynamic columns( columns are usually around 24-30 months). I have used the macro recording to currently perform text to columns only for fixed ...
0
votes
1
answer
125
views
Excel Formula To Replicate Text To Column Functionality
I would like a formula in excel that does what Text To Columns does.
For example the following string in A1
" text with a comma, stays in one column",," keep starting blank text",1,...
2
votes
1
answer
1k
views
Snowflake - how to split a single field (VARIANT) into multiple columns
Within Snowflake how could I split a string of data that's in a single field into multiple columns? This field is in a View and a type of Variant.
My View that I'm querying has 12 actual columns. 1 ...
1
vote
1
answer
363
views
How do I split text to columns in Pandas without getting "Columns must be same length as key" error message? [duplicate]
I tried splitting one dataframe column into two based on "-" as a delimiter, and I'm getting a ValueError that reads "Columns must be same length as key," even after following ...
0
votes
1
answer
1k
views
Google Sheets Split Text to Column by First Text character
I have 1 column of data that I want to split to units & product name.
In the desired format its not really necessary for headers, so if we need to omit them that's fine. I normally have around ...
1
vote
2
answers
679
views
How can I convert a table that have being copy-pasted to a pandas DataFrame?
How can I convert a table that have being copy-pasted to a pandas DataFrame?
As an example, I have the following table that have being copy-pasted:
Step Training Loss Validation Loss
5000 8....
1
vote
0
answers
108
views
TEXT-to-COLUMN xlDMYFormat date format error
I'm trying to do a text to column using "!" Char.
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=...