on 09-28-2020 3:27 AM
Hi Experts,
I am doing Bank Statement Processing on file format MT940.
I am encountering decimal places issues with "," (Comma)
Below is tag 60 info in my data file:
:60F:C200906SGD29834,78
and the Regular Expression that I am using.
(?<=:60(F|M):C\d{6}.?[a-zA-Z]{3,3}).(\d+(,\d*)?)|(,\d+)
The amount 29834,78 can be captured during Data Preview. (Refer to the screenshot below)
However, when I was doing the file import in SAPB1, it returned me the error message as below:
"Unexpected character, found in position 5 in field StartingBalanceL in table BankStatement; data corruption possible."
I am able to import when changing the "," (Comma) to "." (Dot) in the data file with the regular expression below:
(?<=:60(F|M):C\d{6}.?[a-zA-Z]{3,3}).(\d+(\.\d*)?)|(\.\d+)
But not sure why it can't work with "," (Comma) data file with "," (Comma) Regular Expression:
(?<=:60(F|M):C\d{6}.?[a-zA-Z]{3,3}).(\d+(,\d*)?)|(,\d+)
I am following the guide below:
Thanks.
Danny Ding
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.