Skip to Content
0
Former Member
Jan 19, 2017 at 11:18 AM

EBS search string to dynamically get statement text

786 Views Last edit Jan 19, 2017 at 05:02 PM 2 rev

Hi,


I'm trying to use search string for a certain MT940 bank transaction code whereby to bring as much as possible from the text in node :86: that follows a fixed 3 digits text in sub-node ?21. I will then map the output value to line item text. I know how to do the search string usage config. I've actually built 2 search strings already of identical length. One is w/ blank mapping one with actual mapping. They look something like this: 1) Search sting w/ blank mapping: Source: ?TXT?????????????????????????? Target: is blank; 2) Search string w/ mapping: Source: ?TXT?????????????????????????? Target: ??????????????????????????
It works for 3/4 of the transactions but for the rest my line item text (BSEG-SGTXT or FEBEP-FVAL1) is blank. I noticed if I make the length of the strings shorter / longer it will work for some of the 1/4 transactions but in exchange fail for some other that previously worked. It's probably some fine-tuning required in the search sting definition but I can't figure out what.
I don't want to write any code but keep doing it via search strings. Is it possible ?