How to limit the amount of characters in a field of a table?

[vitexo87]

I have a field in a certain table that most records have more than 20 characters each, and I need to use only the first 15, how can I do?

Obs: I tried to use the strokes to divide the column by characters but some characters disappeared with this as you can see in the pictures

[v-sihou-msft]

@vitexo87

To get fixed length of text from a text column, you can use Extract as @Vvelarde suggested, this will add a Power Query step in Query Editor like:

#"Inserted First Characters" = Table.AddColumn(#"Changed Type", "First Characters", each Text.Start(Text.From([Project Name], "en-US"), 15), type text)

Or you can add a calculated column and use DAX to achieve your goal.

First 15 = LEFT(Table[Column],15)

Regards,

[Vvelarde · Accepted solution]

@vitexo87

Hi,

You can Use Extract--First Characters--and Enter 15.

You can find this action in Transform or Add Column

Let me know if works.

Regards

[Anonymous]

hi, for my problem I have a colum with variety character length. Some are 13, letters, some are 10 and such. So I only want to extract the first 8 characters from a 13 letters character. However on the add custom column it says it cannout found the LEN or len, but no syntax error whatsoever. How do I solved this?