Peter Nordberg
asked on
Write and save a semicolon delimeted csv file
Hi,
I have this data that I would like to save to a semicolon seperated csv/text file.
The data result from the sql database looks like this:
EmployeeID aDay aMonth aYear WHours
1 1 12 2013 8
1 2 12 2013 6,5
2 1 12 2013 7
2 2 12 2013 4,75
I would like this to be written to the following format:
1;20131201;800
1;20131202;650
2;20131201;700
2;20131202;475
And then possible to save as a csv/text file to the harddrive.
Thanks for help!
Peter
I have this data that I would like to save to a semicolon seperated csv/text file.
The data result from the sql database looks like this:
EmployeeID aDay aMonth aYear WHours
1 1 12 2013 8
1 2 12 2013 6,5
2 1 12 2013 7
2 2 12 2013 4,75
I would like this to be written to the following format:
1;20131201;800
1;20131202;650
2;20131201;700
2;20131202;475
And then possible to save as a csv/text file to the harddrive.
Thanks for help!
Peter
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER