Syntax Splitter.SplitTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function Description Returns a function that splits text into a list of text according to the specified delimiter. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Splitter Functions / Splitter.SplitTextByDelimiter
Syntax Replacer.ReplaceText(text as nullable text, old as text, new as text) as nullable text Description Replaces the old text in the original text with the new text. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Replacer.ReplaceText
Syntax Replacer.ReplaceValue(value as any, old as any, new as any) as any Description Replaces the old value in the original value with the new value. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Replacer Functions… Read More »Replacer.ReplaceValue
Syntax Record.HasFields(record as record, fields as any) as logical Description Indicates whether the record record has the fields specified in fields, by returning a logical value (true or false). Multiple field values can be specified using a list. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »Record.HasFields
Syntax Record.TransformFields(record as record, transformOperations as list, optional missingField as nullable number) as record Description Returns a record after applying transformations specified in list transformOperations to record. One or more fields may be transformed at a given time. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »Record.TransformFields
Syntax Record.FieldCount(record as record) as number Description Returns the number of fields in the record record. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.FieldCount
Syntax Record.RemoveFields(record as record, fields as any, optional missingField as nullable number) as record Description Returns a record that removes all the fields specified in list fields from the input record. If the field specified does not exist, an exception is thrown. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference… Read More »Record.RemoveFields
Syntax Record.AddField(record as record, fieldName as text, value as any, optional delayed as nullable logical) as record Description Adds a field to a record record, given the name of the field fieldName and the value value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record… Read More »Record.AddField
Syntax Record.SelectFields(record as record, fields as any, optional missingField as nullable number) as record Description Returns a record which includes only the fields specified in list fields from the input record. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.SelectFields
Syntax Record.ReorderFields(record as record, fieldOrder as list, optional missingField as nullable number) as record Description Returns a record after reordering the fields in record in the order of fields specified in list fieldOrder. Field values are maintained and fields not listed in fieldOrder are left… Read More »Record.ReorderFields