UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Ungroup Report, Access 2016    
 
   
EllenMarie
post Sep 13 2017, 08:49 AM
Post#1



Posts: 159
Joined: 4-August 10



Hello,
I have a text file that is effectively a grouped report (see attached). Is there a way to ungroup it?
Thanks in advance,
Ellen
Attached File(s)
Attached File  CleanSharedDrives.zip ( 9.15K )Number of downloads: 4
Attached File  GroupedTextFile.JPG ( 130K )Number of downloads: 5
Attached File  Ungrouped.JPG ( 196.7K )Number of downloads: 5
 
Go to the top of the page
 
bouncee
post Sep 13 2017, 09:32 AM
Post#2



Posts: 73
Joined: 5-August 05
From: Eastbourne, UK


Looks like you used the 'dir' command.

If you add parameters '/b' and '/a-d', you won't get the directory lines, just the filenames.
This post has been edited by bouncee: Sep 13 2017, 09:38 AM
Go to the top of the page
 
EllenMarie
post Sep 13 2017, 09:38 AM
Post#3



Posts: 159
Joined: 4-August 10



Thanks, but I'd like the file path.
Go to the top of the page
 
bouncee
post Sep 13 2017, 09:46 AM
Post#4



Posts: 73
Joined: 5-August 05
From: Eastbourne, UK


The filename is prefixed with the file path
Go to the top of the page
 
projecttoday
post Sep 13 2017, 08:32 PM
Post#5


UtterAccess VIP
Posts: 8,376
Joined: 10-February 04
From: South Charleston, WV


Test if the first column contains a date.

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th September 2017 - 12:11 PM