Forum Discussion
Grouped text conversion to columns in Excel
- Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
Attached! I wasn't able to pull into individual columns, but am grateful for another set of eyes! Khizar_Hayat
I'm not @Khizar_Hayyat but think he'll come back to you with a renewed request for an actual text file. What you sent is in a Word document, but actually just contains an image of your text file embedded in a word doc; it is neither editable nor amenable to parsing into separate characters. So at best there'd still be a need to use OCR to get it to text. Make it easier for @Khizar_Hayyat by uploading the actual text--and yes, turn the names into fictitious ones first.
For myself, back to the question of the source being available in CSV instead of text, it's hard to imagine a service provider not being willing to do that service. (Although I will acknowledge having been frustrated when Apple first released their charge card, in conjunction with Goldman, that they provided monthly statements only in PDF form. It took months before they rectified what should never have happened in the first place.)
- It's an internal program and this forum doesn't allow for a txt upload
The message says:
"The file type (.txt) is not supported. Valid file types are: jpg, gif, png, mp4, doc, docx, ppt, xls, csv, ics, pdf, mp3, oft, zip, pptx, xlsx, .cqdx, accdb, xlsm, xlsb."
Rename you file.txt to file.csv.
IMHO, two main points to clarify
- logic of input file. Is it with fixed width columns or not. If so, how many characters in each column. If not, what the logic. What are flexible -why employee ID/name sometimes in first position, sometimes not, what are the options.
- logic of output. Are employees ID and name in first two columns and all few dozens of other ID:s in other columns or not. Shall they be separated on 4 groups (Pay, Deduct, etc) or not. If yes, when how.
- All data was in one column when converted or opened in Excel. All possible field identifiers needed to be in columns. Someone was able to use IF, sumifs formulas & pivot tables to convert the data for me. I appreciate your reply!
