Hello,
I'm trying to streamline by bank import process. My bank's CSV (Barclays) gives me one description field that concatenates a few fields together with multiple blank spaces, For example, the value in the CSV might be "B SMITH EXPENSES FT" which I want to split into 2 fields ("B SMITH" and "EXPENSES")
I've tried using the Substring Transformation Type with the following variables:
Start Position: 1
Ending Text: " " but without the inverted commas..i.e. just two spaces
Nothing in Starting Text or Length
Next Transformation Rule: Trim (have tried without this and it still doesn't work)
When I run the Test on the above sample text, it works perfectly. However, when I run the Bank Statement Import, the mapped fields are always blank. I've tried using different triggers rather than the two blanks (i.e. in this example, change the Ending Text to "EXP") and that works perfectly. So it's something to do with the double spaces
Any ideas how to get around this?
Thanks in advance
