Hi Everyone,
I would like to ask for you help how I can transform this unformatted text from the PDF file into a 6 columns format below. Thanks in advance!
Solved! Go to Solution.
Hi @caltang ,
I really appreciate your help, can I ask for your expertise again?
I have another data that is the same with the previous one, the idea is just the same, I want to separate it by columns.
Thanks so much!
Can you check your bank ref again?
Bank reference | Customer reference |
SWIFT STMT SER C | |
230914209434168 | GHK500643580 |
HK115093HB198657 | P8089726 |
HK115093HB198657 | P8089726 |
HK115093HB265585 | P8089723 |
HK115093HB265585 | P8089723 |
HK115093HB265586 | P8089724 |
HK115093HB265586 | P8089724 |
Not sure how the SWIFT thing is there... Can you clarify or give more data like that?
Happy to help, but need more info pls. You can msg me for more details if not comfortable to share here. Thanks!
Hi @caltang ,
this is what the pdf statement looks like. Every month the Bank Reference of the swift transactions is blank and it is appearing in no particular date. sometimes it will appear on the middle of the month sometimes at the end month. Thanks
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |