Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

.asc file to .txt file Expand / Collapse
Author
Message
Posted Thursday, March 15, 2012 2:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 7, 2013 11:25 AM
Points: 8, Visits: 61
Hi,

I have .asc file that comes from the client.

I need to convert this .asc to text files.

Are they zip files if they are how to unzip them. If not how to convert it to a text file.

Please advise on this
Post #1267867
Posted Thursday, March 15, 2012 3:09 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 12,887, Visits: 31,835
asc files are just plain old text files. open them up in notepad...you'll see the extension doesn't matter, the contents are plain text, the same way .txt files are.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1267889
Posted Friday, March 16, 2012 2:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 7, 2013 11:25 AM
Points: 8, Visits: 61
when i did that i got junk characters there . can u pls advise
Post #1268550
Posted Friday, March 16, 2012 2:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 12,887, Visits: 31,835
ramchandra2cool (3/16/2012)
when i did that i got junk characters there . can u pls advise


ALL junk characters or SOME junk characters? was it human readable when you opened it?

if all junk characters, you better check with the source you got the data from then; asc is short for ASCII, which imples plain old ascii text files.

if it's another file type that happens to be renamed with a misleading extension , you'll have to track the files from their source.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1268551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse