Very specific question to translate form1 to form2

[directx]

Hello everyone,

Maybe you are familiar with word Gerber, maybe you are not. It's a file that contains X/Y coordinates, it's most commonly used in different types of Industries, mainly PCB manufacturing and PCB assembly.

I need excel to translate form1 to form2

Form1

Examples:

%FSLAX24Y24*% this means: FOrmat Statement Leading Zeros Suppression, Absolute Coordinates format=2.4.

The syntax is defined in the following image:

• L = leading zeros omitted
• T = trailing zeros omitted
• D = explicit decimal point ( meaning that no zeros are omitted)
• A = absolute coordinate mode
• I = incremental coordinate mode
• Nn = sequence number, where n is number of digits ( rarely used)
• Gn = preparatory function code ( rarely used)
• Xa = format of input data ( 5.5 is max)
• Yb = format of input data
• Zb = format of input data ( Z is rarely, if ever seen)
• Dn = draft code
• Mn = misc code

[FONT=&quot]
[h=2]Example of embedded aperture list:[/h]%ADD10C,0.0060*%
%ADD11C,0.0050*%
%ADD12R,1.0375X0.1125*%
%ADD13C,0.0040*%
%ADD14C,0.0010*%
The synax is:
%ADD{code}C,{$1}X{$2}X{$3}*%
where:
AD – aperture description parameter
D{code} d-code to which this aperture is assigned (10-999)
C tells 274X this is a circle macro
R tells 274X this is a rectangle macro
$1 value (inches or mm) of the outside diameter
$2 optional, if present defines the diameter of the hole
$3 optional, if present the $2 and $3 represent the size of
a rectangular hole.
[/FONT]
Form2

After excel get's this type of material I need it to "translate" it to the following format

 Circuit : "Board" "Name" : "Board" "Offset Of" : "Board" "X" : "0.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "170.2000" "X" : "0.0000" "Y" : "170.2000" [/COLOR]
[COLOR=#000000]   Circuit : "Circuit 1" "Name" : "Circuit 1" "Offset Of" : "Circuit 1" "X" : "0.0000" "Y" : "10.0000" "X" : "46.0000" "Y" : "10.0000" "X" : "46.0000" "Y" : "160.0000" "X" : "0.0000" "Y" : "160.0000" [/COLOR]
[COLOR=#000000]

Where:

These 2 points together create a line This point extands the line for value of
| 1st Point || 2nd Point || 3rd Point || 4th Point |
Circuit : "Board" "Name" : "Board" "Offset Of" : "Board" "X" : "0.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "170.2000" "X" : "0.0000" "Y" : "170.2000"

For example, these 4 points combined creates square, and thats the point :D

I'm here to answer any of your questions.

Best Regards

 

[directx]

*****************************************************These 2 points together create a line **********This point extands the line for value of
*********************************************| ********1st Point ******||********* 2nd Point******** ||******* **3rd Point******** ||********* 4th Point******** |
Circuit : "Board" "Name" : "Board" "Offset Of" : "Board" "X" : "0.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "0.0000" "X" : "288.0000" "Y" : "170.2000" "X" : "0.0000" "Y" : "170.2000"