How to extract text from blocks defined by “$begin” and “$end” ?

[katto01]

Hello

I have this ASCII file that I need to extract and organize data from it. I need to locate the text between "$begin" and "$end", split it and lay it out in a table

$begin pec
simple('conductivity', 1.0E30)
ModTime=1028307964
$end pec
.
.
.
$begin nickel
simple('conductivity', 14500000)
simple('permeability', 600)
simple('thermal_conductivity',90)
simple('mass_density',8900)
simple('specific_heat',444)
simple('youngs_modulus',210000000000)
simple('poissons_ratio',0.35)
simple('thermal_expansion_coeffcient',1.3e-005)
ModTime=1132068240
$end nickel

I would like to create a table that looks like
name conductivity permeability thermal_conductivity
pec 1.00E+30 … ….
nickel 14500000 600 90

any suggestions?

Thanks

[dflak]

Can you provide us with a sample file with enough non-sensitive data to prove the concept (I'd suggest about 4-5 metals' worth).

[katto01]

here are the first 42 line of 2340. Is there a way to upload a file?

$begin '$base_index$'
$begin 'properties'
all_levels=000000000000
time(year=000000002016, month=000000000002, day=000000000024, hour=000000000015, min=000000000053, sec=000000000014)
version=000000000000
$end 'properties'
$begin '$base_index$'
$index$(pos=000000065904, lin=000000002618, lvl=000000000000)
$end '$base_index$'
$end '$base_index$'
$begin vacuum
('permittivity', 1)
ModTime=1028307964
$end vacuum
$begin pec
('conductivity', 1.0E30)
ModTime=1028307964
$end pec
$begin 'perfect conductor'
('conductivity', 1.0E30)
ModTime=1028307964
$end 'perfect conductor'
$begin steel_stainless
('conductivity', 1100000)
('thermal_conductivity',13.8)
('mass_density',8055)
('specific_heat',480)
('youngs_modulus',195000000000)
('poissons_ratio',0.3)
('thermal_expansion_coeffcient',1.08e-005)
ModTime=1132068240
$end steel_stainless
$begin zinc
('conductivity', 16700000)
('thermal_conductivity',115.5)
('mass_density',7140)
('specific_heat',389)
('youngs_modulus',115000000000)
('poissons_ratio',0.33)
('thermal_expansion_coeffcient',6.35e-005)
ModTime=1132068240
$end zinc

[dflak]

To upload a file click on the Go Advanced button and scroll down to manage attachments. Click on that link and your will get a dialog box to select the file and upload it.

[katto01]

please see attached the full file

[dflak]

Here is a list of the things I think you want parsed out. Please review and correct. Thanks.

element
conductivity
mass_density
permittivity
poissons_ratio
specific_heat
thermal_conductivity
thermal_expansion_coeffcient
youngs_modulus
ModTime

[katto01]

yes, this is correct

[jindon]

This is how I read your problem.

Please Login or Register  to view this content.

[katto01]

Thanks, that would do it. Do you have any reference for the codes used in the line that includes the ".Pattern=..."?

[dflak]

This may be more difficult than originally envisioned. It seems there are "nested" begin-end combinations leading to consecutive cells with $begin and $end.

[jindon]

Google with the key words like

VBA Regular Expression meta character etc.

And try this one for the shortest block.

Please Login or Register  to view this content.