Comments by Sumal.V (Top 200 by date)

I know how to do that in a macro, but its tedious. Moreover the excel file has many sheets and I'm only using this for testing.

Did you mean manually replacing all the values ?

Hmmm I must be replacing over 1000 values then :O
I must have mentioned that in the question..

Cheers, That works.
But it is different. For example, if its an If statement, every line is aligned to the left, spoiling the flow/look , but by explicitly pushing some lines to the right and then realigning to the left keeps the format right.
But thanks :)

P.S. Can you add this as a solution so that I can take this question off the unanswered list.
Thanks

I'm using Excel VBA, to code the macros.
There aren't any shortcuts available too..

Save your .exe file in some other directory and check.

Thanks a ton! That works :)

Yeah I use Visual C++. But this didn't work ! But hey Thanks :)

Hey if you want to learn, then pick up a book and start. Learn the concept and look for examples based on that concept. like examples for threads, functions, arrays and so on. That way you can at least understand what is going on in there, rather than picking up some random code and breaking your head.

Simple parser like? And would that not do exactly the same thing, but in a different method..

Wish I could vote this message :)

Hey there are 5 solutions posted for you. Please accept a solution, so that this question goes off the unanswered list.

Or if you are still having problems, ask!

Thank You :)

Hey thanks.. but the problem is just solved. Looks like you work with GPS data as well... ;)

Yeah that works :)Cheers :)

The only change being the reference type. Here "." is used instead of "->" operator.

I guess this was like using a calculator to calculate 2 + 2! I was completely blank, but yes I had tried earlier but may be I was doing some silly error somewhere :/

Yes instead of _T("\n"), if I use _T(","), I can add labels in different column :) Thanks a lot. :)

Reputation Points! Common! :P

Thank you :)

Can I have an example please...

Well the problem is with my SetValues function. I need to use some other way of parsing the string (and its different formats).
But thank you :)

Yes I understood about the %%d but thinking how that applies to my code. But is that a good way of including a formatted string?

Crappy? :( I don't know! Updated the question just now.

I finally got the program working. Took a while for me to understand, I'm a very slow learner. But Thank you :)

Nope I'm not doing that mistake of asking ;) But thanks so much :)

I don't understand why you have chosen "CString DataType" variable ; And what is the main function of SetFieldData()?
Can I not just use scanf function to read the file and add the variables into the SurveyTable..
And I want to know why the ParseDateField, setDateRecorded are for?
I'm surely not asking for you to make my project for free. You got my 5 for the answer.
But hey, how much do u charge ? ;)

Hi that's alright. Just found a beginner level article on Lists :)

Thanks for that. May be I'm asking for too much,but could you please give me an example code, with some values, for a better understanding. I browsed the internet and found few examples, but they either look complicated or not relevant. Thanks again

I do have a book with a case study on lists but its starts with simple variables and by the time I could get to the middle of the program I had lost track of what I was doing.

And Can I also know what the SetFieldData () is for..

Hey Jack, the lines:
virtual bool SetFieldData(LPCSTR szDateRecorded, LPCSTR szDataType, etc...);
virtual bool SetFieldData(LPCSTR szDateRecorded, LPCSTR szDataType, etc...);
Did u mean to override the SetFieldData, for the rest of the variables?

Yeah I'm trying to work with lists as explained in the solution 2. Thanks :)

Thanks so much for the wonderful example. It looks like an complicated exam question with lot of clues. Will give this a try :)

Okay, I've never done anything involving lists and complex functions. WIll give that a try. Thanks

Do you mean use of Lists?

This is a sample code:
//1 read
if (csf.Open(fname, CFile::modeRead))
{
while (csf.ReadString(buffer) )

{
out = swscanf_s(buffer, _T("%[^,], %lf, %lf, %[^,], %lf, %[^,], %d, %d, %lf, %lf, %[^,], %lf, %[^,], , %[^,]"),
str1, 2046, &sTime, &db1, str4, 2046, &db2,str5, 2046, &in1, &in2, &db3, &db4, str6, 2046, &db5, str7, 2046,str10,2046);

double templat = int( lat1 / 100 ) + ( (lat1 / 100 - int( lat1 / 100 )) / 0.6 ); // latitude in degrees
double templon = int( lon1 / 100 ) + ( (lon1 / 100 - int( lon1 / 100 )) / 0.6 ); // longitude in degrees
//lat/lon calculations
sumLat = sumLat + templat;
count++; // int count = 0;
}
else
{
//error report
}

}
csf.Close();
}

meanLat = sumLat / count;

//Second Read
if (csf.Open(fname, CFile::modeRead))
{
while (csf.ReadString(buffer) )

{
out = swscanf_s(buffer, _T("%[^,], %lf, %lf, %[^,], %lf, %[^,], %d, %d, %lf, %lf, %[^,], %lf, %[^,], , %[^,]"),
str1, 2046, &sTime, &db1, str4, 2046, &db2,str5, 2046, &in1, &in2, &db3, &db4, str6, 2046, &db5, str7, 2046,str10,2046);
lattemp = db1;
lat = int( lattemp / 100 ) + ( (lattemp / 100 - int( lattemp / 100 )) / 0.6 );
latRad = lat * (ML::pi)/180;
deltaLat = latRad - meanLat ; //MeanLat is used for every single line.
.............

Nope sorry, I've updated my question.
B/w I must do that as I apply these calculated values to values in every single line and display them..

Hey sorry, I've updated my question. That is because after I read the first time, I calculate the average and in the second read I apply this average value to every line in the file n so on ...

Alright..

These programs are pre written/defined and I cannot alter anything in there. But yes I did have a look at the link you've sent, but don't quite understand what is wrong.

In this particular class, there is a settings function, where the object is added:-
obj.Item(_T("Source_Easting"), m_srcENZFx.x, 10);
There is another function in another main class where this function lies-

void CESetObj::Item(const CString& itm, double& val, int dp)
{ CString str, fmt;
fmt.Format(_T("%%.%dlf"), dp);
Add(itm, fmt, val)
}.

CV3 in my program is a class with one of its method- CV3(double x, double y, double z).This is mainly used in calculations involving latitude, longitude and height.(3 parameters)

I didn't get you.. it is displayed using :
InsCtrl(80, EC_EDIT,m_userENZ1.x);

where InsCtrl is a method in the class - CECtrl
InsCtrl(int c, int type, double& val, CEFlex* pFlex)

CV3 in my program is a class with one of its method- CV3(double x, double y, double z).This is mainly used in calculations involving latitude, longitude and height.(3 parameters)

Alright, thanks :) Indeed have got some answers for my question. Is it because of the editing? I don't know, But I'm glad :)

Haha, never expected so many supporters for the editor :P
But thanks, I checked that :) There was an extra bracket in the heading itself!

Oh yeah, must come out of using the SMS language ;) cheers

Cheers, Thanks for that :)

Yup thanks, including brackets helped :)

Cheers Richard, That helped a lot.

Yippeeee....Thank u soooooooooooooo much. The 90.0/180.0 instead of 90/180 made a big difference :)

Thanks, was being a lil silly :P

Oh yeah thank you, I tried the LEFT function, but that could be applied on a single cell
Cheers :)

Sorry I made some mistake while copying the values. It works. Thank u very much :)

Thank you very much. But I have another problem. In my previous method, where I specify the path name, I get an Import Wizard, where in I can choose the type of file, file origin, select the delimiters.
Because I select a .csv file I must specify the delimiters like comma.
The above method imports the data and prints them without organising them into columns. But now since it only selects the file name, I have no option to select the delimiters..

If down voting please give me the reason, so that I will know what is wrong in asking a sensible question! Thanks

But v can always format the axis. An that is what I'm trying to do..formatting the x-axis containing the time...

I display the time from my C++ programming into an excel sheet. Now I work with this to produce the excel graph. I do not get much response if its excel. should I take off the c++ tag ?

:) yeah but what I mean is instead of giving the chart name I want to use the ActiveChart, which means I can use that as a standard macro and use it on any data set.

ActiveSheet.Shapes("Chart 42").IncrementLeft 400.5
This is the chart number I'm talking about. The chart numbers keep changing every time

I can see what is happening but the code generated by recording the macro has chart numbers generated and hence not feasible. Every single time I have to change the chart numbers and run

The problem with recording the macro is that, the chart is generated along with numbers which means chart 1 is generated while recording the macro but next time the chart value changes to 2 and this causes run time error: name not found...

What do I modify in the same code as shown above such that instead of a range of values being selected, I must select just one column?

Yeah I understand, just thought there might be a way to do that.

And if I get rid of that line, no data is selected

Cheers :) yup I've got 2 monitors and can see what happens exactly. I got rid of the "Selection.CurrentRegion.Select" and changed the Range the Range to D4:D7, but Could not extract the values yet. But thanks :)

so what should I change that to?

Sorry, I'm working based on an example from the link: http://support.microsoft.com/kb/213352

it contains cells C, D, E, F . when I say Range(C:C), the macro is applied to C, D, E, F as well not just C

Yeah, In that above code, if I change the range to A1:A11, it still selects the entire area.

if i record the macro,
ActiveChart.SeriesCollection(1).Name = "=Sheet1!$A$11"
ActiveChart.SeriesCollection(1).Values = "=Sheet1!$A$1:$A$11"
but again I do not want to specify the sheet name. I have updated my code.

Well not thought about generating letters in programming yet! ;)

I meant letters in a 'text'. I generate a report into word, say the date, name of the project and the specifications, while outputting in a string, can I apply any formatting ? changing font colour or making it bold..

Its just a simple Stdio file,
of.WriteString(DispValue(val));
where of is the CStdioFile of;
and DispValue(val)is a function that returns a string of values

Oh well, yeah. I always to do try things in complicated way and end up in confusion. B/w it is not 21 decimals, its 2l(2 followed my letter "L")

Exactly! since I work with latitudes and longitude values from csv files, I always encounter such problems!

yes rounding is the word! I din't quite understand this example(for my level) ..need sometime to go through.. but thanks

Yeah I have done that, but since I'm converting calculations that were in excel to c++, the calculations are based on the rounded off values and they differ from the dynamic values obtained..

Yeah this works as well. I now wonder why I used w_char types instead of CString itself.I'm sure I had some problem earlier, I'm just blank now. Must maintain some documentation. But thanks for keeping up with me :)

Good morning!,I checked the code with a break point but realised that since the variable in both the if and while loops was str1, ie both pinitialTime and pfinalTime were assigned this str1 variable, at the end when the final time was taking the final value, initialtime was assigned the same value. I changed the variable names now as initstr1 and finalstr1 instead of str1 for both and that gives me the right values..

And If I add the semicolon, I get run time error. when I checked the code in debug, I found that the program does not move after while();

That's the reason I took it off.

This results in both variables taking the same values as well..

Cheers, it works when I pull the initial value before the while loop starts. I will work out why both the variables take the same value, when they are printed after teh while loop.
Thank u very much :)

I updated my code, but bothe the first and last values get the same values ie(last ). I have shown my updated code in the question.

I cannot extract any values before this statement.
while (csf.ReadString(buffer));
There the variable gets no values/garbage values before that line of code .

Hi,I have updated my question.

Ummm.. it doesn't look easy for me :(
if I try extract one value, that will apply for all the values, as it is in a loop. so everything the loop is run, the particular column value will b printed.
And I must go into the while loop to start reading the values .

Will update my question.

Oops sorry, yeah. It is a csv file that opens in excel.
Yeah if I change that myself in excel it does change the format and display the desired values. :)

Cheers

Using swscanf_s function.

I assigned the dynamic value to a pointer and it works...
wchar_t *pStrId = str1;

//pStrId now takes the correct values.

cheers :)that worked

Thank u :)

And it is the npos value its taking..

Cheers, but when I used std::wstring strId;
strId = str1;
The format / value is completely different. The value obtained dynamically is "21:00:55" but the strId value holds "4294967295"

Cheers :)

Well just tried using double instead of CV3 but teh str1 and str2 are still gthe same..

Yes both take same values and return false.. sorry they are comma separated values.. I doubt if its anything to do with the vector format CV3.

OOps sorry took a while..

I did use the reply button. If I can ask another doubt, I know it will b downvoted but I believe its always good to ask questions.. I have updated the questions for your reference.. Please help

That's a meaningful example, understandable code and gives awareness of drinking :)But I must use sscanf functions, as I'm adding additional functions on a existing program and I'm supposed to follow the uniformity. :(
But thank you :)

If I get this working , half of of problem will be solved..

Hi! I've just updated the code.

Again, as u said, I changed the format to :
lineval : is same
searchStr=_T("%s,%s,%s,%lf,%c,%s,%s,%s,%lf,%c");
swscanf_s (line, searchStr, str1, 50, str2, 50, str3, 50, &doub1, &chart1) ;
//none of the variables get any value...

Well its not a simple string . I have open a .csv file containg thousands of lines, each line of the format something like this :-

21:00:55 $GPGGA 210055 6102.00399 N 107.5920998 E 2 9 1.2 23.57 M 47.57 M 10 1011*4E $GPGGA 210054 6102.00388 N 107.62266 E 2 10 1 25.33 M 47.57 M 13 0777*76 $HEHDT 0.4 T*2B 0.67.

so I have to get the first 5 column values say and then perform calculation on 4th column - find sum and average, column wise.

Oh sorry, I'm really not getting the hang of sscanf functions :(
Yes if I give buffer values, the code works well..
In the same program, There is an error again:-
CString searchStr, lineval;
lineval = "21:00:55.035,$GPGGA,210055.00,6102.0039902,N,$GPGGA,210054,6102.00388,N";

searchStr.Format(_T("%%s,%%s,%%s,%%lf,%%c,%%s,%%s,%%s,%%lf,%%c"));
CString str1, str2, str3;
double doub1;
char chart1;
swscanf_s (line, searchStr, str1, 50, str2, 50, str3, 50, &doub1, chart1) ;
What is wrong here? It doesn't read the values first... Thanks for ur help

Thanks so much.. Have to get some tuitions from you ;)

Still have doubts on formatting a string.

char *tokenstring = "first 25.5,second 15";
result = sscanf(tokenstring, "%[^' '] %[^','],%[^' '] %s", string1, flt, string2, int1);

This is the right format for the given string, But don't understand why I must include the %[^' '] plus leave a space in between the next set of values in the string. And the last value in the string as %s! could you please give me few examples?

Thanks for the explanation, had many doubts regarding the sscanf, swscanf functions.

I know L is for LPCTSTR, unicode conversion. But the whole swscanf function is a bit of confusion for me.. Igoogled it, but did not find good examples that I can understand..

That doesn't help too...

Nope It still shows the error:
Here's my code:

int main( void )
{
int integ ;
CString st2,st1;
float doub;

CString s =L"first:25.5,second,15";

if ( swscanf_s(s, "%s %f %s %d", &st1, &doub, &st2, &integ )!= 4 )
{
cout<< "right";
}
else
cout <<"wrong";
}

Hi sorry, I really did not understand that code above, could you please explain?

Haha that's cool... will ignore :P

OOps! In my screen there is a number! something is wrong with my screen then!

;) Nope in the solution, there is a phone number printed..
Is that yours ?

Thanks I will try that!. Is that your phone number printed by mistake ?

Exactly, to not read the data from the file I have to set some kind of a condition and that can be either the discarding the column based on a format, but this row has 2 variables of the same format.

And I really don't understand what you mean by delaying ..

Yes I managed to open the source file, read the values and print them onto the destination file, with headings. But I have to discard the last set of values and again performing calculation on this is a little confusing..

Just managed to print heading in the file, I cannot use tokenise because of the format of the text in the file, as updated in my question. Cant point to a particular column in a row and delete all the values after that row.

And to output the file is it better to use .csv file as I have to save them in columns and its rely confusing!

I used this code to get the value from the 4th column, but I cannot make any calculations on these values. for example :
void main{
str(_T("%21:00:55 $GPGGA 210055 6102.00399 six"));
CAtlString resToken;
int curPos = 24;
double val;

resToken= str.Tokenize(_T(" "),curPos);
_tprintf_s(_T("Resulting token: %s\n"), resToken);

}

thsi prints the 4th column value but I have to do some calculation on that variable, For which I have to convert from string to double and back to string to print the values. Is this feasible?

:)

Thanks, But by using tokenise function I can use space as delimiter, but there is space after every column in the file and I have to extract a particular column say the 5th one, how can I do that?

In one of the code, in order to ignore the comment lines, I can type:
if (line.Find(_T("%")) == 0)
return;
//where the line is a CSring and "%" is used for comment lines in .csv files
But now since I have to find many spaces ie to calculate the 4th column I have to check 3 spaces in a row, so how can I do that?

But how can I separate the columns? There are no commas, or any other delimiters between each column..

NPD: Novell Printer Definition (NPD) files appear in the Printer Type list when you are creating a Printer Agent using the Novell Gateway's Print Device Subsystem (PDS).(Googled it : http://www.novell.com/fr-fr/documentation/nw51/docui/#../ndps_enu/data/hxiyy2w0.html)

Yes I'm working on windows and use visual C++. Yes I have to give a name to each column and display to the user,in a text format.

Oh well I get that now.
Thanks :)

So why combine int with long double?

Oops Sorry yes, I have missed the int variable. Have added that now.
But y not just write :

str1.Format(_T("%%02d°%%02d'%%1.%d\""), 5);

In the seconds part, why is lf required?

Okay.. guys. I was glad atleast I got my software display what it has to. I will definitely look into the formula and solve it the proper way, when I find more time. I had some deadline to fix this problem, which explains why I chose the short-cut method. I'm definitely not happy about what I hve done but relieved for now..

Oh thank you. So in my program the value nDst is set to -1 which mean the library code has to decide whether daylight saving is in effect or not. So which is that function? I've spent one full day on this n still no clue
:(

At last I found the function that displays the time: But I don't know how to change. The time on software is 1 hour slow.
void CPgInd::OnPoll(double time)
{
if (m_hWnd)
{
CTm80 tm;
tm = time;
CString str = tm.Format(_T("%a %d/%m/%Y %H:%M:%S"));

m_timeStr = str;
UpdCtrls();
}
}// the format displayed is Thu 03/05/2012 9:46:23

I didn't quite get that! U mean I must display the local time?

There are just 3 functions with SetWindowText and not time related!:(

Nope I want to know the function that displays the time, so that I can modify to the current GMT....

Yeah and so the formula cannot be viewed. :(
But Thanks for your time :)

Can U please try that with the link above? because I cannot view :(

But I cannot change because it is in compatibility mode. How do I change that?

Yeah I tried unprotecting the the sheet, but its just the values but not formula.
Thanks for updating.

Oh okay, cheers

But out of the 3 if statements, the 2nd and the third are same.... I don't get the point.

Thank u very much :)

Yeah the problem is with CEdit!! Will figure that out.

Thank u :)

And I'm not sure if I can post the actual code!! That would b wrong isn't it?

Well edit box must have a different format that takes atleast one letter.If I dont append any letter, I get an error(User defined), that says Incorrect format. The problem is I'm working on somebody else's code.

For now I have appended a letter for that to work.
Thank u

All I want to know is can I append a blank space using CString.append?

I have no problem appending character/letter but for one case I want to return the string as it is : The code:
if(condition)
switch (degree)
{
case one:
str.Append(_T("0"));
break;

case two:
str.Append(_T("00"));
break;
}
if (Fmt == Latitude)
(val >= 0) ? str.Append(_T("N")) : str.Append(_T("S"));

else if (m_dirFmt == Longitude)
(val >= 0) ? str.Append(_T("E")) : str.Append(_T("W"));

else if (m_dirFmt == Bearing)
//Here I want to append nothing as bearing is just a degree value

}
return str;

if (Fmt == Latitude)
(val >= 0) ? str.Append(_T("N")) : str.Append(_T("S"));

else if (m_dirFmt == Longitude)
(val >= 0) ? str.Append(_T("E")) : str.Append(_T("W"));

else if (m_dirFmt == Bearing)
//Here I want to append nothing as bearing is just a degree value

Exactly! I have no problems appending a character. But for one case I want to append nothing. ie:

if (Fmt == Latitude)
(val >= 0) ? str.Append(_T("N")) : str.Append(_T("S"));

else if (m_dirFmt == Longitude)
(val >= 0) ? str.Append(_T("E")) : str.Append(_T("W"));

else if (m_dirFmt == Bearing)
//Here I want to append nothing as bearing is just a degree value

Well It is a very complicated code. Before the above shown code : There is :

String1.Format(_T("%%02d°%%02d'%%1.5lf\""), 3);
str.Format( String1, deg, min, sec);

This string is displayed in an edit box in the software. If the format type = style1, Then append '>' or '<'. If the format type = style2, I don't want to append any letter.

cheers.. thank you

In order to calculate degrees in the format- 28°36'40.124"
And return this value in an edit box, what is the return type to use?

Yeah I know what you mean.
As of now I don't have any pressure from senior level to get the job done. But I'm given an opportunity to learn (On my own!).But there were instances where in I was expected to get a function running by the next day n I would just go blank!
As far as the job is concerned, I'm happy as I'm getting some commercial experience. I don't know what I like, Ie: web based or desktop based. I need to figure that out first.

Nice to hear this from someone as experienced as you. At the end of the day, I know its my decision. Its just that as a graduate when I was offered this position I was excited and never bothered about the platform.

Even now when I find some of my Java books I get all excited and happy to flip through the pages.

Or I guess its just that "The grass is greener on the other side until you get there". Hmmm... I don't know.

Thank you for your time :)

No the iterLimit is not changed anywhere else.
Thank you very much :)

Oh! okay. I got it!
Thank u :)

I have another question: Because it is a pre decrement
ie: --iterLimit, this stage is reached no matter what,do u have any idea about that?

Yeah there is a do while loop, where in the while loop I check the expression.
do
{

}

while (expression > 1e-12 && --iterLimit >0);
if (iterLimit==0) return NaN;

And iterLimit is int not Float.

* There is a decrement operator for the iterLimit prior to this in a while loop

Okay. Its a piece of code from the vincenty Inverse Solution. This is in Java script

var iterLimit = 100;

if (iterLimit==0) return NaN // formula failed to converge

@pwasser: Nope! I know it is a simple question.I have tried NULL, 0 But I guess it is always better to ask.

Null, nullptr or 0 returns "0". But I have to return NaN! Are they all the same? Just wondering when there is an expression to check Nan ie: _isnan there should be something to return the same.

Yeah I know what u mean. I mostly use debugger but my problem was to write this code itself.
Didn't know if it was e or 10.

Do u mean running the program in debugger using breakpoints?????

Well I don't open from 2 sources. If right click on the #include example.h from my .cpp file, It opens up from the path.

But These files are in one project and declared in a separate project and there are 30 plus projects, each of which are interlinked!

Well there is no option where I can delete the question.

Cheers :)

Hi! Chandrasekharan,
I guess because you edited my question I'm unable to click the "Solved it myself" button

Cheers n thanks for your time.

Ooops Sorry !!! I made a silly mistake of assigning the double values float!!!! Now the obtained values are perfect.

Well I'm working on previously written code!

Well I use variable1.GetValue() To get the values from the edit box.

The GetValue() function converts any value from the edit box to a double number.

Yes. Run my program in debugger.

Well thanks,
Had done major blunder by adding _ttoi instead of _ttof and yeah finally managed to get things in place.
cheers :)

Oh That looks a bit confusing. Will definitely go through the program again.

Because of incompatibility between char and wchar.

Yeah I tried converting it back but doesn't display at all.
My function:
int i;
char buffer[20];
CString str;

i= _ttoi(myVal->GetText()); //convert string to int
itoa (i,buffer, 10); //convert int back to string
str.AppendFormat(_T("Value is : %s\n"), buffer);

Hey Thanks. That works. But I have problems displaying the string using the string.append . But rather than just coying codes and juggling with errors, I will some some reading on strings first.

Oh well I tried the atoi. But it doesn't work .
int i;
i = atoi (myValue->GetText());

Here myValue is a variable and the GetText()function returns its value.

But the error says: No suitable conversion exists between CString to const char

I'm using Notepad++ . Well its a simple code but embedded within a complex c++ code. The code looks like:
if (SNum1) { obj.Item(_T("Selected_Numeber") , SNum1->GetName()); }

This function prints the selected item's name from the combo box. The Getname() function retrieves the name of the particular variable.

Well spotted! Sorry, didn't realise in a hurry. I'm glad it is solved now :)

Thanks, that link is quite helpul

Oh! yes I have accepted a solution. I hope that is enough.

Yeah But I ahve to sue double/float in my calculations.

Found the solution! :)

Hey Thanks Resmi! that works! need learn more about the ceilf function.

Hi Richard, the question is updated!