I've got a source file that is fixed length and uses specific beginning characters to start each row. It looks roughly like this:
01PatientInfo
02GuarantorInfo
03Insurance1Info
04Insurance2Info
05Insurance3Info
11ChargeInfo
The catch is that if there is no secondary or tertiary info I don't get a 04 (or a 05) line. Rather, it looks like this:
01PatientInfo
02GuarantorInfo
03Insurance1Info
11ChargeInfo
I can access the secondary info using typical index-based nodepath syntax such as "3,10[4]", which references the fourth line of data from the 3rd character for a length of 10, but if there isn't a secondary insurance present that ends up giving me data from the "11" row. Is there a way to do something like "3,10[@0,2=04]" (similar to how nodepath filtering works for HL7 data) to specifically get the characters from the row where the value at 0,2 is "04"? I've tried using the nodepath like what is listed here, but that doesn't seem to work