Hello Excel Gurus,
I’d like to simplify a process at work. Here’s an example of my raw data:
AMSNDAT/N/0346/-/--/REC/-/-/DEPLOC:KDYS/010800ZJAN/ARRLOC:KDYS/011200ZJAN//MSNACFT/1/ACTYP:A1C/AEGIS10/-/-/AB45/-/-/-/-/B:11223//AMSNLOC/010830ZJAN/010845ZJAN/12JAP/100//
If someone could help out with the code for numbers 1-3, I can apply your example to the rest of my problem sets.
Here’s what I’d like to do with it:
I’d like to simplify a process at work. Here’s an example of my raw data:
AMSNDAT/N/0346/-/--/REC/-/-/DEPLOC:KDYS/010800ZJAN/ARRLOC:KDYS/011200ZJAN//MSNACFT/1/ACTYP:A1C/AEGIS10/-/-/AB45/-/-/-/-/B:11223//AMSNLOC/010830ZJAN/010845ZJAN/12JAP/100//
If someone could help out with the code for numbers 1-3, I can apply your example to the rest of my problem sets.
Here’s what I’d like to do with it:
- Find the “ACTYP” and assign it to a variable (the characters between “ACTYP:” and “/AEGIS10”; will be a variable number of characters).
- Find the “start date” and assign it to a variable. The start date in the data above is after “AMSNLOC/”. The data 010830ZJAN means 01 JAN at 0830 so the date here is 01 JAN.
- Find the “start time” and assign it to a variable. The start time in the data above is 0830 as mentioned in #2.
- Find “end date” and assign it to a variable. The end date in the data above is in the string “010845ZJAN” (immediately after the data from #2 and #3 above). It won’t always be the same date. In this example the date is still 01 JAN.
- Find the “end time” and assign it to a variable. The end time in #4’s example is 0845.
- Find the “tag” and assign it to a variable. The tag in the data above immediately follows the “end date/time” data; 12JAP.
Thanks in advance, I appreciate your time. Jeff