troubleshooting Question

reading First record in a file and changing the delimiter from spaces to dots.

Avatar of mateinone
mateinoneFlag for Australia asked on
Windows Batch
3 Comments2 Solutions190 ViewsLast Modified:
i am creating a list of records in a script with a select statement and all i want to do is keep the top record and delimit it with fullstops.

so in the script I am getting.

5 3 2
5 3 1
5 2 6
5 2 4
5 2 1

All I want is for
5.3.2 to be sent to the log file %LOG%

i am guessing the easiest way is for the SQL to send the above output to a tempfile. and then to just read the top record in that file and replace spaces with .'s

Any help would be much appreciated.

Running on windows xp
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros