AnsweredAssumed Answered

Purse/import data from Txt  response

Question asked by MAKALENG on Oct 9, 2017
Latest reply on Oct 10, 2017 by MAKALENG

hi all

I receive a file response on data format txt and need to  input it to my data

e.g

H|01|firstname|secondname|telnumber|mobile|fax|email|

A|adress1|adress2|adress3|adress4|

P|amount|Total

 

what this basically means is that

H is meant to go to field name Header1and the pipe "|" is field separator so between every pipe is a field

so is the fields with first letter A...e.i A|adress1|adress2|adress3|adress4|

etc

what calculation should i use till i get to set field especially since they come on different lines with anchor for each line being the first letter

`Thanks in advance

Outcomes