Comments by ekipongi (Top 29 by date)

For the benefit of others below is the answer. After a bit of reading on Pivot in ms sql got the answer that I wanted.

select *
from
(
select Name, ID, Amount
from Table1
) src
pivot
(
sum(Amount)
for ID in ([A], [B], [C])
) piv;

I want a column of distinct name, and the actual data in the ID which are A, B and C to be columns and the Amounts to be the data for the ID columns. For clearity, in my initial table as is shown above there are 4 columns, Name, ID (which contains A, B & C), Amount and the Date. I just want to display distinct names with 3 columns as A,B & C. the amount should be under associated ID as is shown in the 2nd table above.

Thanks _Damian S_

It worked as I wanted.

ThePhantomUpvoter, the code I posted don't have any error as is confirmed with a simple windows form application. It's working fine in the Windows form apps but I just need a windows service for this so asked. How will you do debugging to check for errors when creating a windows service if that is what you meant?

Hi Sergey Alexandrovich Kryukov, This is just a test to see if this can work in Windows Service as I'm working on a project to check if files exist in a location and if it does the contents will be copied while adding new header and footer lines to a new text file which will then be copied over to the processed location. So i posted the above to seek assistance in creating the service to copy the file for one location to another first.

Thank you TnTinMn. You have been a great help to me. I will try and modify your code to see if that will work as I required. Thanks once again.

Yes that's correct Dave. But i'm just lost as to how I'll work this out using the substring and the looping to get the strings I wanted. I have worked on this project and it's really tedious and I'm lost for this so please assist with the code if possible.Thanks.

Thanks ThePhantomUpvoter. Yes, I have used the String.Substring before but not too sure how to do that with looping to get the values/strings as I want from this. Note that the data in the files are at times more or less, etc.

Thank you so much OrigionalGriff. Got working but I'm stuck on the message bit as highlighted in the initial question posted above. How to check if F exists for each message.

seen the substring method but not really sure how I'd use that method to grab the date from the header. really need a help in the code to get this thing working. Thanks.

Thanks OrigionalGriff. The above padded sample file was sent to me. The code extracts above I posted is to clarify the question here. What I want to do is grab the date from the header in the above file sent to me. how could I do that? Please assist with any code sample to grab the date which starts at the 31 position and finishes at the 80 position?

Thanks _SA for the reply anyway. I'm just showing how the text file has been created from teh code extracts above. The length for the Header is 100 which is padded for each header details to cover the 100 length given. My issue is How do I read such a file and grab the Datefile from the header.

Thanks _Damian S_. Could you please post some codes for that. I'v worked on it and I'm really stuck and need assistance urgently. Thanks

These are the padding values for the headers. E.g H100 has a padding of 9.

Thanks TnTinMn for the assistance. Got it working.

Yes, that's what I'm trying to do but I don't know how and I'm stuck. If you can please assist me with the coding.

Thanks Ramanjaneya002. It will have 3 letter word all the time but it would be good if the code can also check for any number of letters infront.

Thanks Aarti for the reply. Didn't tried your code but I guess it would work. Thanks anyway.

Thanks Basmeh. Modified your code and got what I wanted. Thanks

now Could you please assist here again? now I want to check a specific value (:32B:) in a text file that contains millions of data and get the values (actual figures/amounts) excluding the currency. E.g. check if :32B: is found in the file and if it is found then grab the next value after this, which would be the amount. In essence it would be like :32B:JPY12561694,00
So pull out the 12561694,00 excluding the comma. So the actual data that I want to get is 1256169400

Thanks _Damien S_. I have tried your suggestion but the issue is still there. What I'd want to acheieve is that for each file in the inward file location copy the details to a new text file created in another location with new header and footer details. If there are 10 text files in the inward location then file processed would be 10 in a processed location.

Thanks Kanjolia, I have used grouping already and couldn't get what I wanted. A thorough explanation or answer as to how to get to the solution of the above issue would be good.

Thank you very much Ernest. I downloaded what you have put here http://sdrv.ms/QjleCk. However, I can't restore the DB onto my MS SQL Server 2008 Enterprise edition. Could you please send me the scripts of the DB objects so I can them? I really need this to work. Please assist as the DB can't be restore as it's in Express Edition. Now I have done the above already but I'm getting the following error when trying to insert new resume; Please assist. "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_users_pKeyUser". The conflict occurred in database "WORDLOAD", table "dbo.tbl_users", column 'pKeyUser'. The statement has been terminated."

How do I insert new resume and how do I retrive the saved resume. Do I have to input the Firstname and the Lastname and add the Resume for the client. It's not accepting my input for the names into the textboxes except from the datagridview. Please assist...

Thank you Wes, I have created a MS WOrd document and saved into the above directory as (C:\Documents and Settings\u13901\Desktop\Projects\Test.doc). When I upload the MS WOrd from the DB onto that there are funny characters being written onto the Word DOcument. How do i change that to write the resume details as saved? Please assist.

Thank you OrigionalGriff and others for the comments. My apology for using the term virus as I was confused with what right term to use. I'm not working for anyone nor working to gain funds. But out of curiosity I want to create it as a file that prevents others from copying the media files from the intended media, DVD or CD.