Hello all,
sorry for my query, it's a long one
basically it consists of 2 select statements on 2 tables, each select statement gets the top 10 and self join it to the rest 90 as others.
now I need to join the 2 statements together full join, as there's of course different top 10s in each of...
Tsuji,
Thank you so much for your help, you're the best..I ended up doing that
----------------------------------
Const ForReading = 1
Const ForWriting = 2
Const UniCode = -1
strSourceTxtFile = "PXDRAD January 2010 thru May 2010.txt"
strTargetTxtFile = "PXDRAD January 2010 thru May 2010 - One...
ohh no "[0.2] Since it appears in line #10, and that you read pass 20 lines ignoring them, there is no vbFormFeed character to split from line #21 to line #23."
Sorry my code reads the whole data file not the sample, i test against the whole data file
Ignore that skip on the sample file when...
tsuji,
good morning...
Thanks for joining and god bless for sharing the knowledge :)
but really I don't understand what you're talking about, i'm a DBA and just need to clean the data files before processing
can you clarify please? code? example?
Thanks
Hey PHV,
merci beaucoup for your help, i've tested it on the original file, but WOW it's still running for the last 30 minutes !
so i've gave it a try on the sample data file, it didn't work, it only have one line in the output.
here's the script that i've used...
Hello VBS Gurus,
I've an easy challenge for you :)
I'm working on a text file, the Data comes in 2 lines, but some lines has "FORM FEEDER", doing the following code to replace the form feeder by a new line
and then split the contents so I can merge the 2 lines
the results:
It removes and...
MDXer,
I figured it out using this query......
SELECT A.MedRecNo,
A.AdmitDate, B.AdmitDate AS ReAdmitDate,
A.DateOfDischarge, B.DateOfDischarge AS ReDateOfDischarge,
A.PatientNo, B.PatientNo AS RePatientNumber,
A.PatientName...
Cheers for reply, you're too technical for me, I just don't know what to do with the results of the query...
i'm not really a programmer, I know some basics and I work with SSIS.
but really i'm stuck and need to get this report done, and I don't know what to do !! I've been search all over for...
Thank you MDXer for the fast reply...
I've edited the query to look like this
----------------------------
WITH t AS(
Select
PatientName,
medRecNo,
AdmitDate
,DateOfDischarge
, row_number() OVER(PARTITION BY PatientName Order by PatientName) as rec
From report
)
Select
PatientName
medRecNo
...
Hi all,
I've a flat file that I cleaned the data out using SSIS, the output looks like that :
MEDICAL ADMIT PATIENT PATIENT DATE OF DX
REC NO DATE NUMBER NAME DISCHARGE Code DRG #
123613 02/16/09...
PH,
you're the best, thanks a zillion.
my only concern that i don't understand the difference or your addition...can you explain it please when you have a chance...
the reason i'm asking is I've a different report that comes in 5 lines this time!!!
i'll post example for the file...
PH,
Thank you so much for your propmet replay, whoever i'm not into programming, i'm in management and trying to automate the procedure that i'm doing.
I started by reading online how to checkfor the source file and create the output file with the current date and time, but no luck so far
Hello,
I need some help creating a batch file to automate the process of removeing double quotes in a text file.
the double quotes are in the beggining of the file and at the end of the file.
also in the middle and removes 2 spaces to join two lines into one line.
example is attached in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.