Custome Column With Partial File Name via Script
Posted: 21 Apr 2021 14:46
Hello,
I need to generate partial file name(Meter No) from full file name.
I able to do this in Ms Office Excel, need to do the same in xyplorer via script.
Example Scenario:
D_3304711_08042021153020.XML to 3304711
03_2017341_19042021_095157.XML to 2017341
30055094_20122019235900.xml to 30055094
0001_1210344_20210419_125458_187.xml to 1210344
2358530_210421_111135.XML to 2358530
Excel Formula:
=IF((LEN(A2)-LEN(SUBSTITUTE(A2,"D_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"03_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"0001_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"_",""))),TRIM(LEFT(A2,SEARCH("_",A2)-1)),TRIM(LEFT(A2,SEARCH("2021",A2)-1))))))
Filename Example Download Link:
https://we.tl/t-B6x3RncMYH
Thanks In Advance!
I need to generate partial file name(Meter No) from full file name.
I able to do this in Ms Office Excel, need to do the same in xyplorer via script.
Example Scenario:
D_3304711_08042021153020.XML to 3304711
03_2017341_19042021_095157.XML to 2017341
30055094_20122019235900.xml to 30055094
0001_1210344_20210419_125458_187.xml to 1210344
2358530_210421_111135.XML to 2358530
Excel Formula:
=IF((LEN(A2)-LEN(SUBSTITUTE(A2,"D_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"03_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"0001_",""))),SUBSTITUTE(MID(SUBSTITUTE("_"&A2&REPT(" ",6),"_",REPT(",",255)),2*255,255),",",""),IF((LEN(A2)-LEN(SUBSTITUTE(A2,"_",""))),TRIM(LEFT(A2,SEARCH("_",A2)-1)),TRIM(LEFT(A2,SEARCH("2021",A2)-1))))))
Filename Example Download Link:
https://we.tl/t-B6x3RncMYH
Thanks In Advance!