Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tgjones43
Helper IV
Helper IV

Look at specific character in a text string

Hi all

 

I have a text column where every value is a 12 character string of numbers and letters. I need some M code that checks whether the 7th letter is a number 0, that I can then incorporate into a conditional column function.

 

I assume Text.Middle is the one to use but I cannot find an example where it has been used for this purpose. Can anyone help?

 

Many thanks.

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

if Text.Range("Your string", 6, 1) = "0" Then 1 else 0

Connect on LinkedIn

View solution in original post

2 REPLIES 2
tex628
Community Champion
Community Champion

if Text.Range("Your string", 6, 1) = "0" Then 1 else 0

Connect on LinkedIn

Thank you @tex628 !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.