I have a complex text file import issue.
The first 13 lines of the file need to be skipped.
Then each of the next 2 lines need to be combined in one record.
the format of one record should look something like this ..
index number / date / time / error code / error description
Help would be greatly appreciated.
g's Sam
Expand|Select|Wrap|Line Numbers
- ****************************************
- * *
- * C O M A U : Robotics *
- * *
- d* C 3 G : 3^ Generation Control *
- * *
- * ERROR LOG FILE *
- * *
- ****************************************
- * ERROR FORMAT RELEASE : 1.0 *
- * MAX REMEMBERED ERRORS : 20 *
- * LATEST ERROR IN POSITION : 5 *
- * ERROR LINE LENGTH : 80 *
- ****************************************
- <001> 08-11-12 09:15:15
- 30777-10 : DP SL slave not ready
- <002> 08-11-12 09:26:00
- 43276-04 : A_SW1B: $DIN[2]=OFF, micro not indicates "gun open"
- <003> 08-11-12 09:27:42
- 36912-04 : rsssssrr(34): unmatching FOR loop
- <004> 08-11-12 09:55:29
- 62479-08 : SA: 1 1 wrist axis at undefined position
- <005> 08-11-12 10:09:29
- 62482-10 : SAX: 1 1 1 tolerance HOLD unobtainable
- <006> 08-11-12 06:17:39
- 28774-10 : Power failure detected
- <007> 08-11-12 06:17:40
- 43274-04 : A_SW1B: MP 1 $DIN[35]=OFF, no air
- <008> 08-11-12 06:17:49
- 30777-10 : DP SL slave not ready
- <009> 08-11-12 06:19:47
- 43260-10 : Welding control switch 1 failure
- <010> 08-11-12 06:25:07
- 43522-04 : HTChg: Tool on flange INP fault $DIN[ 16] = ON
- <011> 08-11-12 06:25:16
- 43522-04 : HTChg: Tool on flange INP fault $DIN[ 16] = ON
- <012> 08-11-12 06:25:27
- 43522-04 : HTChg: Tool on flange INP fault $DIN[ 16] = ON
- <013> 08-11-12 06:27:13
- 30777-10 : DP SL slave not ready
- <014> 08-11-12 06:38:32
- 61442-11 : SAX: 1 1 2 following error out of range
- <015> 08-11-12 06:41:21
- 43274-04 : A_SW1B: MP 1 $DIN[35]=OFF, no air
- <016> 08-11-12 06:41:21
- 43292-04 : A_SW1B: [02] Switch 1 $GIN[14] = 0. Welding control switch not open
- <017> 08-11-12 06:46:26
- 28774-10 : Power failure detected
- <018> 08-11-12 06:46:26
- 26636-10 : BS: (0,5) I/O module failed
- <019> 08-11-12 06:46:36
- 30777-10 : DP SL slave not ready
- <020> 08-11-12 06:46:55
- 43260-10 : Welding control switch 1 failure