SQLPHX @sqlphx1 - Twitter Profil

SQLPHX @SQLPHX1

hampir 5 tahun yang lalu

@SQLEspresso Thank you!

0

SQLPHX @SQLPHX1

hampir 5 tahun yang lalu

@SQLEspresso Monica, if I sign up for the session and I am not able to attend, would it be recorded so it can be viewed later?

1

0

SQLPHX1 di-retweet

The Lincoln Project

@ProjectLincoln

lebih dari 5 tahun yang lalu

Here’s the letter George H. W. Bush left Bill Clinton on the first day of his presidency. A lesson in grace.

724

30K

4K

206

0

SQLPHX @SQLPHX1

lebih dari 6 tahun yang lalu

Then I need to grab the appropriate columns from Excel and add them to the “H”eader or “L”ine line in order to import the CSV. I don’t use excel much, any recommendations on the quickest way to do this? Thanks! #sqlhelp 2/2

1

0

Siapa yang Harus Diikuti

Enrique Argüelles

@SqlFerret

CSS Bi and Azure SQL Engineer MSFT, former SQLServer MVP that loves dogs and ferrets, my opinions are my own and not my employers

Gene Martin

@MonkGene

Database Developer, Software Developer, Sports Journalist, Locksmith Apprentice, everything else. :)

Steven Wheeler

@swheelerSQL

SQL Server DBA, Co-organizer Jaxssug and SQL Saturday Jacksonville, and Retired military missile electronics repair

SQLPHX @SQLPHX1

lebih dari 6 tahun yang lalu

I have an excel spreadsheet that needs to be converted to CSV following using a certain format, then imported into the db. The primary key will be created during the import but I have to split each Excel line into 2 lines on the CSV file: “H” & “L” (header and lines) #sqlhelp 1/2

0

SQLPHX @SQLPHX1

hampir 7 tahun yang lalu

@DesertIsleSQL Makes sense. I have been telling everyone that it was such a great experience and that's how a conference should be run. Had fun seeing you on the panel during the Speaker Idol finals!

1

0

SQLPHX @SQLPHX1

hampir 7 tahun yang lalu

@SQLEspresso You did a great job! Thank you!

0

1

0

SQLPHX @SQLPHX1

hampir 7 tahun yang lalu

@SQLEspresso I am there! Looking forward to the precon!

0

1

0

SQLPHX @SQLPHX1

sekitar 7 tahun yang lalu

@SQLEspresso Thank you! Registered and looking forward to it.

0

1

0

SQLPHX @SQLPHX1

sekitar 7 tahun yang lalu

@pshore73 @ALevyInROC @psdbatools Thank you for all your help!

0

SQLPHX @SQLPHX1

sekitar 7 tahun yang lalu

Starting out as "accidental dba" & wanted to see what you use to automate manipulation of CSV files. I get a CSV file from a vendor with a lot of garbage in it. Is there a way to automate it so I can pull only certain fields from it and then import it into my DB? Thx! #sqlhelp

2

1

0

SQLPHX @SQLPHX1

sekitar 7 tahun yang lalu

@pshore73 @ALevyInROC Thank you, guys. I have no experience with PowerShell. Would you recommend any sources to help me get started to tackle this issue? I assume there are already scripts out there that can be modified? Thanks again!

1

0