Calculate the Difference of Two White-space-separated Strings
Problem description & analysis
We have an Excel file Book1.xlsx:
A |
B |
|
1 |
A3 B27 A23 DQ8 |
A3 A23 DR16 |
We are trying to calculate the difference between A1 and B1 in C1. The desired result is as follows:
A |
B |
C |
|
1 |
A3 B27 A23 DQ8 |
A3 A23 DR16 |
B27 DQ8 |
Solution & explanation
Load add-in ExcelRaq.xll in Excel, and
Select cell C1 and enter the following formula in it to =esproc("=(?1.split("""")\?2.split("""")).concat("""")",A1,B1) to get the result.
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL