The text file is this:
073105AI0705411119000041401018070000 CY078A0000007288D 00355180700
073105AI0705411130020011401018070000 CY078A0000007288M 00355180700
073105AI0705411130020021401018070000 CY078A0000007288D 00355180700...
I need to convert the following data into a number. It is from a mainframe using a standard TSO app. The data represents a $ amount with 2 decimals but comes thrugh as the following:
0000007288D
0000007288M
0000007288D
0000024553{
If anyone can advise I would be grateful
TIA,
Stan
Remember -...
Create a formula that converts a date out of your internal layout into a traditional mm/dd/yyyy format. set up a parameter using input based on the formula you just created and then write an if/then statement to generate your report parameters using standard date formats.
It takes a few steps...
I have the above referenced app and it does a strange thing. I can open the app and get and send mail but it will not close propperly and I must reboot to get it to clear from memory. Ctl-Alt-Del does not show the app running but it appears in my sys tray.
I am using XP Pro SP2 in a home office...
Hi:
I tried to isolate the components and it turned out to be the DDR ram.
Thank you all for your help with this :),
stan
Remember - only dead fish go with the flow.
ouch
Hadn't thought of that.
Do you think that the cpu and other components may have also suffered. I need to let the client know and see what she wants me to do.
thanks for your help with this.
stan
Remember - only dead fish go with the flow.
Hi;
I found the MoBo info I was looking for. One additional piece of info - when I power up I get a very short beep just b4 power shuts off - can anyone tell me the significance of this? Also the time frame I am speaking os is less than three seconds.
Thanx,
s
Remember - only dead fish go with...
Yes = all is set up the way I received it from the client. I am not sure that it was correctly set up when they gave it to me and since I had to replace Power supply ... well.
Is there anywhere to get a digram of the MoBo = it is a P4G533-LA and I can't seem to find the details for it. I believe...
I just replaced a power supply on a Compaq S5200 computer (350W that is compatible with the unit I replaced) and now when I plug the PC in and try to turn it on I get a power active indication (lights are on and CPU fan is running) and then the power just goes off.
Anybody have any ideas on the...
HI,
I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it.
Can anyone help me with this...
When I use the TOTEXT format I get 02DDYY as a result. When I use the VAL format I get 2.00 as a result.
THe original value when I browse the data is
02/06/2004 12:00.
When I format thru CR it returns 02 06 04 as a result. The SQL table setup indicates a datetime type with 8 chr. Can this...
Hi,
I need to convert a date from an SQL table datetime to an ascii numeric MMDDYY field.
When I run the query I reformat the date to read as MMDDYY by removing the separators and assigning the correct output form. My problem is I get a result that catches the space where the separator would be...
I am trying to connect to my PC in the officethru remote access. Office server is W2K3 and office PC is on XP. I have a port address to search but when I try to connect using IE6 I get a syntax error. My firewall is programmed to allow me to pass thru it but to no avail. I am running Win98SE at...
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.