« Previous Next »

• 06-15-2007, 2:00 AM

  textfile to textfile - need help Reply Contact I am beginner - hope anyone can advise me. Have following textfile !Subject,!From,!Date,!Lines,!Body Subject:aaa From:bbb Date:ccc Lines:ddd Body:eee ......body lines..... !Subject,!From,!Date,!Lines,!Body Subject:fff From:ggg Date:hhh Lines:iii Body:jjj ......body lines.....    and want new textfile (ready to import into MS-Access):    "Subject","From","Date","Lines","Body" "aaa","bbb","ccc","ddd","eee","......bodylines....."CR/LF "fff","ggg","hhh","iii","jjj","......bodylines....."CR/LF    Possible in LogParser ? In advance thank you

  Tags: CSV and TSV input formats

• 06-15-2007, 3:45 AM

  In reply to

  	RE: textfile to textfile - need help Mark as Not AnswerMark as Answer... Reply Contact Unfortunately, Logparser cannot really deal with multine type records; your best bet is to use a short vbscript to reformat it Graham
  	Tags: CSV and TSV input formats

• 06-15-2007, 11:45 AM

  In reply to

  	RE: textfile to textfile - need help Mark as Not AnswerMark as Answer... Reply Contact Graham is correct, out of the box Log Parser won't do what you want.  That said, the format looks pretty simple.  If you can write a little bit of VBScript (or JScript), you could make a custom input parser (which would allow you to take advantage of the rest of Log Parser's features.
  	Tags: CSV and TSV input formats