Add an character in front of each value in a list

[Will_Ryu]

I have a follow up request to my earlier query 

If I need an apostrophe in front of each value, how would I do that

I tried  - " '" & Text.Combine(Source [Name] ,"' ,") but the output I get only has an apostrophe for the first value like so 'Will', Sam', Jo',  

What I need is - 'Will', 'Sam', 'Jo', - an apostrophe in front of each  value

I can convert the list to a table, add the delimiters and then convert back to a list

Is there a more elegant way to do this?

Thanks

[asethi]

Hi @Will_Ryu 

Could you find a solution to your problem? If yes, can you please share it.

Thanks

[Will_Ryu]

Please try this

let
Source = Text.Combine(List.Distinct (Table[Field]) ,",")
in
Source

This will give you the list and you can then use it as needed

Let us know if it works

[tamerj1]

Hi @asethi 

Can you please provide more details about your requirement? Are you looking for a dax or M solution?

[asethi]

Hi @tamerj1 

I am looking for passing a excel table with text values to Text.Combine. Actually, my problem is exact same as what Will has mentioned above.

Thanks

[tamerj1]

@asethi 

I'm not asking to expose your data. Only provide one or two rows sample dummy data that simulates your original data along with expected results. Example

Source table column:

Name

Same,Jo,Roger,Tara

X,Y,Z

Happy,New,Old,Text

Expexted Output

Name New

'Same','Jo','Roger','Tara'

'X','Y','Z'

'Happy','New','Old','Text'

[Ashish_Mathur]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Combine(List.Transform(Text.Split([Name],","), each "'"&_&"'"),","))
in
    #"Added Custom"

Hope this helps.

[Will_Ryu]

thanks. @asethi  might find it useful

[tamerj1]

Hi @Will_Ryu 

is dax an option for you? If yes please provide a sample of 4 - 5 rows showing input and exprcted output. 

[Will_Ryu]

Hi tamerj1 Thanks for responding

I am not using DAX and would like to use M for this purpose

I understand that I could do it this way:

let
Source = #table({"Name"}, {{"Will"}, {"Sam"}, {"Jo"}, {"Roger"}, {"Tara"}}),
#"Added Custom" = Table.AddColumn(Source, "CST", each "'" &[Name] & "'"),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Name"}),
output = Text.Combine(List.Distinct (#"Removed Columns" [CST]) ,",")
in
   output

However, I was looking for a more elegant solution.

Thanks