Search results

I completely overlooked the full function of TEXTSPLIT. Doing TEXTSPLIT(Text, "-", ",") actually splits it exactly as I was asking about.

I'm sure this can be done but is likely complicated to fully get what would be nice to have. I have a cells filled with a list of material and quantity. Example: (4)-QO130L200PG, (4)-QO250, (4)-QO240, (16)-QO120, (24)-QO120PAFGF, (4)-QO200TR, (1)-QOM2100MVH, (12)-QO120PCAFI, (24)-QO115PCAFI...

If a number were skipped it wouldn't matter as all I am after is a unique identifier. I just want to follow best practice while also not creating extra work for myself :). Also, that is a wonderful looking dog in your profile picture. My wife absolutely adores Pits.

Which is fine as far as the theory for what I want to use it for goes. Projects wouldn't have to be sequential so if a number was skipped it wouldn't matter. The only real requirement would be that it is unchanging so once a project would be assigned a number, that would be its number always and...

I know that you should not attach meaning to an auto-number field as its only role is to be unique but would it go against common practices to use it as a sort of "job number"? What I mean is when say a project in the database is created, you would use the auto-number to say that it is project...

I own a Galaxy watch and even "refurbished" it was around $200. I love it when I am being really active at work and not at my desk since my phone almost never leaves vibrate I cant miss the watch going off if I get a call or text. Just like Minty however, mine tends to spend most its time...

We have gone off on a tangent from the original question. Isaac was trying to recreate what I was doing and neither of us can figure out why PDF is a data option for me but not him lol. As far as the original question goes, I am going to split the cost column using the $ as a delimiter and Ill...

I double checked and I do have Excel 2016 but I also have a plugin from BlueBeam which is another PDF editing program. I don't see anything else that would give me the ability to connect to PDF's. I swear that it has to be a built in feature to the version I have and not plugin dependent.

Yeah it must be the plugin I have. I have O365 but I believe my Excel is 2016.

Interesting. I do have the Acrobat plugin, so maybe that is why that is an option for me. I have always had that plugin so would have never noticed if connecting to a PDF wasn't a "stock" feature of Excel.

Under that and from file should be PDF. You skipped this step and went straight to Power Query which I dont think I have ever done.

Unfortunately I cannot. I probably shouldn't have shared the snip that I did :LOL:

Correct. Power Query, no matter what application you launch it from (Excel, or any of the Power apps) all use M. It, along side Python has been the main language I have been trying to learn with some T SQL sprinkled in here and there. Have also been dabbling in DAX with Power BI.

That I couldn't answer. I just go to the Data tab and choose Get Data > From File > From PDF which then opens a window to select either specific tables or entire pages, at least on the files I am using. Once a selection is made, you can load it directly to the workbook without any fuss or go to...

That is entirely possible as we get issued this file every few days as pricing changes (hence my automation of this).

What you see is what I have. That is the code from the start of connecting to the source file and the attempt to split the columns apart. It worked once upon a time, which I forgot to mention so that is on me but I have no clue why it started throwing this error when it didn't prior. It isn't...

I would assume it is correct as it is system generated (I didnt type that part). As for program, it is M in the advance editor in Power Query which I am currently using in Excel. On a side note, I was kind of surprised the code selector in post didnt list M as an option. Doc, I may end up just...

I am getting this expression error in the query editor when connecting to a PDF with a table I am trying to link to. let Source = Pdf.Tables(File.Contents("C:\Users\tmyers\Desktop\Commodity Price Files\Copper.pdf"), [Implementation="1.3"]), SplitEachColumns = List.Transform(...

My searching is only turning up convertor tools or ways to do it from Excel and not Access but even what I found there wasn't quite what I am after. I am trying to replicate what Acrobat does when you do Save As and choose .xlsx as the file format. It takes the PDF and converts it to a single...

That did the trick. I tend to have a bad habit at using temp tables so really didnt want to use one this time around.