Topic: CREATING KEYSTROKE MACROS (1 of 5), Read 15 times
Conf: WebBoard - How to use it
From: Oligario Lazarre
Date: Wednesday, May 04, 2011 01:06 PM

Hello,

I am currently evaluating the VEDIT software and need to create KEYSTROKE MACROS and currently experiencing difficulties.
Currently, I have data in MICROSOFT EXCEL in four ( 4 ) columns. Each cell ends with the ASCII Control Character 29, Group Separator.
When I attempt to run the macro, the following message is displayed: "CANNOT FIND |013".

Refer to the attached files.

Assumptions:

There are four ( 4 ) distinct columnar blocks.
Each data item in a block ends with ASCII Control Character 29, Group Separator.
Each data item must be separated by the ASCII Control Character 29, Group Separator.

Once the columnar data from MICROSOFT EXCEL is copied to a VEDIT BUFFER, I need a macro to perform the following actions:

1. Mark the beginning of a columnar block of text.
2. Mark the end of a columnar block of text.
3. Copy the first ( 1st ) columnar block into a register.
4. Search and replace or remove ASCII control character 013 ( Carriage Return ) and 010 ( Line Feed ) with nothing. The goal is to convert the columnar data and have all data items on one line separated by the ASCII Control Character 29, Group Separator.
5. Save the file in a specified directory as text file.
6. Repeat steps 1 through 5 for the second ( 2nd ) columnar block.
7. Repeat steps 1 through 5 for the third ( 3rd ) columnar block.
8. Repeat steps 1 through 5 for the fourth ( 4th ) columnar block.



1 1 C8 1. Interpret drawing per ASME Y14.100.
2 1 C8 2. MATERIAL: 17-4 CRES per AMS 5643, Condition H1025 per AMS-H-6875.
3 1 C8 3. Machined surfaces shall be 125 micro inches MAXIMUM.
4 1 C8 4. Break sharp edges and remove burrs.
5 1 C8 5. Identify with 3U331-6435529 and manufacturer's name or cage code per MIL-STD-130.
6 1 C8 DO NOT MARK PART.
7 1 C8 6. Passivate per AMS 2700 Type 8.
8 1 C8 7. Fillet radii shall be 0.010 MAXIMUM.
9 1 D5 0.156 FLATS + / - 0.010
10 1 C5 0.086-56 UNC-3A
11 1 C5 0.63 + / - 0.03
12 1 C5 0.22 + / - 0.03
13 1 C5 0.068, 0.065 + / - 0.010
14 1 B5 0.20 + / - 0.03
15 1 B4 0.030, 0.020 + / - 0.010
16 1 B5 Radial Dimension: 0.200
17 1 B5 0.112-40 UNC-3A
17 1 B5 0.112-40 UNC-3A
17 1 B5 0.112-40 UNC-3A
17 1 B5 0.112-40 UNC-3A

 

Topic: CREATING KEYSTROKE MACROS (2 of 5), Read 18 times
Conf: WebBoard - How to use it
From: Christian Ziemski
Date: Wednesday, May 04, 2011 04:21 PM

On 5/4/2011 1:06:02 PM, Oligario Lazarre wrote:
>
>I am currently evaluating the VEDIT software

Welcome to this forum!

>and need to create KEYSTROKE MACROS and currently
>experiencing difficulties.
>Currently, I have data in MICROSOFT EXCEL in four ( 4 )
>columns. Each cell ends with the ASCII Control Character
>29, Group Separator.
>When I attempt to run the macro, the following message
>is displayed: "CANNOT FIND |013".
>
>Refer to the attached files.

There seem to be no file attached.
Please let us have a look at your already done macro.


>Assumptions:
>
>There are four ( 4 ) distinct columnar blocks.
>Each data item in a block ends with ASCII Control Character
>29, Group Separator.
>Each data item must be separated by the ASCII Control
>Character 29, Group Separator.


Questions:

1.) Do you really need to mark columnar blocks manually?

Or are the data items already separated by |029 after being copied to / opened in Vedit?

2.) The following is the source format (@ representing |029)

8@1@C8@7. Fillet radii shall be 0.010 MAXIMUM.
9@1@D5@0.156 FLATS + / - 0.010
...

and this should be the target format:

8@9@...

1@1@...

C8@D5@...

7. Fillet radii shall be 0.010 MAXIMUM.@0.156 FLATS ...@...


That means: rows should become columns and vice versa?


Christian

PS:

This discussion is taking place in the wrong group yet: "WebBoard - How to use it".

I would like to move it to
"VEDIT Technical support - Keyboard, keystroke macros"
or perhaps to
"VEDIT Macro language support"

I'll do that after your next reply here - hopefully not puzzling you that way. ;-)

 

Topic: CREATING KEYSTROKE MACROS (3 of 5), Read 21 times
Conf: WebBoard - How to use it
From: Peter Rejto
Date: Wednesday, May 04, 2011 10:54 PM

On 5/4/2011 4:21:29 PM, Christian Ziemski wrote:
>On 5/4/2011 1:06:02 PM, Oligario Lazarre
>wrote:
>>

>>Currently, I have data in MICROSOFT EXCEL in four ( 4 )
>>columns.

>7. Fillet radii shall be 0.010
>MAXIMUM.@0.156 FLATS ...@...
>
>
>That means: rows should become columns
>and vice versa?
>
>
>Christian



Thanks Christian,

I am also a MICROSOFT EXCEL user.

I also would like to perform the magic of converting rows into columns. Could you please give me a more detailed set of instructions ?

Actually, I have done this some time ago, using the
MICROSOFT EXCEL "Transpose" command. I have a hunch that
your previous instructions do this from scratch. In other words, it would help me to understand what is behind the "Transpose" command.

To be sure, I do not understand your previous instructions.
May be my hunch is completely off ?


Since Vedit is not a spreadsheet, I take that this can not be done it in Vedit. On the other hand, just because I can not do it, does not mean that it can not be done.

-peter

 

Topic: Re: CREATING KEYSTROKE MACROS (4 of 5), Read 21 times
Conf: WebBoard - How to use it
From: Christian Ziemski
Date: Thursday, May 05, 2011 05:07 PM

On 05.05.2011 04:54 in vedit-webboard-howto Peter Rejto wrote:
>
> I also would like to perform the magic of converting
> rows into columns. Could you please give me a more
> detailed set of instructions ?
>
> Actually, I have done this some time ago, using the
> MICROSOFT EXCEL "Transpose" command. I have a hunch that
> your previous instructions do this from scratch.
>
> To be sure, I do not understand your previous instructions.

I didn't give any real instructions yet.
I simply tried to describe what I think Oligario Lazarre
may have meant in his message...

> Since Vedit is not a spreadsheet, I take that this can
> not be done it in Vedit.

That's why I asked Oligario about the delimiter character
|029 and the (possible) need of visually selecting columns.

As long as VEDIT is able to know about the column structure
of the given data it is possible to do almost anything with it.

Transposing columns to rows is only one possible action
(and should be easy to implement).


Christian

 

Topic: CREATING KEYSTROKE MACROS (5 of 5), Read 11 times
Conf: WebBoard - How to use it
From: Christian Ziemski
Date: Friday, May 13, 2011 03:58 AM

On 5/4/2011 10:54:09 PM, peter rejto wrote:
>
>I am also a MICROSOFT EXCEL user.
>
>I also would like to perform the magic
>of converting rows into columns. Could
>you please give me a more detailed set
>of instructions ?

Peter:

Please have a look at my recent message in "VEDIT macro library"

Christian