Forum Discussion

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Power Query formula to get text after last comma if comma exist or keep text if no comma

Hi I have data stored in a column which sometimes has historic data split by a column , with latest data always after last comma. Sometimes though there is no historic data so then I would need to k...
Need Help
  • vivran22's avatar
    vivran22
    5 years ago

    @Pandadev

    You can then try Text After Delimiter

    image.png

    Use the following settings:

    image.png

    Cheers!
    Vivek

    If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

    Blog: vivran.in/my-blog
    Connect on LinkedIn
    Follow on Twitter

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
5 years ago

The code nearly works , but in some instances there are codes which can have different amounts of digits .

some are 5 digits , some 6 , some 7 etc. with this code , it looks like it is only giving last 6 characters .

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
5 years ago

@Pandadev

You can then try Text After Delimiter

image.png

Use the following settings:

image.png

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter