Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data
I need to setup a macro or something to import files and convert them. The
file starts out like this example: ACT:990 POINT FA(PNT_144) X=8.2207 Y=-0.9689 Z=0.2303 ACT:991 POINT FA(PNT_145) X=8.2207 Y=-0.9702 Z=1.3993 ACT:992 POINT FA(PNT_146) X=4.0937 Y=-0.9612 Z=1.3264 ACT:993 POINT FA(PNT_147) X=4.0940 Y=-0.9608 Z=0.2135 ACT:994 POINT FA(PNT_148) X=-0.5363 Y=-0.9822 Z=0.1765 ACT:995 POINT FA(PNT_149) X=-0.5363 Y=-0.9819 Z=1.4171 ACT:996 POINT FA(PNT_150) X=0.2498 Y=-0.1904 Z=1.4173 ACT:997 POINT FA(PNT_151) X=0.2498 Y=-0.1898 Z=0.1923 ACT:998 POINT FA(PNT_152) X=0.6993 Y=-0.2144 Z=0.1923 ACT:999 POINT FA(PNT_153) X=0.7003 Y=-0.2149 Z=1.3645 I need it to come in looking like this: 8.2207 -0.9689 0.2303 8.2207 -0.9702 1.3993 4.0937 -0.9612 1.3264 4.0940 -0.9608 0.2135 -0.5363 -0.9822 0.1765 -0.5363 -0.9819 1.4171 0.2498 -0.1904 1.4173 0.2498 -0.1898 0.1923 0.6993 -0.2144 0.1923 0.7003 -0.2149 1.3645 I would appreciate any help I can get. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data
You can get this using formulas. Assuming you have this information in Col A
and cell A1 contains ACT:990 POINT FA(PNT_144) X=8.2207 Y=-0.9689 Z=0.2303 try the below formulas in B1. C1 and D1 B1 =VALUE(MID($A$1,FIND("X=",$A$1)+2,10)) C1 =VALUE(MID($A$1,FIND("Y=",$A$1)+2,10)) D1 =VALUE(MID($A$1,FIND("Z=",$A$1)+2,10)) Copy the formulas down If this post helps click Yes --------------- Jacob Skaria "TimH" wrote: I need to setup a macro or something to import files and convert them. The file starts out like this example: ACT:990 POINT FA(PNT_144) X=8.2207 Y=-0.9689 Z=0.2303 ACT:991 POINT FA(PNT_145) X=8.2207 Y=-0.9702 Z=1.3993 ACT:992 POINT FA(PNT_146) X=4.0937 Y=-0.9612 Z=1.3264 ACT:993 POINT FA(PNT_147) X=4.0940 Y=-0.9608 Z=0.2135 ACT:994 POINT FA(PNT_148) X=-0.5363 Y=-0.9822 Z=0.1765 ACT:995 POINT FA(PNT_149) X=-0.5363 Y=-0.9819 Z=1.4171 ACT:996 POINT FA(PNT_150) X=0.2498 Y=-0.1904 Z=1.4173 ACT:997 POINT FA(PNT_151) X=0.2498 Y=-0.1898 Z=0.1923 ACT:998 POINT FA(PNT_152) X=0.6993 Y=-0.2144 Z=0.1923 ACT:999 POINT FA(PNT_153) X=0.7003 Y=-0.2149 Z=1.3645 I need it to come in looking like this: 8.2207 -0.9689 0.2303 8.2207 -0.9702 1.3993 4.0937 -0.9612 1.3264 4.0940 -0.9608 0.2135 -0.5363 -0.9822 0.1765 -0.5363 -0.9819 1.4171 0.2498 -0.1904 1.4173 0.2498 -0.1898 0.1923 0.6993 -0.2144 0.1923 0.7003 -0.2149 1.3645 I would appreciate any help I can get. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Cloumn data when importing external data | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |