MS Access Query Parse String Into X Num of Column Based on X Num of Backslash in STring
Posted on 2015-01-08
Hi, I'm trying to parse a string in an Access query into it's own column. The field called "filename" has exactly 6 backlashes which I would like each element to be in 7 different columns. I'm open to creating a function so I can easily change the number of instances a backslash may occur. Thanks in advance for the help!
Column1 Column2 Column3 Column4 Column5 Column6 Column7
D: Imagining WebDocs Finance Vendor 2008 vsax_1021101723_001.pdf
D: Imagining WebDocs Finance Vendor 2009 intern_0814142131_001.pdf
D: Imagining WebDocs Finance Financial Reporting 2006 vsax_1021101723_001.pdf