+ Reply to Thread
Results 1 to 4 of 4

Power Query Text Combine separator

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    614

    Power Query Text Combine separator

    Hi, in MS docs Csv.Document a seperator is used in Text .combine, "#(cr)#(If)"

    I think these are ASCII or Unicode but I can't any help in how to use them or what each means. Also what is annoying
    is that whenever I type it in I get ; invalid literal, but if I copy past from stie it works, and I can't see any difference.


    Please Login or Register  to view this content.
    So I would really just like direction to more information on this,

    Richard.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Power Query Text Combine separator

    Carriage Return CR \r ASCII code 13
    Line Feed LF \n ASCII code 10

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    614

    Re: Power Query Text Combine separator

    Thanks,

    Richard.

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Power Query Text Combine separator

    Tks for the feedback, glad to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power query M code Text Combine wiht multiple delimiters
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 10-12-2023, 07:47 AM
  2. [SOLVED] Add separator while merging columns if condition met in Power Query
    By JyothiGrace in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2022, 09:15 AM
  3. Power Query - pivot and combine unique text
    By clogginfever in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2022, 06:52 PM
  4. [SOLVED] Combine tables in Power Query
    By Ebl in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-02-2021, 08:11 AM
  5. [SOLVED] Power Query Combine
    By kabseeker in forum Excel General
    Replies: 2
    Last Post: 05-05-2020, 10:12 AM
  6. Power query and decimal separator
    By mikla90 in forum Excel General
    Replies: 4
    Last Post: 07-11-2019, 01:47 PM
  7. [SOLVED] I do not have a combine option - Power Query
    By callumlmcgrath in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-08-2019, 06:24 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1