C / C++ / MFC

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

3-Oct-19 1:52

_Flaviu wrote:
And how is look if you let tabs space as it is ?

Not nice at all, some of the text in my cells is 4 characters long and others are 30 characters long.

_Flaviu wrote:
Tab is preffered instead of using spaces ... I mean, instead of using ' ', use '\t'.

The Internet is already full of discussions about why you should use tabs instead of spaces, please stay on topic and don't let this thread derail into yet another discussion about it.

Richard MacCutchan3-Oct-19 2:16

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

3-Oct-19 2:16

It is no good replacing tabs with some number of spaces. Tabs are markers which indicate that the next item should be placed on a tab boundary. Boundaries are on the next column which is a multiple of the tab width (usually 4 or 8). So a tab may represent any number of spaces from 1 up to the tab width.

Are you pasting this as comments in your C file or as data to be displayed? If the latter then the tab characters should work.

phil.o3-Oct-19 2:29

phil.o

3-Oct-19 2:29

Not necessarily if the widths accross a single column vary by more than a single tabulation's size.

"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

Richard MacCutchan3-Oct-19 2:37

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

3-Oct-19 2:37

Sorry, not sure I understand.

phil.o3-Oct-19 2:46

phil.o

3-Oct-19 2:46

Imagine the following case:

V1  V2  V3
longv1  longv2  longv3

It seems that OP's values (in a single column) have disparate widths.
The same kind of "issue" which leads to code-blocks like

int          value      = 0;
char*        name       = "dummy";
vector<char> characters = /* ... */;

"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

Richard MacCutchan3-Oct-19 2:53

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

3-Oct-19 2:53

phil.o3-Oct-19 2:27

phil.o

3-Oct-19 2:27

Since the process involves the use of the clipboard, there are a couple of solutions which come to my mind:

You could create a VBA macro in Excel which would format the contents:
- You would need some PADLEFT or PADRIGHT kind of function:
  
  vba
```
Function PadLeft(text As Variant, totalLength As Integer, padCharacter As String) As String
    PadLeft = String(totalLength - Len(CStr(text)), padCharacter) & CStr(text)
End Function

Function PadRight(text As Variant, totalLength As Integer, padCharacter As String) As String
    PadRight = CStr(text) & String(totalLength - Len(CStr(text)), padCharacter)
End Function
```
  (source: SO: Any method equivalent to PadLeft/PadRight?[^]
- Then use one of these functions to pad the values to the width of the largest value and place the result in the clipboard.
- Have a button in Excel which launches the macro (whose result will be formatted text exported to the clipboard).
Or find an utility which can automatically format the content of the clipboard according to a specified format string. Honestly, I have never searched for such a tool, I don't even know if that exists.

"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

leon de boer3-Oct-19 6:38

leon de boer

3-Oct-19 6:38

It is impossible only excel knows how wide the original columns were, that is why it puts the delimiters in the text to mark the columns Smile | :)

So if you want the original column width in excel you need to get excel to put them in a cell so it gets exported with the data and you can then use it to reformat the layout.

I know for say cell A1 width the excel formula is =CELL("width", A1) which displays as a decimal number.
What exactly that number is I have no idea but you can try searching for it or just play with a few letters and font heights and you should be able to work it out.

In vino veritas

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

arnold_w3-Oct-19 6:41

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

3-Oct-19 6:41

I don't mean the width in pixels or whatever unit Excel is using, I mean width in number of characters.

leon de boer4-Oct-19 3:52

leon de boer

4-Oct-19 3:52

I know but you aren't really looking at problem. The fonts in the cells are true type proportional not old school fixed pixel fonts so unless you have display formats on them you are dead out luck they wont be fixed character widths.

So the best you can probably do is the pixel width and then divid it by some number so if the font sort of averages 10 pixels width the 100 pixel column = 100/10 = 10 characters and 150 pixel width column gives you 15 characters.

You aren't going to be able to do much better than that at at least it will be somewhat columnized

In vino veritas

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

arnold_w4-Oct-19 5:44

Re: Tool to replace tabs with VARIABLE NUMBER OF SPACES and preserve column alignment?

4-Oct-19 5:44

I found a perfect tool, please see my reply below.

arnold_w3-Oct-19 7:37

3-Oct-19 7:37

I have found exactly what I was looking for. I if go to the website ASCII Table Generator – Quickly format ASCII table. Great for source code comments and markdown![^] and choose "Header Location:" "None" and "Output Style:" "ASCII (Compact)" then I get exactly the formatting I want. Thanks everyone who contributed in this thread.

Error C2059 C2143

_Flaviu2-Oct-19 7:59

_Flaviu

2-Oct-19 7:59

In struggling to convert a piece of Linux code to Windows, I cannot rid of this errors:

C++

typedef enum {
	NULL_RID = 0,		// <-- error C2059: syntax error : '('
	WORLD_RID = 0,
	LOCAL_RID = 0,

	OWNER_RID = 0,
	GROUP_RID = 1,
....
....
	 PREACCESS = 0x22a,
} SOME_IDE;			// <-- error C2143: syntax error : missing ';' before '}'

seem to be something simple, but what ? Can you give me a little help ?

Re: Error C2059 C2143

David Crow2-Oct-19 9:22

David Crow

2-Oct-19 9:22

It looks to be syntactically correct. Maybe how it's used is incorrect, or some piece of code preceding it is incorrect.

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

Re: Error C2059 C2143

CPallini2-Oct-19 9:52

CPallini

2-Oct-19 9:52

Probably there is a #define like, for instance

#define NULL_RID 0

In the included files (use Visual Studio 'search in files' editor command to find it).
See example 2 in the following page Compiler Error C2059 | Microsoft Docs[^].

Re: Error C2059 C2143

Richard MacCutchan2-Oct-19 21:45

Displays the image in Picture Control.

2-Oct-19 21:45

There is most likely something missing or incorrect, earlier in the code that you have not shown.

Member 126614642-Oct-19 7:07

2-Oct-19 7:07

I just started to study this theme, so strongly do not swear.
Tell me why this code works.

HBITMAP startBitmap = (HBITMAP)LoadImage(NULL, "D:\\159.bmp", IMAGE_BITMAP, 0, 0, LR_LOADFROMFILE);
m_PictureControl.SetBitmap(startBitmap);

And this does not work.

HANDLE FileR = CreateFile("D:\\159.bmp", GENERIC_READ, FILE_SHARE_READ, NULL, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, NULL); 
	DWORD size_file = GetFileSize(FileR, 0);
	HBITMAP startBitmap = (HBITMAP)malloc(size_file);
	DWORD dwReadW;
	ReadFile(FileR, startBitmap, size_file, &dwReadW, NULL);
	m_PictureControl.SetBitmap(startBitmap);

As I assume the buffer is necessary as it is to prepare before an image displayed on the screen. But unfortunately I do not understand how to do it.

modified 2-Oct-19 14:04pm.

Gerry Schmitz2-Oct-19 7:19

Gerry Schmitz

2-Oct-19 7:19

The first reads an existing file; the second creates an "empty" file and expects magic.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Member 126614642-Oct-19 7:41

2-Oct-19 7:41

Gerry Schmitz wrote:
an "empty" file

If you not it is difficult explain please my mistake.
I'm not creating a file I'm reading it to the buffer. The data from the buffer in order.

modified 2-Oct-19 14:03pm.

David Crow2-Oct-19 9:19

David Crow

2-Oct-19 9:19

Member 12661464 wrote:

And this does not work.

Which means what exactly?

Have you stepped through the code to make sure that CreateFile(), GetFileSize(), ReadFile(), and SetBitmap() all return "success" values?

Victor Nijegorodov2-Oct-19 9:41

Victor Nijegorodov

2-Oct-19 9:41

The first reads file and "convert" the read data to be interpreted as a HBITMAP.
The second just reads some binary data that cannot be interpreted as a HBITMAP. Suspicious | :suss:

Member 126614642-Oct-19 10:37

2-Oct-19 10:37

Victor Nijegorodov wrote:
cannot be interpreted as a HBITMAP

I understand this, but I can't understand how do I convert this data to an image, how do I process the buffer?

Victor Nijegorodov2-Oct-19 10:49

Victor Nijegorodov

2-Oct-19 10:49

Well, what is your goal? Are you trying to reinvent the wheel? Or what? Confused | :confused:

Member 126614642-Oct-19 11:04

2-Oct-19 11:04

I want to understand what the LoadImage function does with a file, cuts off the header ? How does it convert data?
I find the image in the resources of the file, it does not lie in the open as a picture. I read in buffer specifically the place where image of the is.

modified 2-Oct-19 17:10pm.