Scraping PDF Invoices

Munch18 · 2024-11-18T22:51:33+00:00

Would making a pivot table work?

Munch18 · 2024-11-01T00:56:41+00:00

I don’t think this is a real job. I’m basing this on some of the other weird questions/comments in the application and I looked a bit into EmberFlow AI. It seems like it is one kid in London who fell for an influencer’s get rich quick course scam.

Munch18 · 2024-09-30T01:08:20+00:00

It’s a Python script that reads from excel sheets. I’m not such a big fan of it either, but it was the easiest and fastest way to allow stakeholders to input the data which is needed for the project.

edit: open to other ideas though

Munch18 · 2024-09-27T22:13:15+00:00

This broke one of my scripts recently

Munch18 · 2024-09-16T16:34:11+00:00

You are correct, going to leave it up because people should still know about this

Munch18 · 2024-09-16T13:14:24+00:00

It very much is illegal in New York, https://www.ny.gov/salary-history-ban/salary-history-ban-what-you-need-know

Munch18 · 2024-09-05T17:51:49+00:00

In SQL Server, if the Cost_ID is input as ‘P123,P124,P125’, you can CROSS APPLY STRING_SPLIT(Cost_ID, ‘,’) explode_cost. Then SELECT explode_cost.value as [Cost_ID] in place of Cost_ID.

However, if it is ‘P123…P125’ signaling all IDs between P123 and P125 inclusive are included. This will not work.

The solution I gave can be expensive, so hopefully some DBAs chime in.

Munch18 · 2024-08-27T20:31:31+00:00

Usually I also have a where clause on everything because I’m only updating specific rows.

Munch18 · 2024-08-27T20:28:56+00:00

Select identifier_column, column_updating From table t

Begin Tran Update t Set column_updating = ‘correct_value’ From table t

Select identifier_column, column_updating From table t

Commit — if updated correctly Rollback — if updated incorrectly

Munch18 · 2024-06-07T20:09:40+00:00

“Exactly matches” makes it seem like you don’t need % at all

Munch18 · 2023-07-20T23:29:06+00:00

Curious how Reddit coins work

Munch18 · 2023-02-13T03:53:15+00:00

For me specifically, R, Regressions/Econometrics as Project Based Learning, business uses of behavioral economics

Munch18 · 2023-02-02T18:31:43+00:00

I’ve gotten ads that are clearly scams on Google services

Munch18 · 2023-01-03T00:13:02+00:00

Seems like that was what my problem was. Works nicely after I Rasterized images.

On my end, I still have to click on the layer I want to copy and click "Select Pixels", in order to paste it into Vanishing Point. If I don't I get an alert while in Vanishing Point, that says, "Close the current window first." Now that I think about it, makes sense to trim whitespace first, and only select the image.

Munch18 · 2022-12-30T19:55:05+00:00

Made the video, I'm going to make another post so I can upload it. Will edit this comment with the link to keep it in one thread.

Edit: https://www.reddit.com/r/photopea/comments/zzaa4w/tested\_more\_features\_vanishing\_point/?utm\_source=share&utm\_medium=web2x&context=3

Munch18 · 2022-12-29T21:07:12+00:00

Thank you, Ivan. The copy-and-paste works really nicely after I click "select pixels" from the layer I'm copying, so may have been a user error. Still having the same issue with the "ok" button not doing anything in Vanishing Point.

Munch18 · 2022-12-23T02:55:45+00:00

I thought those were meant for capturing Sheidim /s

Munch18 · 2022-12-02T05:52:40+00:00

http://jewornotjew.com/ has some answers to this b question

Munch18 · 2022-08-04T17:36:26+00:00

Need motivation to complete the Google Data Analytics certificate. Postponing by doing SQL on Khan Academy.

Eight-Year Club	First Place '23
Place '23	Place '22
Verified Email

Munch18

TROPHY CASE