Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a folder with lots of xml files, each having names with whitespaces and special characters. e.g. c:\my file is wierd (strange, obnoxious, wow).xml
I am trying to run this snippet but am not able to parse files with symbols like brackets '('. How do I enforce [ ] escaping within a filelist() call? I've tried putting [ ] in both places but in vain...
let vFilePath = 'C:\Users\Atif\Desktop\KM PMO\Discovery\DataSource\Closure Document\*.xml';
for each File in filelist (vFilePath)
Load *
from $(File);
next File
Much Appreciated
A Business User
Atif
Hi
Its working properly.
Have a look at the example attched.
Only change the Root path.
Regards,
Kaushik Solanki
Atif,
Please can you provide the sample file? It'll be easy to work with the actual file.
Thanks,
DV
Thanks Deepak for the quick response.
Here you go.
Right now, the parser churns out the string part starting from '('.
For other files, ',' is the culprit. Since there are 100's of files, i want to somehow incoporate a generic solution like an escape character, am plucking the last set of hair strands
Hi
Its working properly.
Have a look at the example attched.
Only change the Root path.
Regards,
Kaushik Solanki
Thanks Kaushik,
However I got it solved with a similar code snippet...Appreciate your response.
let vFilePath = 'C:\Users\Atif\Desktop\KM PMO\Discovery\DataSource\Closure Document\';
for each File in filelist ('$(vFilePath)*.xml')
LOAD *
, filename() as Project_Name3
from [$(File)] (XmlSimple, Table is [myFields]) ;
next File