Results 1 to 3 of 3

Thread: Graphing from a $ delimited txt file

  1. #1
    Board Regular Belair58's Avatar
    Join Date
    Mar 2005
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Graphing from a $ delimited txt file

    Hello,

    I'm outputting a delimited txt file using $ as my delimiter from SQL server. This file will be output once every 5 minutes. I'm wanting to graph this data on a continuous basis. I'm trying to link it through Data / From Text/CSV, but it doesn't give me the option to choose the delimiter. I'm using Excel2016.

    I've looked at my options but I don't see anyway to do this. Has anyone else ever tried to do this?

    Thanks,

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,677
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Graphing from a $ delimited txt file

    This is in Office 365 Insider, so some of the details may have evolved since your version.

    Select the file, click Transform to open the Power Query editor.

    On the Transform tab, click Split Column, choose By Delimiter.

    In the Split Column by Delimiter dialog, choose Custom in the dropdown and enter $. My simple text file was even so simple that it guessed I wanted to use $.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  3. #3
    Board Regular Belair58's Avatar
    Join Date
    Mar 2005
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Graphing from a $ delimited txt file

    Thanks Jon,

    That was it.

    Thanks again.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •