Hi everyone,
Good day to all of you, i have a requirement to split string in line86, my current formula is taking in information from line61 as there is only 1 subtag in some lines in the file example:
:86:X02?20ABCD
:61:2345436436754,00CE02//CHQ
Result:
ABCD :61:2345436436754,00CE02//CHQ | | |
There will be some line with 4 Subtags with result below with my formula:
:86:R08?20CHH?21From: PETER & CO PTE LTD?22PayNow?23OTHER COMPANY NAME
:62F:242341234124,24 :64:2341412412423-}
Result:
CHH | From: PETER & CO PTE LTD | PayNow | OTHER COMPANY NAME :62F:242341234124,24 :64:2341412412423-}
How can I fix to accommodate for any number of subtags in line86 without taking information from other lines. Thank you so much
My formula


Report
All responses (
Answers (